Forum Discussion

jrk's avatar
jrk
New Contributor III
2 years ago

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
Methodology
  • JackLacava's avatar
    JackLacava
    2 years ago

    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
jrk's avatar
jrk
New Contributor III
2 years ago

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