When we create new chart in SAP Analytic Cloud, we need to select measures and dimensions to be shown on the chart (or instead of just selecting the measure, we can create calculated one). There is another option – use Input Control and let Story viewer decide, what measures and dimensions he would like to see. This is a great way to improve Story interactivity.
Please note that all screens are taken based on Q2.2020 SAC release – some options can be changed with future SAP Analytic Cloud releases.
In the example below, the Story user can select Measure and Dimension from input controls.
Using Input Control Measure / Dimension
To enable measure / dimension selection from input control, just open Builder tab, select Add Measure and scroll down to the list of measure to select Create Measure Input Control.
On the next window define which measures will be available on the input control.
That’s it – the input control measure is ready to be used on your chart. You can still change some settings of input control or change the name of it. Important – the name defined on the input control will be then visible on the list of all measures.
In the same way, you can add a Dimension Input Control – hit Add Dimension, scroll down, and created Dimension Input Control.
Input Control Measure / Dimension for many widgets
When input controls are created, you can reuse them on many charts and widgets. It means that using the same input, you can control many charts. When you add new chart to your Story, just select previously created Input Control measure or dimension.
In the example below Input Measure is used on both charts. However, the Tree Map dimension – Country – is not dynamic.
Input Controls measures and dimensions can be utilized not on only on charts.
For example, it can be selected as Reference Line measure:
It can be also part of Dynamic Text:
Or it can be used to control the table:
Once created Input Control Measures and dimensions are available for the whole story – they are not limited to just single-story page.
Live data and Acquired data
It is important to mention – and it is not always obvious – that Input Control Measure / Dimension are available for stories based on acquired data and for Live Data Stories. For Live Data Stories the functionality is not limited anyhow.
Summary and I wish
Based on SAP Analytic Cloud road map, I assume there is no further improvements planned for Input Control Measures and Dimensions. However, it would be nice to have some small amenities:
- setting the name on the initial screen (where measures / dimensions to be included are selected);
- Possibility to change the input control orientation (vertical / horizontal);
- On the measure / dimension list it should be immediately visible which one are created by input control.
Still using input control measures in dimensions is attractive when you would like to give more flexibility to Story viewer and increase your dashboard interactivity.