KPI: some filters do not show the values

[evshvarov]

Example - here Zip Code filter doesn't show its members

[evshvarov]

Second example

[gnibeda]

Mdx2json returns an invalid result for the filter requests: Second example Request: /MDX2JSON/Filters?Namespace=IRISAPP Payload:

{"DataSource":"Holefoods/SalesAgainstTargets.kpi","Values":1,"Search":"","RequestedFilters":["ShowBy"]}

Invalid JSON result:

{
"children":[
	{null

[evshvarov]

@eduard93, just in case you have time, can you please have a look?

[evshvarov]

Here is the class that is responsible for the KPI where filters don't work: https://github.com/evshvarov/Samples-BI/blob/master/src/BI/Model/KPIs/DemoInteroperability.cls#L0-L1

[Lena-Ev]

More info about KPI needed: 1 - Are there any standards to write KPI code? 2 - When users need to use KPI instead of pivot? Are there filters needed in the KPI data at all? 3 - What are the real scenarios to use KPI? To make workaround to add filters to this data

@evshvarov Could you help please or connect to the users who use KPI and face with filtering problem right now

[Lena-Ev]

check call back from the case abovw with evgeny

[jakcpto]

We need to make a custom solution to workaround response from https://github.com/evshvarov/Samples-BI/blob/a66a939af79f287aa0f7fc68fedb092651e90a80/src/BI/Model/KPIs/DemoInteroperability.cls#L48

[Frisle]

My recent hack fixed the appearance of filters. Filled in json in Holefoods/SalesAgainstTargets.kpi and drop down menu in DemoInteroperability.kpi

The hack https://github.com/teccod/MDX2JSON/pull/5

[jakcpto]

@gnibeda take a look why filters don't send requests for filter members? For example https://pie-chart-bug.demo.community.intersystems.com/dsw/index.html#/IRISAPP/KPIs%20&%20Plugins/MDX%20Based%20KPI.dashboard and https://pie-chart-bug.demo.community.intersystems.com/dsw/index.html#/IRISAPP/KPIs%20&%20Plugins/SQL%20Based%20KPI.dashboard

(MDX Based KPI and SQL Based KPI)

They are only loading icons while opening filter popup, nothing else.

[gnibeda]

Done in 3.1.63

[evshvarov]

fixed!