cancel
Showing results for 
Search instead for 
Did you mean: 

Currency conversion not enabled on a Calculated Measure in Measure Based Model

srinivas_anilkumar
Active Contributor
0 Kudos
550

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

srinivas_anilkumar
Active Contributor
0 Kudos

Hi,

Thanks. I tested it and it works as expected in the classic (account based) model.

Regards

Srini

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

A side remark, you don't have to use classic model in this case, in new model you still can have account dimension with account formula, in addition, you can also have multiple measures for on the fly currency conversion or stored currency conversion.

Accepted Solutions (0)

Answers (2)

Answers (2)

srinivas_anilkumar
Active Contributor
0 Kudos

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

William_Yu
Product and Topic Expert
Product and Topic Expert

I guess those calcualtion can be created with account formula, so you don't have to dpulicate those calcuations for currency conversion with measure .

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi srinivas.anilkumar,

As clearly stated in online help. caluclated measure is NOT supported as source for currency conversion.

Best regards, William