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

GetCustomDrillthroughMDX Year to day

Topics: Developer Forum
Jan 11 at 2:56 PM
Hi guys, I have a doubt about GetCustomDrillthroughMDX

This code works perfect.
ASSP.GetCustomDrillthroughMDX(
    "NAME([$Budget].[BUD ID]) AS [BUD_ID]
    ,NAME([$Budget].[Budget]) AS [BUDGET]
    ,[FACT BUDGET].[ABC COST] as [ABC COST]"
   ,(ANCESTOR([TIME].[CALENDAR],[TIME].[CALENDAR].[MONTH]))
   ,2000000
)
But i want Year to Day
ASSP.GetCustomDrillthroughMDX(
    "NAME([$Budget].[BUD ID]) AS [BUD_ID]
    ,NAME([$Budget].[Budget]) AS [BUDGET]
    ,[FACT BUDGET].[ABC COST] as [ABC COST]"
   ,(ANCESTOR([TIME].[CALENDAR].CURRENTMEMBER,[TIME].[CALENDAR].[YEAR]).FIRSTCHILD.FIRSTCHILD:ANCESTOR([TIME].[CALENDAR].CURRENTMEMBER,[TIME].[CALENDAR].[MONTH]).LASTCHILD)
   ,2000000
)
but it does not work.

¿It is possible to do that or it is impossible?
Jan 11 at 9:34 PM
The first example passes in a Tuple as the second parameter. The second example passes in a set, it looks like. The GetCustomDrillthroughMDX function expects a Tuple.

Beyond the parameter mismatch, the DRILLTHROUGH command until SSAS 2016 would only support single-select (a tuple) not multi-select (a set). What version of SSAS are you running? If SQL2016, I suppose it's possible to enhance that function to support a set parameter, but that hasn't been done yet. If you would like that, feel free to request it on the ISSUES tab.