I’m trying to build some exhibits using Tableau connection to a multidimensional cube.
I’m trying to group a number of dimensional records into one (create a hierarchy where I can introduce higher level of grouping – this level of hierarchy is not available on the cube level?).
I was trying to introduce a new hierarchy using excel connection but getting some problems with aggregation (“cannot blend the secondary data source because one or more fields use an unsupported aggregation”).
Second option: I was trying to introduce a new measure and parameter to introduce mapping on the parameter level using if/case statements but it doesn’t work.
Is this functionality available in Tableau? All help and feedback are much appreciated.