Reporting the First Value for Each Time Period

[jrk]

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

[JackLacava · Accepted solution]

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]

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