hi SAC experts
I am facing a weird issue w.r.t ccy conversion in SAC based on a new measure based model.
Here is my requirement;
1. I have entity as a dimension that has currency associated to it.
2. Certain base measures such as price, ( market price, oper. Cost etc), cost, etc are loaded into model in respective local currencies
3. There are several calculated measures ( avg price, weighted avg, total price, etc) that require both in group currency and local currency.
4. LC calculations sometimes has 10 to 12 intermediary calculated measures to be created with exception aggregation to derive the final kpi
5. I do not have the option to use the final calculated measure (LC) to convert to GC. Is there a way to achieve this? Either in model or story?