SSAS 2012 Drillthrough Doesn't Return all Values

Question

SSAS 2012 Drillthrough Doesn't Return all Values

jhanson 2516

Old Hand

Points: 349
More actions
October 9, 2014 at 2:31 pm

#151383

I have an issue where sometimes a DrillThrough does not return a record for all values. I found this while testing the drillthrough in Excel and do not believe it has anything to do with the Max Rows returned property. (Note that the Member Derived ID value as been changed for confidentiality purposes).
I have found a specific example where the drillthrough does not work for a specific attribute value (but does for others).
For example this MDX drillthrough returns 0 rows:
DRILLTHROUGH
Select
(
[Member].[Member Derived ID].&[2534265]
,[Measures].[Member Months]
,[Member Covered Month].[Year - Month - Date].[Month].&[2014]&[2014-10]
) on 0
From [PS Enterprise]
RETURN [$Member].[Member Derived ID]
I've valided data exists both in in Excel and directly querying in SSMS:
select
[Measures].[Member Months] on 0
,(
[Member].[Member Derived ID].&[2534265]
,[Member Covered Month].[Year - Month - Date].[Month].&[2014]&[2014-10]
) on 1
from [Membership]
This results in the following recordset:
Member Months
25342652014-103
Now I can run the same MDX statements using a different Member Derived ID value and the drillthrough works as expected. I have also ran the same scripts in our Dev and QA environments and the Drillthrough works on both those. This leads me to believe is has something to do with how the Cube is processed (Dev and QA have been processed Full while the Production Cube is Processed Full at deployment then only processes specific partitions and all Dimensions). Note that the Membership Partitions are all processed Full everynight and the Member dimension uses a Process Update. Could that be where the issue lies... in the Process Update?
Any info or leads would be extremely helpful.
Thanks,
James.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

jhanson 2516 Old Hand Points: 349 More actions · Answer 1

Please note. I tried a process full on the cube and that did not change the results (or lack thereof) of the drillthrough. Any thoughts or things to look for would be helpful.

Thanks.