Hello,
it is a weared
comportment of as .
I add a calculated
member ot the fourth
existing calculated
members and I cannot
use it in another
calculated member,
ie
when I display all
members of the
dimension measure,
I seel all except
it.

Thanks for your
help.

Hi,

Thanks for your posting!

It seems strange so that I am afraid we might have a long time to narrow
down this issue. Is it possible for you to generate a sample calculated
member based on OLAP sample FoodMart? I would love to reproduce it on my
side.

Secondly, you could try creating a new calculated member to see whether it
works

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Hello,

I solved my problem. I will take a few minutes to explain what it
happened.

Lets suppose a cube with three members. (totaly invented for the explanation but
it is important to notice the syntax of m3)
m1, m2 and m3.
m1 = (Time.currentmember, measures.sales)
m2 = (Time.currentmember.prevmember, measures.sales)
m3= m1-m2

Everythin is right.

I process the cube, and close Analysis Services.
Later, I open Analysis Services and add another calculated member,
m4 = (Time.currentmember.lag(2), measures.sales)
The syntax of m4 is right and I process the cube wihtout errors.
Now I want use m4 in m3 like this :
m3 = m1 - m4
Here the error occur. It says m4 does not exist.
Nothing to do. If I want to use a calculated member called m3
which has this following syntax : m1 - m4 I must delete the older
calculated member called m3 and recreate another one.
And it woks.

Thanks

FYI: in such situations, you can change the order of calculated members
by "drag-and-drop" in Cube Editor. So, before changing m3, you drag and
drop m4 before m3.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!