I tried using Utility Dimension. But that didn't help. Next I tried with Set for Year dimension. Then used Table Calculation(Difference) Using Set. I was able to acheive this. But at the same time was not able to get difference for Actual versus Budget.
For grouping sets, tried with MDX calculated field.
For example [Place].[City_1]+[Place].[City_2], where City_1 and City_2 were members under Place dimension.
Also I have 2 metrics, one for YTD and other for 4 weeks. Is it possible to get these 2 in a single view.
From your above link, MDX may solve my problems.
But befor starting with MDX, want to know if MDX is the only solution for all my queries?
1 of 1 people found this helpful
You can create sets (collections) of dimension members in Tableau against a cube in the same way you can against an RDMBS. Check out help on how to do this.
Yes, you can get two metrics on a single view. Just add them both to the Columns/Rows shelves.
Do you know if it is possible to create a GROUP in Tableau when connected to an Essbase cube? (example, I would like to combine the values in the dimension field called 'role' into 2 groups: 'professional' (includes values 'professional' and 'executive'), and one called 'production' (includes values of 'hourly' and 'contingent'). The group button appears grayed out to me.
Hi Nicholas -
Nope, no groups against a cube. Maybe a set could stand in for you? Either that, or perhaps your cube developer could add a hierarchy that expresses this for you?
Hello Nicholas - Groups is not supported while connected to Essbase. You can achieve same with MDX expressions.