All,

I have a cube built with Parent/Child dimensions.
For some slices of the cube - that could be identified by dimensions
attributes - I do not want to obtain the aggregated value but the value
direclty attached to current members.
I would like to define a calculation script that do the job...
Any clue on how to do this?

Thanks
Lionel

Will the DataMember MDX function work for you - if not, could you
explain what you want with an example?

http://msdn2.microsoft.com/en-us/library/ms145608.aspx

DataMember (MDX)
Updated: 17 July 2006

Returns the system-generated data member that is associated with a
nonleaf member of a dimension.

Note:

Returns the specified member if the specified member is a leaf member,
or if the nonleaf member does not have an associated data member.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Lionel,
Thanks for using Microsoft Online Managed Newsgroup.

From your description, I understand that:
You wanted to know how to define a calculation to calculate the value by
the current members.
If I have misunderstood, please let me know.

I recommend that you define a calculated member to calculate the value.
This article provides a detailed steps on how to define a calculated member:
Defining Calculated Members
http://msdn2.microsoft.com/en-us/library/ms166568.aspx

You may also want this reference:
Lesson 6: Defining Calculations
http://msdn2.microsoft.com/en-us/library/ms169748.aspx

Hope this helpful!

Please feel free to let me know if you have any other questions or concerns.

Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hi Lionel,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!

Charles Wang
Microsoft Online Community Support