Drilldown works unstable

[evshvarov]

Example

Please try to drilldown on the widget with years (top right)

[Lena-Ev]

check backend

[Frisle]

Drilldown doesn`t work when ResultSet trying to get Axis from this MDX

"SELECT {[Measures].[Patient Count],[Measures].[Doctor Count],[Measures].[Avg Monthly Rainfall Inches]} ON 0,NON EMPTY [BirthD].[H1].[Decade].&[1950s].children ON 1 FROM [COMPOUNDCUBE/COMPOUNDCUBE] %FILTER [BirthD].[H1].[Decade].&[1950s]"

QueryKey received by ResultSet doesn't have colKey, then ResultSet cannot get Axis related to the MDX and therefore data related to it.

If MDX sent like this

"SELECT {[Measures].[Patient Count],[Measures].[Doctor Count],[Measures].[Avg Monthly Rainfall Inches]} ON 0,NON EMPTY [BirthD].[H1].[Decade].&[1950s].children ON 1 FROM [COMPOUNDCUBE/COMPOUNDCUBE]"

Received QueryKey have link to Axis and data is acquired

I suggest changing the MDX sent by the frontend

[Frisle]

I guess this issue is directly related to this one #377 because current one is about compound cube too

[Lena-Ev]

try rest API to resolve