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

If invoking the cell action via the cube browser, then there is a known bug
that coordinates are not evaluated properly. Try this in a real application
(or your own code) and see what happens. You may just be running into a
limitation of the cube browser.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Yash" <yashgt (AT) yahoo (DOT) com> wrote

I tried with Crystal Analysis as the cube browser, and it worked as expected.
Thanks a lot.

-Yash




"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote