Hi,

I am having interesting problem and I am sure this is just the way SSAS 2005
works by design. But I was wandering if anyone can suggest solution for
this.

I can easily assign value to the members that are generated by descendants
function:
DESCENDANTS([Report Date].[Report Date].[Report Qtr].&[20053]) = 100;

Yet similar ASCENDANTS function does not work
ASCENDANTS([Report Date].[Report Date].[Report Qtr].&[20053]) = 10;

I am getting following message:

Error 1 An arbitrary shape of the sets is not allowed in the current
context. 0 0

Anyone know how can I assign specific value to ascendants of one member?

Right now I have separate statement for each ascendant level (Yr, All for
this case), but I would like to make just one statement to do that.

Thank you very much,

Vimmas

Hello Vimmas,

Based on my scope, I was not able to find a workaround on this issue. It
seems that you have to set this via seperate statement though.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------