Display top results in a Design Studio Info Chart

[former_member234473]

Hello All,

I am using Design Studio 1.6 SP02 (16.22) to create an Info Chart (Column Chart with 2 Y-Axes) that is based on a (Universe) Data Source that contains hundreds of records.

I would only like to display only the top 10 results in the chart. Is this possible?

In my research of the Design Studio tool I found that in the 'Plot Area' section of the 'Additional Properties' menu of the 'Info Chart' component - is a 'Fixed Data Point Size' option, which, if checked, presents the records in the chart in a reasonably-spaced fashion, and introduces a scroll-bar to view all records in the chart:

While this option makes the display of large data-sets manageable, it would be nice if there was a mechanism, other than modifying the data-source itself, to display only the top elements in the result-set.

This issue is compounded by the observation that there is no simple way to limit the result-set size of a Data-Source based on a universe - other than by setting a result-set limit on queries returned by a universe, as mentioned here: http://www.forumtopics.com/busobj/viewtopic.php?t=190532&sid=fef68bbc8c8972cfd01e64b86225e35d.

Thank you in advance.

[former_member4998]

Hi, Can you please try below options

1. In the data source initial view, select measure, active users and sort as descending.

2. change chart type to bar chart and set chart height display as top 10....and you also selected "Fixed Data Point Size" ..so its enabled scroll-bar to view all records in the chart. (users initially able to see only top 10 active users...if they want see more ..they can use scroll-bar).

[former_member234473]

Hello Sreenivasulu:

Thank you for your reply. For #2, when setting the chart height, do you mean to set the chart height in pixels, so that, should I want to display the first ten elements, I would set the pixel height to:
height = (10) x (bar-pixel-width + space-between-bars-in-pixels)
I don't see an option to display a defined number of elements in the chart explicitly.Thank you,
- Knoa Support

[former_member265529]

Hi Knoa,

Your requirement can be achieved in design studio to find rank based on two measure. You can add the another rank on same dimension with another measure and join them by using a and\or operator.

In comparing Xcelcius and design studio you can perform number of operation on data in xcelsius as it is excel based so you can perform row based or column based operations. But in design studio you cannot perform that kind of operations. You can only do some basic calculations on a key figure if your data source is from BW.

Thanks,

Poovarasan

[former_member234473]

Hi Poovarasan,

Thanks for the insight. I suppose introducing a rank is the way to do this.

Regards,

- Knoa Support

[former_member234473]

Hello Poovarasan:

Thanks so much for your prompt and informative reply.

While introducing a rank in the data-source query would produce the desired result-set, there are a few limitations with this approach:

• It makes for a more complex data-source query construction, as filters must be added twice, both inside-of and outside-of the RANK() statement
• Ranking is based on only a single measure: as far as I can tell, the query panel does not allow ranking based upon multiple measures. So getting the top 10 based on a primary and secondary sort is not possible; albeit once the rank-based result-set is returned, it can be sorted by any dimension or measure.
• A potential performance impact, as the query must search through the database table(s) twice, once to perform the ranking, and a second time to return the final result-set; whereas a simple SQL statement such as the following:

select top 10 * from TABLE order by 1 desc, 2 desc 

would only pass through the data once.

To give some background, we are migrating our set of dashboards from Xcelsius/Dashboards to Design Studio, and granted that the two tools are not totally equivalent in their respective use-cases and implementations, obtaining the top results of a query is a trivial effort in Xcelsius.

Much appreciated and regards,

- Knoa Support

[former_member265529]

Hi Knoa,

Since you are using universe as data source you can create a top 10 condition in the query specification panel in design studio.

In the query specification panel, use the highlighted icon to add ranking and add the dimension and measure as shown in their fields as shown and then you will get your top 10 list.

Thanks,

Poovarasan