SAP Analytics Cloud In-story Calculation Series – Blog8: Show the restricted values of all account members in different granularities of time

This is the last blog post of a blog series with the intention to guide you towards success with In-Story Calculation. If you are interested in learning more about In-story Calculation, please check out our blog series here.

Scenario:

Your finance department wants to dynamically view the restricted values of all account members in different granularities of time: current month, current quarter to date, and current year to date.

In-story Calculations:

• Cross Calculation

In most financial scenarios, there are numerous account members that need to be restricted by different granularities of time. For example, current month, current quarter to date, and current year to date, etc. However, it is time-consuming to manually create a dedicated Restricted Measure for each account member. To better address the requirement from your finance department, you can apply Cross Calculations such that your end users can get the desired results.

We start by selecting the Cross Calculations checkbox in the Builder panel:

We then select Add Calculation from the Cross Calculations column:

Next, we define 3 Restricted Measures for the current month, current quarter to date, and current year to date in the calculation editor respectively:

The below screenshot presents the result: besides the Account Values, there are 3 restricted results in different time granularities. This blog was written in April, the first month of Quarter two, so the results in column “Current Month” and “Current Quarter to Date” are identical.

We can also choose to Add Cross Calculation Input Control in order that your colleagues from the finance department can flexibly pick the time granularities and obtain the restricted results accordingly.

Please note that you need to uncheck all the newly created Restricted Measures in the filter for Cross Calculations. Otherwise, the “Add Cross Calculation Input Control” setting won’t work as expected.

Uncheck all the newly created Restricted Measures in the filter for Cross Calculations

The final view could look like this:

Now the filter for Cross Calculations should look like this:

Did you gain a deeper understanding of the Cross Calculation after reading this blog? Do you expect more examples for In-story Calculations of SAP Analytics Cloud? Leave a comment to share your feedback with us. Hope you enjoy this blog series!

* The product interface may vary depending on the product version