1

Closed

CurrentMember.Name returns "All"

description

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

returns:

All/235678

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

comments

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 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 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.
https://bidshelper.codeplex.com/wikipage?title=Tabular%20Actions%20Editor&referringTitle=Documentation

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
All/235678

and

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

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

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