2 Replies Latest reply on Nov 28, 2012 4:04 AM by Jason Caulk

    Is there a way to enable a scatter plot to drill down to the next lower level in a dimension, when connecting to an Essbase Cube.

    Jason Caulk

      Specifically, I've got a scatter plot where the X axis is unit volume, and the Y axis is gross sales.

       

      The shapes on the chart represent a given level of our product hierarchy.  Ideally, I'd like to set the report up at a high level, and as the user clicks on an shape, that will then filter out all other products except for the ones that comprised the next lower level of the item that was clicked on.

       

      For example:

      Viz1 shows 2 products

           - Drinks

           - Snacks

       

      Clicking on Drinks creates viz 2.

           - Cola   

           - Coffee

           - Tea

       

       

       

      Thanks

      Jason