Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Switching data source / subject area in same Analysis / Pivot / Chart

Hi Gurus,
Here is my business case.
Is there an easy way to dissociate an analysis / dashboard / chart from the data source / subject area?
I have an existing dashboard, with prompts and pivot table, running against an Essbase datasource. So far, so good.
Now, I need to change dynamically the content of my pivot table, so that new data coming from a different data source (a RDBMS such as SQL Server for instance) be displayed in the same pivot table.
If not clear enough, let's assume that I have weekly sales data by region and by product lines.
Actual data is stored in a RDBMS star-schema-like model, and Budget figures are stored in a OLAP engine (Essbase).
I am not trying to display both figures at the same time, so I don't think that Union would do the trick.
I just want some kind of toggle/switch between data sources, switch being driven by a prompt value / variable.
Does that make sense?
Thanks !
Laurent
Best Answer
-
Hi,
a union would do it, just give each an additional field - 'Datasource' with value of 'Oracle', 'Essbase', 'etc...'
Then put your additional field in a page heading in a pivot table, or filtered by a dashboard prompt, or whatever...
Simples!
Answers
-
Hi,
a union would do it, just give each an additional field - 'Datasource' with value of 'Oracle', 'Essbase', 'etc...'
Then put your additional field in a page heading in a pivot table, or filtered by a dashboard prompt, or whatever...
Simples!
-
Ok, I see the point. But how do I dynamically change the columns in my filters? With a function such as INDEXCOL ?
-
Sorry I am not following why you need to change the columns in your filters?
If it is based on a union query then each query within the union can have different filters, why is this part of the requirement dynamic, can you explain please?
-
Absolutely! What was I thinking!