Parser: The end of the input was reached Exception for GetDefaultDrillthroughMDX & GetCustomDrillthroughMDX



I tried to define simple DrillThrough actions with ASSP but Default & Custom DrillThorugh doesnt work and give below exceptions.

02-Default Drill Through throw Parser: The end of the input was reached exception.

03-Custom Drill Through throw Errors from the SQL query module: The 'Measures' table either does not exist in the exception.

04-But cube's default DrillThrough Action doesnt throw any problem and it works very well ( except the column names problem )

Can you please help me about this issue?

You can find whole drill through definitions and exceptions with the SQL Profiler Traces at attachment.

file attachments

Closed Oct 15, 2016 at 8:59 AM by dgosbell
Appears to be user error, no further response from the person who raised the issue


dgosbell wrote Oct 12, 2016 at 8:02 PM

02 - you are missing a closing bracket at the end of your drillthrough expression

03 - you can't references __[Measures].__[<Measure Name>] you need to reference that column using [<measure group name>].[<column name>]

wrote Oct 15, 2016 at 8:59 AM