Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Switching data source / subject area in same Analysis / Pivot / Chart

2632684Jun 13 2014 — edited Jun 16 2014

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

This post has been answered by user11440683 on Jun 13 2014
Jump to Answer

Comments

User_L2G4Q

Reinstalled with previous release 18.1.2.1.0 and worked fine.

1 - 1
Locked Post
New comments cannot be posted to this locked post.