Can we define dynamic calculation members?

Hi, all here,

I am also wondering is there any way for us to define dynamic calculation members across different levels? (e.g. whatever dimension levels you are browsing you will be able to see the calculated members bound to the particular dimension level you are browsing).

Hope it is clear for your kind advices and help.

I am looking forward to hearing from you shortly for your help.

With best regards,

Yours sincerely,

If you are using MDX (in a query) to calculate your members, I believe if you reference .CurrentMember in any of the attributes/dimensions the calculated member will live in the scope of the Where clause of the query.

If defining it as a calculated measure in the cube, I think it automatically adjusts to the scope of the query.

You can also read up on the SCOPE statement here : http://technet.microsoft.com/en-us/library/ms145989.aspx

Good luck,

John