Skip to main content
jrk
Newcomer
Apr 20, 2023 9:05 PM UTC
Solved

Reporting the First Value for Each Time Period

Is there a way to report first Value for Each Time Period similar to TB First setting in Essbase?

M1 .. M12

M1 Value to be shown for FY

JackLacavaAnswer
Employee - Sage
Apr 21, 2023 10:08 AM UTC

There are a number of substitution variables to point to that. From the Design and Reference guide:

  • POVTimeFirstInYear - This is the same as T#POVFirstInYear, T# W1, T#M1, T#Q1, or T#H1 based on the Input Frequency of the Scenario.
  • WFTimeFirstInYear - This is the same as T#WFFirstInYear, T#W1, T#M1, T#Q1, or T#H1 based on the Input Frequency of the Scenario
  • CVTimeFirstInYear - in Cube Views
View in thread

2 replies

Employee - Sage
JackLacavaEmployee - SageAnswer
Employee - Sage
Apr 21, 2023 10:08 AM UTC

There are a number of substitution variables to point to that. From the Design and Reference guide:

  • POVTimeFirstInYear - This is the same as T#POVFirstInYear, T# W1, T#M1, T#Q1, or T#H1 based on the Input Frequency of the Scenario.
  • WFTimeFirstInYear - This is the same as T#WFFirstInYear, T#W1, T#M1, T#Q1, or T#H1 based on the Input Frequency of the Scenario
  • CVTimeFirstInYear - in Cube Views
    jrkAuthor
    Newcomer
    May 11, 2023 3:57 PM UTC

    Our CV has other account types, we used the row override function along with the variable

    Row Range -> Row1 (This is where the Beg Balance account is in the CV)

    Member Filter -> T#WFFirstInYear

    Terms & ConditionsAccessibility statement