KPI for MDX doesn't work

[evshvarov]

Changing the filter causes problem:

Reproduced here:

[Lena-Ev]

@jakcpto посмотри пожалуйста, что тут не так с МДХ, пока Антону не понятно, какой он должен быть

[jakcpto]

Bottom widget has no MDX at all. I think this is a bug and the reason of error message.

Top widget have this MDX

SELECT NON EMPTY NONEMPTYCROSSJOIN([GenD].%TopMembers,{[Measures].[%Count],[Measures].[Allergy Count]}) ON 0,NON EMPTY {[AgeD].[H1].[Age Group].Members,[AgeD].[All Patients]} ON 1 FROM [PATIENTS]

When I'm choosing a filter in the top widget, filter applies to both widgets:

%FILTER %OR({[ColorD].[H1].[Favorite Color].&[Blue] })

In that case top widget have correct MDX (with filter added), but bottom has corrupted MDX (only filter without SELECT).

[gnibeda]

There is no MDX, because the bottom widget has KPI, and executes request /MDX2JSON/KPI?Namespace=irisapp with payload {"KPI":"DemoInteroperability.kpi"}. Filters for KPI is not implemented in DSW, I need a way to apply filters to KPI requests. Can you explain how it can be done in mdx2json?

[jakcpto]

@gnibeda now we have formed /KPI endpoint so DSW can send FILTERS in payload and the results will be filtered.

Example: { "KPI":"DemoInteroperability.kpi", "FILTERS":[ {"name":"[ColorD].[H1].[Favorite Color]", "value":"Green"}, {"name":"[DocD].[H1].[Doctor Group]", "value":"I"} ] }

There is array of objects. It can be array of only one object. "name" and "value" are keys. Name refers to a "path" parameter from filters response.

For multiple selection of one filter, add another object in array:

{ "KPI":"DemoInteroperability.kpi", "FILTERS":[ {"name":"[ColorD].[H1].[Favorite Color]", "value":"Green"}, {"name":"[ColorD].[H1].[Favorite Color]", "value":"Yellow"}, {"name":"[DocD].[H1].[Doctor Group]", "value":"I"} ] }

[jakcpto]

@Lena-Ev FYI. This is important issue, can solve critical project task.

[gnibeda]

Done in 3.1.63

[Lena-Ev]

@evshvarov check pleaase