Skip to Content

As part of Cloud for Analytics, SAP implemented a few concepts based on the rules published by Hichert as part of the standard products. To be able to use those concepts your data model needs to meet a few requirements:

 

  • You need to enable the model for planning
  • You need to have at least one time dimension (requirement for the planning enablement)
  • You will need a dimension to differentiate the values – for example Actual and Budget

 

Assuming your data model does fulfil those requirements, you can then easily use those features based on the Hichert rules.

 

In the first step I am configuring a Column / Bar chart and I am using the key figure Revenue for the measure axis.

C4A_March_27_005.jpg

 

For the Categories I am choosing my time dimension – in this example Calendar Month – and for the Color I can then choose dimension “Category” which is the dimension separating the key figure values in Actual and Budget values.

 

C4A_March_27_006.jpg

 

The end result is a column chart for 24 months showing the actual values in black (filled) and the budget values in white (to be filled). Yes – the values from the past should be color coded differently but to be honest I was not able to find a way in Cloud for Analytics to define color / pattern for specific members and as I am showing 2 years of data in the chart there was no particular option to setup three different color / pattern option with black for actual, grey for past, white for future.

 

Because we have a time based chart and because we do have the Category in our model, we are also able to setup a variance.

 

 

C4A_March_27_007.jpg

 

In my example I am configuring the variance to show the difference in absolute values.

 

C4A_March_27_008.jpg

 

 

As you can see – assuming you do have the right information in the underlying model, you can make use of those features following the Hichert rules.

 

My wish here would be that in the future we will be able to use the concepts also without those specific requirements towards the data model itself and for example uploading data from a Google Sheet that contains actual and budget numbers and use these features without having to have a “Category” dimension in the actual model.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply