In Analysis Manager, I am trying to create a data cell action in the
cube, that prints the name of the member of Gender dimension, in a
certain cube. So when the cube data is displayed, rightclicking on a
cell will show me the corresponding member of the Gender dimension for
that cell. The action is defined as:
"cmd /k echo """ + [Handset].CurrentMember.UniqueName + """"

When browsing through the cube, if the X-axis has measures and Y-axis
has Stores as dimensions, and I click on a cell to invoke the action,
it prints [Gender].[All Gender], which is right as the default member
for the Gender dimension in [All Gender].
Next, if I slice the cube with Gender=M, the data sheet shows the cube
data correctly sliced. But if I now invoke the action to print the
name of Gender member, it again prints [Gender].[All Gender]. I don't
expect this because the cell I am clicking on is part of the slice,
and hence the action should show [Gender].[M].

However, if I put Gender as a dimension on an axis, and invoke the
action, without setting a slice, the action correctly shows
[Gender].[M] or [Gender].[F] depending on the cell I click on.

Is there any way to obtain the exact member name on any dimension from
a given cell, irrespective of whether the dimension is put on an axis
or not?

Thanks
Yash