Displaying a dynamic number of tables, traffic lights and charts

[lawrence_chan2]

Hi Design Studio experts,

We have a requirement to display a dynamic number of tables, traffic lights and charts, for each value in dimension and display them horizontally in Design Studio, using BW Bex query as data source.

ie: Displaying a chart, table, and a traffic light for each value in the dimension and display charts side by side.

The idea is similar to doing a Section in WEBI, but horizontally, and include 3 objects – chart, table, and traffic light.

The challenge is the values from dimension are dynamic, depends on what selection parameters are used to run the query.

As a mockup example for illustration purpose, let say the query returns Sales by Quarter by Product when running for year 2014.

There were only 2 products in 2014, and the dashboard should show 2 tables, traffic lights and charts side by side / horizontally, displaying Sales for each product.

Then some new products are added in 2015.  The query now returns 4 products when running for year 2015.

Then the number of objects on the dashboard will change to 4 side by side.

The same goes on 2016, if there are 6 products, the dashboard will then show 6 "sets of objects".

I have raised a cut down version of this question in the past (but for charts only), and I know the charts requirement alone can be met using Trellis Charts in InfoCharts components in Design Studio 1.6. (Thanks Tammy Powlas for guidance).

The challenge is to apply the same logic on table and traffic light, along side the charts.

Is this feasible in Design Studio - through other components or perhaps scripting?

Can anyone help point me to the right resources or direction? or any sample code will definitely be appreciated.

Regards,

Lawrence

[Former Member · Accepted solution]

Hello,

Quick question: how many different charts do you intend to display ? 8 ? 20 ?

If you have a lot, you will have also to think about how to display them.

To my knowledge, I do not know any component available to do this.

That being said, I implemented something similar.

I created 4 panels, with inside 4 graph. I named them with meaningful names:

• PANEL_C0, CHART_C0
• PANEL_C1, CHART_C1 ...

Now, with a script and the Component Manager from the SCN Community package, you can find and loop on them. You will only need to read your data (Either with getData or the new Data Iterator from Mike in the 3.0 SCN Package) and restrict the charts using data selection, change the title etc ... all by script.

If you have more than 4, you can implement yourself a page handler to change the different materials displayed. Always the same 4 panels and graph, but you juste change the selection according to your page number. For instance, page 0: 4 first material. If the user select page 2: Material 4+1 to 4 * 2 = 8. Again: script.

For indicator, create 4 texts, and assign dynamically a cssClass corresponding to the value range (1 to 20%: class ruleGreen ...)

I assure you it worked, but it requires somebody able to script it and CSS !

[lawrence_chan2 · Accepted solution]

Thank you Franck for your help!

There should be less than 10 charts, mostly 2-6 charts.

I will check out the component manager in 3.0 SCN Package.

I suppose the same logic can be applied on tables (dynamic number of tables)?

Regards,

Lawrence

[Former Member · Accepted solution]

I suppose as well. You'll have to check if the data selection method is available on the crosstab now ( I think they added it in 1.6).

It will require to display the value though ... But you could hide it with CSS maybe

Or use Advance Data table from SCN Community Package (not soooo advanced) but if it does not the trick, you could always use the library and create your own extension with it.

A customer did, and it now support lots of thing (as well as hiding/enaming columns, and of course dataselection).

[lawrence_chan2 · Accepted solution]

Thank you Franck!

[Former Member]

Hi Lawrence ,

This explanation was very good  as part using  dynamic number of tables, traffic lights and charts, for each value in dimension and display them horizontally in Design Studio, using BW Bex query. if we are doing in Webi report design we will not able to provide values from dimension are  not dynamic.

Am i  right , Can we  provide dynamic value for dimension  ?.

Regards

Asish

[lawrence_chan2]

Hi Asish,

In WEBI, you can produce a dynamic number (based on value in dimension) by using a section.

The difference is it can only go vertical (while for my requirement it needs to go horizontal). 

Regards,

Lawrence