How to write back a calculated measure in data model in SAC Planning?

[roniabhi]

Hi,
I have created a calculated measure for SAC planning. Is it possible to write back this calculated measure in the data model? I want this measure in cross-model data action, and apparently we can only use the measures that are present in the data model for cross-model data action. Calculated measures are not appearing in cross-model data action.

[ericliefke]

We solved a similar problem by creating a measure similar to the calculated measure in the model to be copied to. The difference was that the original measure was calculated, the one to be copied to not.

So when you run the cross-model-copy you have the measure as "fixed" measure and can use all functions of data actions etc.

Also the calculated measures appear in our cross-model-copy options to be copied from.

BR
Eric

[anatmc]

Hi Eric, facing the same issue. Created a new model and a fixed measure on the second model but when trying to cross model copy either with standard step or using LINK I'm getting an error saying: "Cannot use "XXX" measure since it is calculated or conversion measure". Do you have an example for a code I can use ?

[N1kh1l]

roniabhi

Calculated Measures are on the fly calculations and results are not persisted in the model. For Data Action only normal measures are supported as target currently. You might have to create a normal Measure in target before you use cross action copy.

There are influence request which you should upvote so that the feature is added to SAC

Allow Calculated Measures in Data Action Advanced Formulas

Copy data to another model using calculated measures or hierarchy nodes.

Ability to use Calculated Accounts in Data Actions

Br.

Nikhil