Calc. members in alternative hierarchies.. 
Author Message
 Calc. members in alternative hierarchies..

Hi Mosha,

Thanks for your reply -  I tried your suggestion by changing
[Accounts].[Regular] to [Accounts.Regular] but it did not help. By the way -
[Accounts].[Regular] is the syntax the calculated member builder suggests
when I click on the desired member - is this a bug in the calculated member
builder ?

So the bug still remains. I tried the same formula on an AS2000 test-server
that we have, and it worked there.....So how can I get this formula working
in OLAP services ?

Another thing: Once I try to add a parent member through the calculated
member builder - I always get an error message... something like "Unable to
update the calculated member. Invalid formula member name " and then the
formula is printed - and you can see that it doesn't look correct. This
error also appears in AS2000.

It seems to me that these are bugs in the calculated member builder -
related to dimensions with several hierarchies ? I might be wrong though.
Are there any workarounds for this, using the calculated member builder.....

I would be grateful for any help.



> Did you try my suggestion from the last time to enter that formula

>  [Accounts.Regular].[All Accounts].[Sales] - [Accounts.Regular].[All
> Accounts].[Direct costs]

> I think it will do the trick

> --

Sat, 15 Nov 2003 15:05:24 GMT
 [ 1 post ] 

 Relevant Pages 

1. -Re: Calculated members in alternative hierarchies..again

2. Calculated members in alternative hierarchies..again

3. Calculated members in alternative hierarchies

4. Getting crazy with member properties in calc members - URGENT

5. Selecting parent member for calculated member in dimension with alternative hieararchies

6. Excel Pivot Table Slow w/ Calc Members

7. MDX Question - Virtual Cube Calc Members

8. Custom Member properties - Variance calc

9. Calc members wacked from cube after restoring cube save/restore of database

10. Calc Member - Median

11. Calc Member as "Changing" Denominator

12. Loading data against calc'd members

Powered by phpBB® Forum Software