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

DrillThrough on Calculated measure

Topics: Developer Forum, User Forum
Oct 6, 2016 at 1:37 PM
Hi,
I have a simple calculated measure like this
CREATE MEMBER CURRENTCUBE.Measures].Contacts
AS ([DQ Dashboard T].[FLMTCH].&[N],[Measures].[RSID]) I would like to know how to enable drill through functionality that return some specific columns. I've tried to use the sample below

"ASSP.GetDefaultDrillthroughMDX(
StrToTuple(
ASSP.DiscoverSingleValue(
 "EXPRESSION"
 , "MDSCHEMA_MEASURES"
 , "<MEASURE_NAME>" + [Measures].CurrentMember.Name + "</MEASURE_NAME>"
   + "<CUBE_NAME>" + [Measures].CurrentMember.Properties("CUBE_NAME")
   + "</CUBE_NAME>"
)
,CONSTRAINED
)
)"
But it returns only the first column that belong to my dimensions structure.
there is some specific function that a can use for my purpose ?
Thanks in advance
Danilo
Oct 7, 2016 at 2:01 AM
Is the RSID measure a physical measure? Which dimensions are tied to that measure group? Have you defined a default drillthrough action for that measure group to define which columns you want?
Oct 7, 2016 at 9:39 AM
Hi,
yes RSID is a physical measure and all dimensions are tied to that, I've tried to define the default drillthrough action with column I need to retrieve and now is working :-)

Thanks very much for your suggestion.

Bye
Danilo