Calculation: difference from & restricted
Difference From calculations
SAP BusinessObjects Cloud supports different types of calculations that can be defined from within the calculation editor. One of the newer types here is the Different-From calculation type. This different-from calculation allows you to calculate the difference in value of one attribute compared with the value of the same attribute in a previous period. The difference-from calculation requires Month as lowest time-grain.
In below example I show you how to use this type of calculation to calculate the difference in value for December compared to the previous period, in this case being November.
The nice things about the difference-from calculation are:
-
the possibility to combine the calculation with input controls so the end user can choose the core attribute that is the “base” for the calculation
-
within the calculation definition one can specify the number of N periods that need to be used for the comparison periods. If I choose N=1 than December will be compared to November. If I choose 5, than December will be compared to July.
Restricted Calculations
How would you feel I I say that SAP BusinessObjects Cloud allows its aggregation on restrictions in dimensions that you can set as a user? That would be great, not? With the restricted calculation it is possible. Imagine I have product A, B and C that is sold in many countries during many time periods. Using the restricted measure, I can define that only product A and C needs to be embedded in the aggregations, and product B needs to be neglected. Also this time the SAP development team showed their smart-brains by adding the possibility of an input control as part of the restricted calculation. So the end user can now choose themselves what is included and what not. Smart !! Below you can see how it works.
Forced Color coding synchronization & data point filtering
On the data visualization part there are numerous very strong features and two I want to highlight:
Forced color coding synchronization allows you to ensure that the value a certain attribute is always in the same color when used in any graph on your storyboard. In the example below, I show how France always has the same purple color and Italy always the same green color. This enormously helps bettering the consistency of your dashboard. Even better, it helps your end user better understand your dashboard since the same attribute is easily “recognized” in any visualization !
Data point selection using the linked analysis feature is now also possible when using a GEO map. The linked analysis is the very powerful feature allowing cross-chart filtering and selecting. Clicking on a data point in chart A filters the accompanying or linked charts B, C, D …. Now one can do the same clicking a data point on a GEO map. Halleluja, nice !!
Thanks Iver, much appreciated! A good step up into the new paradigm 🙂 Cheers, H
Thanks Henry. I left an idea for a best practice guide for calculations in the BOC Idea place. Hope it is going to be accepted. There is a similar guide available for Lumira which proofed its value tonlany customers
Hello Iver , do you know if SAP BOC have the ability to manage Pareto chart without the complexity of the calc and sort on elements?
not for the moment