DrillTrhough on calculated members

Topics: Developer Forum, Project Management Forum, User Forum
Oct 24, 2016 at 3:20 PM
Hi I've tried to use the ASSP.GetDefaultDrillthroughMDX but it does not return what desired.
I have a calculated members like this
"CREATE MEMBER CURRENTCUBE.[Measures].Contact_NO_EmailPhone
AS SUM(
{
[DQ Dashboard T].[Valid Phone].&[Incorrect],
[DQ Dashboard T].[Valid Phone].&[Missing],
[DQ Dashboard T].[Valid Phone].&[N]
}
*
{
[Measures].[Contacts]
}
)
+
SUM(
{
[DQ Dashboard T].[E Mail].&[Incorrect],
[DQ Dashboard T].[E Mail].&[Missing],
[DQ Dashboard T].[E Mail].&[N],
[DQ Dashboard T].[E Mail].&[RS]
}
*
{
[Measures].[Contacts]
}

)

SUM(
{
[DQ Dashboard T].[Valid Phone].&[Incorrect],
[DQ Dashboard T].[Valid Phone].&[Missing],
[DQ Dashboard T].[Valid Phone].&[N]
}
*
{
[DQ Dashboard T].[E Mail].&[Incorrect],
[DQ Dashboard T].[E Mail].&[Missing],
[DQ Dashboard T].[E Mail].&[N],
[DQ Dashboard T].[E Mail].&[RS]
}
*
{
[Measures].[Contacts]
}
Using the stored procedure in this way
"ASSP.GetDefaultDrillthroughMDX(([V DIM ALL Contacts].[All],[Measures].[Contacts]))"
it return the data not related to the calculated members, it works only if the calculated members is a simple calculation.
There some way to perform this kind of drillthrough ?

Thanks in advance for your help
Coordinator
Oct 24, 2016 at 8:18 PM
Drillthrough commands in SSAS 2014 or earlier only work on a single tuple, you can't do drillthrough on a set of members. SSAS 2016 has added support for drillthrough on multiple members, but you need both Excel 2016 and SSAS 2016 and we have not adapted any of the drillthrough routines in ASSP to work with this yet.

I don't know if this is possible with your solution, but one possible work around is to introduce some attributes into your [DQ Dashboard T] dimension that aggregate up these invalid states so that you can then create a single tuple to drillthrough on.