Pre-Defined Custom Members/Formulas in Dashboards

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.