Hi,



I have a calculated member which calculates the percentage of the total
of the column using this formula



[Measures].[Number of Cases]/(Sum(strtoset("Axis
(1)"),[Measures].[Number of Cases]))



This works pretty good, apart from the fact, that an error occurs as
soon as I want to sort by any column.

Error message as follows



CellSet.Open Error: Infinite recursion detected during execution of
calculated member Percentage by column.



This is the order-statement:

MDX: SELECT NON EMPTY {Descendants([Call].[All
Call],1,leaves),([Call].[All Call])} ON COLUMNS, Non Empty
{ORDER(Descendants([Time].[All Time],1,leaves),([Call].[All
Call]),BDesc),[Time].[All Time]} ON ROWS FROM [CTL_Cube] WHERE
(Measures.[Percentage by column])



Any ideas?



Thanks in advance


--
Posted via http://dbforums.com

The order function needs to use the calculated member. At
this point Axis(1) is not defined yet. The calc member
expression triggers the rows expression to define Axis(1)
which in turn calls the calc member expression again and
so on...

You don´t know the order but you do know which members you
want to display on rows, so you could replace the strtoset
("axis(1)") expression with :

{Descendants([Time].[All Time],1,leaves),[Time].[All Time]}

and your query should work.

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

Thanks for the hint.

That's what I've assumed.



The problem is, that I don't know the members I want to display on rows
(the code was just an example), because the calculated member is a
measure valid for all dimensions. If I hardcode the member, I would have
to build up a calculated member for each dimension. Please correct me if
I'm wrong.



Isn't there a possibility to create axis(1) first and then sort
that dataset?



Regards


--
Posted via http://dbforums.com