MENU
    Pre-Defined Custom Members/Formulas
    • 1 Minute to read
    • Dark
    • PDF

    Pre-Defined Custom Members/Formulas

    • Dark
    • PDF

    Article summary

    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.


    Was this article helpful?