on 2022 Jun 09 7:00 PM
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?
Thanks
srini
hi William,
Thanks for your feedback. I am new to SAC and doing a Poc.
In this case, what do you suggest? do I need to duplicate all the intermediate calculations for LC into GC? Or the classic model has a better way to achieve.
Thanks
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I guess those calcualtion can be created with account formula, so you don't have to dpulicate those calcuations for currency conversion with measure .
Hi srinivas.anilkumar,
As clearly stated in online help. caluclated measure is NOT supported as source for currency conversion.
Best regards, William
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
11 | |
10 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.