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

Best answer by JackLacava

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

Answer

OneStream Employee

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

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

Sign up