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
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
