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

GetCustomDrillthroughMDX, Error - Truncated MDX query

Topics: Developer Forum, User Forum
Oct 7, 2016 at 3:09 PM
I got the 1.3.9 version, but it applies to earlier version aswell.

Have an Action on a measure in the cube:

ASSP.GetCustomDrillthroughMDX(
"NAME([$FT INVOICE].[INVOICE NO DD]) as [Invoice No]
, [FT INVOICE].[OVERDUE AMOUNT EUR MT] as [Overdue Amount]
",true)

The error in Excel is "The following syntax error occured during parsing: Invalid token, ...."
When looking in the Profiler I can see that the mdx is just cut.
I believe this is due to the lenght of the mdx.
But why do the mdx start with getting everything?
I thought the "true" parameter should have solved this.
Please any ideas?
Oct 10, 2016 at 3:49 AM
Did you see a change in the emitted MDX when you added the true parameter? I can't recall if we added the skipDefaultMembers parameter to all the different function overloads in v1.3.9 . Maybe try the 1.4.0 release and see if that works as we went through and added the skipDefaultMembers option to all the overloads (and we actually made it the default behaviour in 1.4.0 so you can even leave it off all together)