Skip to Content
Author's profile photo Ingo Hilgefort

SAP Design Studio and charts and data sources

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.

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      Hi Ingo,

      You raise a good point about the lack of aggregation type identification in the SDK.  The need for it was also discussed in this Get aggregation method when retrieving a ResultSet property post.

      Regards,

      Mustafa.

      Author's profile photo Carlos Weffer
      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

      Author's profile photo Vi Tran
      Vi Tran

      Carlos it is available now.  They are currently at v1.3 with v1.4 coming here in the next month or so from the latest update I've gotten.

      http://visualbi.com/

      Author's profile photo Carlos Weffer
      Carlos Weffer

      Thanks Vi

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Carlos,

      the tool is already available since our first release. All our charts do support it.

      regards

      Ingo Hilgefort , Visual BI

      Author's profile photo Carlos Weffer
      Carlos Weffer

      Thanks Ingo.