Comparison between two versions based on user selection in SAP Analytics Cloud

[former_member739057]

Hello Experts,

I am working on Integrated Financial Planning using SAP Analytics Cloud. I am using version 2021.20.12.

I want to compare two versions in SAC based on user selection.

For example, if the user selects "Latest Forecast 1" version, then it should be compared with "Current Budget" version. Similarly, if the user selects "Latest Forecast 2", it should be compared with "Latest Forecast 1"; and "Latest Forecast 3" should be compared with "Latest Forecast 2". (By comparison I mean, in the table only those two versions and variance should be visible at a time).

Can anyone please let me know how I can achieve this in SAC?

Thanks in advance!

Regards,

Priya

[JefB · Accepted solution]

Create a version property containing the version ID that you want to compare.
Then create a table widget temporarily with forecast layout (instead of crosstab), which will enable you in version dropdown list to add a calculation input control into your story.... only in this case you will see a formula field and you can use a FIND() function to retrieve the version ID from property.
Finally, create a restricted measure that references your new calculation input control.

[JefB · Accepted solution]

See also help documentation here:
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/3e2ad3b322494a4cad6b1a1eb...

[former_member739057 · Accepted solution]

Hi Jef,

Thanks for the reply!

I have tried this approach and it works fine.

But, is it possible to achieve this in "Cross Tab" and not in "Forecast Layout"?

Regards,

Priya

[JefB · Accepted solution]

Yes, the forecast layout is just temporarily needed to create the calculation input control. Afterwards can be deleted or changed back to crosstab.

[j_zeeuw · Accepted solution]

Hi Jeff,

Does this still work? When I switch back to the cross-tab Im not able to select the created version input control..

Kind regards,

Jeroen

[JefB · Accepted solution]

No, this approach seems broken in the new optimized mode.

Nowadays I use cross calculations (new measure model), where one or more version input control can be created & also used in scripting for example with the Input Control .setSelectedMembers() API, and the planningmodel getMembers() API.
Although the latter also started to break due to SAP suddenly disabling that API for the version dimension.
So, to be honest, I do not know what to recommend.

[bosingh]

guys,

I have a requirement something like this..I want to compare etween versions. example I have amount. I want to have 2 filters 1.Version, Tiime period and 2.Version, Time period. When I enter value for amount it shoudl show V1, V2 next i will do variance, Can some one suggest a best fit answer for this...

[Former Member]

Greetings priyakulkarni

The following blog might address your topic.

What’s New in Integrated Financial Planning | SAP Blogs

Look for Simulation Cockpit – SAP__FI_BPL_IM_CROSS_SIMULATION_COCKPIT

Hopefully, it will shed a light on your topic.

Cheers,

Luis

[former_member739057]

Hi Luis,

Thank you for the reply!

I checked the blog, but "SAP__FI_BPL_IM_CROSS_SIMULATION_COCKPIT" is an Analytic Application. I am looking for a solution that can be applied in SAC planning story. Is there any way to do it?

I tried to create two cross calculations with two input controls for versions (Version1 and Version2). But, I need a solution where the user can select only one version and the table should display comparison with the relevant version automatically. (For e.g., if the user selects "Latest Forecast 3" version, then the table should automatically display the comparison between "Latest Forecast 3" and "Latest Forecast 2" versions.)

Regards,

Priya