search

intersystems-community / DeepSeeWeb

Renderer for DeepSee Dashboards in Browser with MDX2JSON as a Serverside and JS web-client
MIT License
18 stars 13 forks source link

Drilldown works unstable #375

Closed evshvarov closed 1 year ago

evshvarov commented 1 year ago

Example

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

Lena-Ev commented 1 year ago

check backend

Frisle commented 1 year ago

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 commented 1 year ago

I guess this issue is directly related to this one https://github.com/intersystems-community/DeepSeeWeb/issues/377 because current one is about compound cube too

Lena-Ev commented 1 year ago

try rest API to resolve