Hi
Excel 2010. Sql server 2008 R2 Analysis services
Am trying to progress with Cube formulas and have hit an issue...
I have found that the below formula works as is but if I change it to cubeset using the notation suggested for a range of time dimensions it stops working. The only difference is the insertion of the 'material classification' condition. I'm guessing its because the kind of grouped expression with the material and time but not sure of the solution?
=CUBEMEMBER("OLAPCUBE",{"[Material Classification_Resource].[Material Classification_Resource].[Material Classification_Resource].&[{BC261FAE-5CEE-46C8-89B9-9E2197CFDD7B}]","[Time].[Time].[Year].&[2015].&[3].&[7]"},"Cost") works ok
=CUBESET("OLAPCUBE",{"[Material Classification_Resource].[Material Classification_Resource].[Material Classification_Resource].&[{BC261FAE-5CEE-46C8-89B9-9E2197CFDD7B}]","[Time].[Time].[Year].&[2015].&[1].&[1]:[Time].[Time].[Year].&[2015].&[3].&[7]"},"Cost") doesn't work
Advice appreciated
Brian