Avoiding multiple queries for similar data
I am creating a dashboard in Dashboards 4.1 using BIWS. I am publishing the following cross tab as a query from my Web Intelligence Report.
The dimensions used in the cross tab are - Employee Type (variable), Dept. Name (variable) & Month (Merged dimension).
The measure used in the cross tab is - Commission Amount.
Now, in my dashboard, the first view is going to be a stacked column chart with Month on the X-Axis. The stacked chart is going to have Commission Amount by Dept Name.
In the second view, the X and Y Axis are going to be the same. But, the user gets to select the "Employee Type" from a radio button.
Based on the selection, the corresponding data needs to be shown in the stacked column chart.
Now, to achieve this, I am having to publish 2 queries (cross tabs).To get the first view, I am only using Dept. Name, Month & Commission Amount as my report columns. To get the second view, I am publishing the whole table shown above.
My question - Is there a way to create one query/table to get both views ? Your help is appreciated.