TM1 Forum

Posted: **Thu Apr 04, 2019 3:00 pm**

Hello All,

We have been doing some work on Cube Drills in PAX and have noticed the following bug :

If you have a cube drill and only have a row defined in the cube view it will return the right view but will be blank.

To get a drill through to work in PAX you need to have at least 1 dimension defined in the row and 1 dimension defined in the columns and then it will return values.

Regards

Herman

Posted: **Thu Apr 04, 2019 4:26 pm**

Here is another thread on this same topic from a few weeks ago:

https://www.tm1forum.com/viewtopic.php?f=3&t=14287

Posted: **Thu Apr 04, 2019 6:06 pm**

Herman Moller wrote: ↑Thu Apr 04, 2019 3:00 pm Hello All,

We have been doing some work on Cube Drills in PAX and have noticed the following bug :

If you have a cube drill and only have a row defined in the cube view it will return the right view but will be blank.

To get a drill through to work in PAX you need to have at least 1 dimension defined in the row and 1 dimension defined in the columns and then it will return values.

Regards

Herman

This could well be because the primary axis in MDX (and the Rest API?) is columns. Unless there’s a dimension defined on columns then it’s not a valid view in the MDX.

TM1 Forum

Cube Drill - PAX - bug (And workaround)

Cube Drill - PAX - bug (And workaround)

Re: Cube Drill - PAX - bug (And workaround)

Re: Cube Drill - PAX - bug (And workaround)