Cube Formulas

[SimonNU]

I have a 3 column Excel table that returns a measure (CUBEVALUE) based two key dimension columns (CUBEMEMBER). Is it possible to add a forth column that returns the name of one of the dimensions? think along the lines of vlookup...

Obviously this would return "Multiple" if the intersection isn't a single record.

So essentially what I'm asking is to filter the below formula by a CUBEMEMBER, is this possible?

=CUBERANKEDMEMBER("ThisWorkbookDataModel", CUBESET("ThisWorkbookDataModel", "[Table].[Client Name].children","Client Name", 2, Measure_Sum_Of_Amount),1)

Hopefully this makes sense!

 

[ImkeF]

Sounds as if you're looking for the CUBEMEMBERPROPERTY-function ?

If you're using Power Pivot, you need to use this workaround: https://wessexbi.wordpress.com/2014/02/16/a-cubememberproperty-equivalent-with-powerpivot/

 

[SimonNU]

Thanks! Got it working with SSAS Tabular.