Planning - Mdx in RPT cube

Summary:

Mdx impacts the performance time due to aggregation of data for a calculated scenario member.

Content (please ensure you mask any confidential information):

We are creating a calculated scenario member in planning instance named AOP @ PY Fx which multiplies Local Reporting values (for OEP_Plan scenario) of entities with the Prior Year FX Average Rates. To determine the functional currency, every entity's UDA is used in the logic. But, we want the calculation to be aggregated to all subsequent levels of entities in the hierarchy and the logic to only execute for level 0 entities.

IF statements are used in the logic to execute the logic for level 0 entities only, then