dbTalk Databases Forums  

Can't order Calculated Members as desired

comp.databases.olap comp.databases.olap


Discuss Can't order Calculated Members as desired in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Susanne Verbeek
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.