I would like to include cell references into the CubeMember function. When I use the Convert to formulas function in a pivot table linked via Analysis Services I get a CubeMember function like: CUBEMEMBER(globl0720 KPI DW KPI;{[KPI].[KPI].[KPI].&[64]\[Location].[Blade Type].&[ES-PON]&[1]})