4 Replies Latest reply on Jun 16, 2014 8:01 AM by 2632684

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

    2632684

      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