Reporting the First Value for Each Time Period

jrk
New Contributor III

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

1 ACCEPTED SOLUTION

JackLacava
Community Manager
Community Manager

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 solution in original post

2 REPLIES 2

JackLacava
Community Manager
Community Manager

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
New Contributor III

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