I wonder if somebody can help me with the following question.
I would like to create an enhancement to SSAS in a way so that one can pass in multiple values, run a calculation and in return retrieves not one but multiple cell results at the same time e.g.
retSet = functionABC(inSET) where inSet is somthing like 5 4 3 6 7 3 4 4 AND retSet is 4 6 7 8 9 3 4 4
All my calculated members in MDX return a single value BUT I need to have a calculation that if called returns multiple results (a set) at once and in a way so that Excel will properly pick up on it and consequently fills multiple cells
in the Pivot table.
Is that possible at all and if so how?
I would not mind to write a little CLR assembly to enhance the SSAS but don't know how to pass the results back.
Any ideas are highly appreciated.
View Complete Post