The CUBEMEMBER function used an array of values for retrieving data:
=CUBEMEMBER(“AW BI Cube”,{“[Date].[Calendar Weeks].[Calendar Year].&[2014]“,”[Account].[Accounts].&[47]“})
The bolded segment above is the array. We know it’s an array because of the braces {} surrounding the values. The array has 2 values:
[Date].[Calendar Weeks].[Calendar Year].&[2014]
[Account].[Accounts].&[47]
Because it’s an array we can’t simply replace &[2014] with &A1. Where A1 = [2015]. Excel won’t accept cell references within an array.


=CUBEVALUE(“PowerPivot Data”,”[Sum of SalesAmount]”,”[Country].[Australia]”,”[Category].[Bikes]”,”[FiscalYear].[2006]”)

=CUBEVALUE(“PowerPivot Data”,”[Sum of SalesAmount]”,”[Country].[Australia]”,”[Category].[Accessories]”,”[FiscalYear].[2005]”)

So the criteria in cell B4 are going to be:

“[Country].[Australia]”,”[Category].[Bikes]”,”[FiscalYear].[2006]”

But I am using the contents of cells to drive my selections … so the correct syntax is:

“[Country].[“&$B$5&”]”,”[Category].[“&$B7&”]”,”[“&$C$5&”].[“&C$6&”]”

=CUBEMEMBER(“ThisWorkbookDataModel”,”[Category].[CategoryName].[All]”,”Grand Total”)

=CUBEMEMBER(“ThisWorkbookDataModel”,”[Poll Owner].[Gender].&[F]”)


=CUBEVALUE(“ThisWorkbookDataModel”,$B$4,$B8,C$5,Slicer_Poll_Has_Submissions)


=CUBEVALUE(“ThisWorkbookDataModel”,”[Measures].[Count of PollID]”,[Poll Owner].[Gender].&[F],[Category].[CategoryName].&[Entertainment],[Poll].[Poll Has Submissions].[ALL])