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.
Thanks for some great blogs
One question is it possible to create multiple linked item sets? Meaning that:
Set 1: Chart 1 filters Chart 2 but not Chart 3
Set 2: Chart 3 filters chart 2 but not Chart 1
So I per chart can define which chart to filter - the same functionality as for input controls
you have one "Linked Set" and in there you can decide which components are part of the Linked Set and which are not part of it.
So you can decide which elements are included, but I am afraid you wouldn't be able to configure those 2 different scenario that you describe. You would have to agree to one "linked set" of components.
Ingo Hilgefort, SAP
When using linked analysis on a chart/table, I noticed that filters applied to this charts/tables but not visible as dimension on the chart are not passed to the target charts/tables.
Same when linking an input control to this chart/table -> any filter applied via this input control is ignored when triggering the linked analysis.
As an example if my chart shows sales per product category and is filtered on 2018, when enable linked analysis, if the destination analysis shows sales per region without filter on date, when selecting the specific product category, the destination chart will show sales per region for this category but for all period, not only 2018.
This is often OK, but in some cases, it creates confusion. Do you see a way to make possible to take these filters into account when using linked analysis (or hyperlink between pages which is an even more valid cas for this requirement)?