Skip to Content

Today – after a few Design Studio forum discussion – I thought I am going to share another little feature of our upcoming Design Studio Extensions (… I know still waiting for Christmas, but its coming soon…)

Very often you will end up in a situation where your data source could be used for more than just a single component, if Design Studio would allow you to define a view per component, but that is not possible today. A data source can be used for several components and you can select a measure for a specific chart, but you can not select the dimension.

So we added a “Data Utility” tool to our chart components.

DSX_DATASOURCE_ENH_001.jpg

Figure 1: Data Source

So lets start with the data source as shown in Figure 1, which contains as dimensions the Product Group, Product Category, and Product. In addition the data source contains Cost and Net Value as measures.

DSX_DATASOURCE_ENH_002.jpg

Figure 2: Chart

A default chart with all the measures and dimensions from the data source would look something similar like Figure 2 – which is not what we want.

DSX_DATASOURCE_ENH_003.jpg

Figure 3: Data Utility

So lets navigate to the Advanced Properties of our chart component and enable the Data Utility.

DSX_DATASOURCE_ENH_004.jpg

Figure 4: Data Utility

The Data Utility tool is then allowing me to specify which dimensions I would like to use for this particular chart and which measure I would like to use (see Figure 4 and Figure 5).

DSX_DATASOURCE_ENH_005.jpg

Figure 5: Select Measure

So after we selected the dimension – in this example the Product Group – and the measure, our chart looks like shown below in Figure 6.

DSX_DATASOURCE_ENH_006.jpg

Figure 6: Chart

DSX_DATASOURCE_ENH_007.jpg

Figure 7: Multiple Charts

So because I can specify this per chart I can easily have multiple charts – as shown in Figure 7 – pointing to a single data source (see Figure 8)

DSX_DATASOURCE_ENH_008.jpg

Figure 8: Data Source

I am sure there are some people that are now thinking that this is basically aggregating the numbers on the client – and yes that is what it offers and for sure there will now be people that are going to come back and say that this won’t work in the case of an exception aggregation of – for example – HR Headcount in BW – and that is correct……but……

this tool provides you with an option to aggregate data on the fly so that you don’t have to create multiple connections in Design Studio to achieve this.

Is it the perfect solution for everything – No it is not and the reason behind this is, that so far that the Design Studio SDK does not provide any information about the actual aggregation type of the measures. If that is being added to the meta-data, I am sure we can easily enhance this to leverage the new information.

For now we will give you the option to use some simple aggregation options and use a single source for several charts.

You can find out more about the Design Studio Extensions here.

To report this post you need to login first.

6 Comments

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

  1. Carlos Weffer

    Hi Ingo

    Thank you for sharing Visual BI data utility feature in chart components. Is it available now? if not when is expected to be available?

    As you mentioned it is quite often that we find ourselves in the situation where using the same data source for different components will certainly simplify the application development. Maintaining a single data source rather than multiple ones also delivers a better performance without the hassle of having to use processing groups.

    One more aspect is that the New Filter Line component could be applied to several chart components at the same time.

    Does SAP have in their Design Studio roadmap the option to define data source views per components?

    Thanks Carlos

    (0) 

Leave a Reply