SAP Analytics Cloud Feature Highlight – Linked Analysis
Over the next several weeks and months you will see regular “Feature Highlight” blogs from my side, outlining some of the key capabilities of SAP Analytics Cloud with some simple steps on how you can leverage those features with some sample data or with your own data.
We are starting off with the Linked Analysis functionality. Linked analysis allows you as Story Designer to enable your user (Story consumer) to filter data in multiple charts at the same time without creating a real user filtering experience but instead you provide your users with a very simple chart or table interactivity.
We create a new bar chart based on the BestRunJuice_SampleModel and we visualize the Discount broken down by Product.
As our second chart – based on the same data model – we visualize the Discount broken down by Sales Manager.
We now select the first chart – Discount per Product – and navigate to the Linked Analysis option.
As part of the Linked Analysis we can now configure the behavior.
We can choose between
- Linked Item Set + This Chart: This will then share the filter and navigation steps between the selected visualizations which are based on the same model or use linked dimensions, and we also have the ability to use a selection interactivity to act as filter.
- Entire Story: This will then apply the filter to all elements of the story that share the model or share linked dimensions.
- The option Linked Item Set and Excluded Items allow us to define which of the available visualizations are part of the linked set.
For our example we will enable the option Linked Item set + This chart and also enable the sub-item Filter on data point selection.
With this option enabled we can now select a data point in the left chart showing the Discount by Product and with each selection the right hand chart showing the Discount by Sales person will be filtered to the selected element.
As next step we are adding a third chart, which shows the Quantity Sold broken down by Date.
In this case we would like the third chart not to be impacted by the Linked Analysis, so we would like to exclude it from the Linked Set.
We click on Linked Analysis in the Tools section and we select our third chart.
By default the chart is included into the linked set.
All we have to do is to uncheck the item Include this item in set and the chart will be moved to the Excluded Items list.
With a few steps we created now three charts, where 2 charts are interacting based on a simple selection (instead of a full filter dialog).
In the next blog we will use the table in combination with Linked Analysis to select the measure for our charts.