Forum Discussion

Keyser_Soze's avatar
Keyser_Soze
Contributor
2 months ago

Attribute Dimension | Vary by Time & Scenario Type

Is it possible to make an attribute member run a comparison based on the stored text attribute for a specific Time Period ? Ex: - Text8 & 2023M1 =>  FO_SUPM       - Text8 & 2023M6 => FO_HYPM B...
Cube View
Reports
  • T_Kress's avatar
    T_Kress
    2 months ago

    Attribute members do adhere to time and scenario dependencies.  One word of caution though is if a text property changes mid-year, the YTD data will be shown under the new text property after the YYYYMM in which the text changes.  By this I mean the following:

    If it is FO_SUPM in M1 and then becomes FO_HYPM in M6, the data will show periodic and YTD as FO_SUPM through M5, but the full YTD amount will then show as FO_HYPM from M6 on.

T_Kress's avatar
T_Kress
Contributor III
2 months ago

Attribute members do adhere to time and scenario dependencies.  One word of caution though is if a text property changes mid-year, the YTD data will be shown under the new text property after the YYYYMM in which the text changes.  By this I mean the following:

If it is FO_SUPM in M1 and then becomes FO_HYPM in M6, the data will show periodic and YTD as FO_SUPM through M5, but the full YTD amount will then show as FO_HYPM from M6 on.