Drillthrough does not work with NullMember

Topics: Developer Forum, User Forum
Mar 6, 2015 at 9:28 AM
I implemented null default measure as written in http://blogs.msdn.com/b/sqlcat/archive/2007/09/25/create-a-default-measure-in-as2005-cubes.aspx

But now I cannot use custom drill using CurrentCellAttributes() function. I always get "You cannot drillthrough if the cell in a select clause is a calculated cell." error.

How can I fix that?
Coordinator
Mar 6, 2015 at 3:01 PM
What cell are you launching the drillthrough from? A physical measure? Or the null default measure?
Mar 6, 2015 at 3:06 PM

I drillthrough a physical measure.

Coordinator
Mar 12, 2015 at 2:39 AM
What's your action expression? The following action expression on a Rowset action worked fine for me:

"drillthrough select from [Adventure Works] where (" + ASSP.CurrentCellAttributes([Measures].CurrentMember) + ")"
Mar 12, 2015 at 6:51 AM
Here is the action expression:
'call ASSP.GetDrillThrowDataBulk(
"DRILLTHROUGH MAXROWS 1000000 SELECT (' 
+ ASSP.CurrentCellAttributes()
+ ') ON 0 FROM [F101]
RETURN  
[$DATE].[ID DATE] AS [ID DATE],
[$AGREEMENT].[ID AGREEMENT] AS [ID AGREEMENT],
[$AGREEMENT].[DOC NUMBER] AS [AGREEMENT DOC NUMBER]
[$MEASURES].[BS] AS [BS]
")'
Coordinator
Mar 12, 2015 at 5:08 PM
Edited Mar 12, 2015 at 5:08 PM
The following action worked fine for me:
'DRILLTHROUGH MAXROWS 1000000 SELECT (' 
+ ASSP.CurrentCellAttributes() 
+ ') on 0 from [Adventure Works DW]'
I can't speak for the GetDrillThrowDataBulk sproc since that must have been your own customization of the ASSP library.

What source code did you start with? I was testing on SQL 2012 with the ASSP 1.3.7 release.
Mar 17, 2015 at 12:08 PM
I found the error. It is on my side.
Full compare of sources 1.3.6 (I use this release) and 1.3.7 show me deleted lines in CurrentCellAttributes() function.

Thank you for your help.
Marked as answer by furmangg on 3/17/2015 at 8:21 PM