Question Re: SAC - Calculated Dimension in Modeler in Technology Q&A

SAC - Calculated Dimension in Modeler

corrfpa — Mon, 22 Jul 2024 22:00:29 GMT

Greetings,

Does the possibility exist to create a calculated dimension in the modeler itself similar to how we can create calculated dimensions in stories?

The drawback with calculated dimensions in stories is that they are not accessible to other stories or in the excel add-in.

The drawback with calculated columns in import jobs is that if parameters are updated, a reload of historical data is needed, so it's pretty static.

Is there another option to have the following with changing attribute members and not needing to reload historical data?

1. New dimension 3 calculated based on the below logic:

If attribute 1 of dimension 1 is not blank, attribute 1 of dimension 1. Else
If attribute 1 of dimension 2 is not blank, attribute 1 of dimension 2. Else
dimension

Thank you for your help.

Re: SAC - Calculated Dimension in Modeler

William_Yu1 — Wed, 24 Jul 2024 01:15:51 GMT

Hi corrfpa,

There is no calculated dimension concept yet in modeler.

Best regards, William

Re: SAC - Calculated Dimension in Modeler

Vasu_Sac — Mon, 14 Apr 2025 12:20:26 GMT

Hi @William_Yu1, So, Understood that calculated dimension concept is not available at Model level. so how to achieve in Excel Add -in. Is it not possible to create calculated dimension concept in Excel Add -in.