I am in the process of building a dashboard with more than 15/20 charts/crosstabs (one data source per chart/crosstab) spread across multiple tabs (tabstrip). In other words, I have 3-5 charts in each tab with around 4 tabs total. All the data sources must be filtered using only one Filter Panel. The dashboard performance is very bad when I make all the data sources as "Target Data Sources" in the filter panel.
Ideally I want to load the data sources (using the selections made in the filter panel) specific to a tab only when it is opened/clicked. This way I load only 3-5 data sources at any instant rather than only all the 15-20 data sources. I tried using <DataSource>.setFilter and loadDataSource() option but I couldn't succeed.
Another questions - Is there way load a data source with multiple filter dimensions. <DataSource>.setFilter function lets you filter only one dimension at a time.
Any help in this matter is appreciated.