- 1 Minute to read
- Print
- DarkLight
- PDF
Pre-Defined Custom Members/Formulas in Dashboards
- 1 Minute to read
- Print
- DarkLight
- PDF
The Custom Members below are pre-defined in each Reporting Area (cube) where the Dashboards module is enabled. Reporting areas are; Financial and Workforce.
Scenario:
Actual vs Budget Variance
Actual vs Prior Year Variance
Actual vs Forecast Variance
Actual vs Budget Variance %
Time:
Periods To Date
Compare Last Month
Compare Last Qtr Same Period
Compare Last Year Same Period
Trailing 12 Months
Rolling 6 Quarters
Rolling 12 Months
Trailing 3 Years
Measures:
Half Year To Date (HYTD)
Custom Members are populated for the Time and Scenario dimensions using substitution variables. So, for example, if you click Edit for the Compare Last Month Custom Member, you will see that the @CURMTH@ substitution variable is used to build the formula.