I have a measure which must only be aggrigated for certain members in a dimension. There are around 13k members in the dimension and I only want the measure summed whos members start with 8. eg: 800, 8923843, 8, 821212 but not 7834
So far, I have got as far as filter and instr but it runs like a dog (Not returned anything yet so I don't even know if I am on the right path)
[Measures].[OS Comm Amt] on Columns,
[Purchase Order Detail].[Order Number].Children ON rows
(Select Filter([Purchase Order Detail].[Order Number], instr(1, settostr([Purchase Order Detail].[Order Number].children), '8')) on COLUMNS FROM [Policy And Programme Support]
MDX is like greek to me so take it easy
CrispinI can't die, there are too many people who still have to meet me!
It's not a bug, SQL just misunderstood me!