1 Reply Latest reply on Oct 5, 2017 4:18 PM by Patrick A Van Der Hyde

    SETS on hierarchies is not working Tableau when connected to ESSBASE

    sreelekha sangana

      Hello There,

       

      I am having ESSBASE Cube as my data source in Tableau.

      I created a Trend View where I need to give multiple global filters like Company Code and Business Unit.

      Company Code is from one dimension and Business Unit is another Dimension. Till here my Trend Graph is working.

      Now my requirement is to add another filter which is Vertical one level below the Business Unit from the same dimension.

       

      This is my dimension Hierarchy. Please bear me on not sowing actual values in the image.

      Business Unit Filter = Set created on Gen5.

      When i created Vertical =Set on Gen6 and add vertical filter, my Trend graph is disappeared not working.

       

      Can anyone have idea on this?

       

      Thanks,

      Sreelekha