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?
Hello sreelekha, Did the prohttp://onlinehelp.tableau.com/current/pro/desktop/en-us/help.html#cubes.html provide a good example ? There are examples of sets with hierrchies in this online help. I do not have a ESSBASE example locally but I believe the help provides a good start.