SAP Analytics cloud Planning - new model for bringing both LC and GC data

[former_member627318]

Hi all.

we are facing issues in trying to implement the following sac planning scenario.

Requirement details -

a. we need to source both Local currency (LC) and Group currency (GC) data (actuals only) of a single measure say (CAPEX) from BW to SAC.

b. Once data is imported, then we need to perform some calculations in sac (currently account based)

c. The output of these calculations will give two KPIs - Reported CAPEX and Benefit CAPEX

d. Business colleague should be able to perform the adhoc analysis via data analyzer ( slicing/ dicing on different combinations of dimensions etc.)

e. Business colleague should be see the different toggles ( say currency toggle, measure input control for CAPEX, Reported & Benefit CAPEX and other sac standard input controls)

Solution on New Model without the account dimension (Measure based) -

a. Two base measures ( say CAPEX_LC & CAPEX_GC) to be used for both LC & GC data

b. Calculation measure to have the calculations ( lookup() etc.).

c. as an output, we have now 4 measures - Reported_CAPEX_LC, Reported_CAPEX_GC, Benefit_CAPEX_LC & Benefit_CAPEX_GC that shows the correct value.

Issue-

a. we are not able to have the currency/ rate input control ( say on click of currency input control - I can choose from "GC", "LC" or any other rate) that could drive the data in a table with the selection of the KPI from the measure input control ( measure input control should only show the Reported CAPEX, Benefit CAPEX & CAPEX - the reason for the same is business user does not care about the nature of KPI whether it is in GC or LC)

b. we were able to get this required toggling experience in the classic model with one single measure say CAPEX_LC and then create the required rates via the cross calculation conversion and then have them populated via the currency input control along with the measure input control ( now we are only talking about LC or GC)

Please refer to the attached screenshot.

report-1.png

report-3.png

report-2.png

Questions -

a. With the pre converted actuals enabled on the classic model - we need to show Actuals at a different rate.

Can we show Actuals at a different rate ?

b. How can we implement the scenario with new model ( measure based model)

Let me know your thoughts on the same.

[William_Yu]

Hi aditya_garg,

Probably I didn't fully understand your problem yet, I see your requirement should be covered by new model.

To your questions:

a. With preconverted actual in classic model, thought GC(default currency value) is imported from source, but you still can create cross calculcation to convert either currency or default currency to any target currency.

b. With new model, you just load LC into default measure and GC(pre-converted) into a dedicated measure in model, for additional target currency/rate, you can either create currency conversion measure in model or in story(with calculated measure), and user can toggle between different measures with measure input control.

Best regards, William

[former_member627318]

Thanks william.yu for checking and then replying on this thread.

Once we create two base measures ( CAPEX_LC & CAPEX_GC) in classic model or in new/ measure based model, we have 4 measures as an output of the calculations which are Reported_CAPEX_LC, Reported_CAPEX_GC , Benefit_CAPEX_LC & Benefit_CAPEX_GC.

Problem is : In new model, how we can still get the currency toggle & measure based input control which can both drive the data to be shown in the table.

On your answers -

a. With preconverted actual in classic model, thought GC(default currency value) is imported from source, but you still can create cross calculcation to convert either currency or default currency to any target currency.

we need to show the CAPEX_LC of Actuals at a different rate.

once we create those cross calc. currency conversion rate and bring the CAPEX_LC underneath it, it still show the original CAPEX_LC value and not the converted value based on the definition of that rate.

b. With new model, you just load LC into default measure and GC(pre-converted) into a dedicated measure in model, for additional target currency/rate, you can either create currency conversion measure in model or in story(with calculated measure), and user can toggle between different measures with measure input control.

Yes, we can create those and infact we have already created them but we are not able to have the similar toggling experience ( both for rate & measure based input control).

we are looking for a solution, where we can put the cross calc.on top of the measure based input control in the table.

The advantage it brings is that you have now two drivers to control the data and user likes the toggling exp.

with the new model conversion measures, we can still create those rates but still they are come in the measures and not in the cross calc.

[William_Yu]

Hi aditya_garg,

As I said， I didn't fully get your use case. Not sure what scenario you want to achieve by having user select but measure and cross calculation.

For GC measure, no matter what user select, it will only show one dedicated currency value.

For LC measure, each data row may have different currency according to the currency baring dimenison( in your case project)? So you want for LC measure, user can also choose different target currency?

Probably you could provide a desire table layout and user flow. Or please send me email via william.yu@sap.com, we can discuss offline.

Best regards, William