Need performance tuning for data sources for analysis application (Design studio) scenario?

265 Views

Hi Everyone,

I have simplest scenario which is having more data sources.

Requirement : To display Country, State, Region, City wise data in 4 different charts.

Explanation: We're having 6 modules data. Given drop down for Module selection and on select event I have written Setfilter and Setvisible functions and displayed. country, state, region and city data in charts whereas I have used one data source for each chat I used.

Example: Sales module: Country wise sales (Datasource1), State wise sales (Datasource2), Region wise sales (Datasource3),,City wise sales (Datasource4) displayed these datasources with different chart. For each module I have 4 data sources (Total 24 data sources).

I need to limit number of data sources in the design studio application.

I have reduced number charts in the usage but unable to tune datasources.

Thanks in advance,

regards,

Ravi Bodala