Can't order Calculated Members as desired -
08-17-2004
, 08:11 AM
I have created a number of calculated members within MS-AS. Because I
want them in a certain order in the front end (and don't want to
adjust the order every time I create a new view in the front end
(which is Panorama Novaview here at Philips CE), I wanted to put them
in a certain order in MS-AS This works beautifully for most members.
So, I created a calculated member A. After that I created a calculated
member B which uses calculated member A in its calculation. This works
fine.
But after that I want to change the order of the calculated members.
So I drag and drop B above A.
When I try this I get the following error message (sometimes directly,
sometimes not until I try to edit member B):
Unable to update the calculated member. Formula error - cannot find
dimension member ("[Measures].[A]") in a name-binding function.
When I edit B only the calculated members that are above B in the list
of calculated members are visible in the 'Measures' dimension within
the 'Data' box of the Calculated Member Builder.
Does anybody know if it is really true that the order of the members
in the tree matters for their calculation? I thougt there were things
like solve order and pass order that take care of these things, but
adjusting these doesn't help either. |