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 1:59 PM by furmangg


dgosbell wrote Sep 25, 2013 at 8: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 http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads

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 8: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 9: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 10: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 1:59 PM