SAC - Calculated Dimension in Modeler

[corrfpa]

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:

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

Thank you for your help.

[William_Yu1]

Hi corrfpa, 

   There is no calculated dimension concept yet in modeler. 

Best regards, William 

[Vasu_Sac]

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.