This project has moved and is read-only. For the latest updates, please go here.


CurrentMember.Name returns "All"


With Action Type URL, CurrentMember.Name returns "All" when the Target entry differs from the entry in the MDX Caption or Expression. So with a target of [tblGLTranPP].[ExtRefNbr] the following expression:

[tblGLTranPP].[docid].CurrentMember.Name + "/" + [tblGLTranPP].[ExtRefNbr].CurrentMember.Name



How does [tblGLTranPP].[docid].CurrentMember.Name need to be changed to retrieve the [tblGLTranPP].[docid] value?

Needless to say I am new to MDX.
Closed Sep 26, 2013 at 2:59 PM by furmangg


dgosbell wrote Sep 25, 2013 at 9:38 PM

So is this issue related to a BIDS Helper feature in any way? It sounds like you are just having issues configuring actions. For generic SSAS questions you should go to

But if you want to bring in the context from multiple attributes you should not be targeting a single attribute/level you will probably have to change your target type to Cells.

furmangg wrote Sep 25, 2013 at 9:46 PM

Do you have a Tabular model and are you using Tabular Actions Editor?

If so, see the examples which use the function called "Existing" on the documentation page.

If you're using a Tabular model, that may solve the problem.

JAynsley wrote Sep 25, 2013 at 10:41 PM

Yes I have a Tabular Model and I am using the very useful Tabular Actions Editor also I am using your referenced excellent documentation. I tried:
{Existing [tblGLTranPP].[docid].Members}.Item(0).Name + "/" + [tblGLTranPP].[ExtRefNbr].CurrentMember.Name
which still gives in the Excel Pivot Table Additional Actions


{Existing [tblGLTranPP].[docid].[docid].Members}.Item(0).Name + "/" + [tblGLTranPP].[ExtRefNbr].CurrentMember.Name
which gives

{Existing [tblGLTranPP].[docid].Members}.Item(1).Name + "/" + [tblGLTranPP].[ExtRefNbr].CurrentMember.Name
which gives

JAynsley wrote Sep 25, 2013 at 11:45 PM

I combined your two suggestions to find the solution:
Target Type Cells with:
{Existing [tblGLTranPP].[docid].Members}.Item(0).Name + "/" + [tblGLTranPP].[ExtRefNbr].CurrentMember.Name

Thank you very much

wrote Sep 26, 2013 at 2:59 PM