WB income regions returns "Not applicable" & "Not included"

[Jessica]

When selecting "WB income groups" from the Alternate views, it returns "Not applicable" & "Not included". Please remove these two lines.

[moores (moores)]

This can be fixed in the MDX. I will address.

[Philippe Boucher (boucherp)]

some of these have data, should they really be removed?

eg:
mdg -> mdg4 child mortality -> under 5 mortality rate

[Jessica (hoj-who)]

I don't know where the data comes from and should be removed. Is it possible the database is calculating those figures?

[moores (moores)]

This part of the file js/mdx_templates.js (line 120) should be replaced as such:

BEFORE

 { "comment": "Alternate view MDX by WB Income",
     "id": "5",
     "mdx": "SELECT NON EMPTY Crossjoin( { %param1 } , {/*Start*/[Time Period].[Year].Members/*End*/} ) ON COLUMNS , { [World Bank Income Group].[World Bank Income Group].Members } ON ROWS FROM [%cube] /*COMMAND: EMPTY=[Region] */ " ,
        "cube": "Regional Yearly Core Sums",
        "hierarchyRemove": [
            {"value": "World Bank income group"},
            {"value": "Indicator"}
         ],
         "filter": [
            {"value":"[World Bank Income Group].[World Bank Income Group]","label":"World Bank Income Group"},
            {"value":"[Time Period].[Year]","label":"Time period (years)"}
         ]
    },

AFTER

 { "comment": "Alternate view MDX by WB Income",
     "id": "5",
     "mdx": "SELECT NON EMPTY Crossjoin( { %param1 } , {/*Start*/[Time Period].[Year].Members/*End*/} ) ON COLUMNS , { [World Bank Income Group].[All World Bank Income Groups].[Low income],[World Bank Income Group].[All World Bank Income Groups].[Lower middle income],[World Bank Income Group].[All World Bank Income Groups].[Upper middle income],[World Bank Income Group].[All World Bank Income Groups].[High income],[World Bank Income Group].[All World Bank Income Groups].[Global] } ON ROWS FROM [%cube] /*COMMAND: EMPTY=[Region] */ " ,
        "cube": "Regional Yearly Core Sums",
        "hierarchyRemove": [
            {"value": "World Bank income group"},
            {"value": "Indicator"}
         ],
         "filter": [
            {"value":"[World Bank Income Group].[World Bank Income Group]","label":"World Bank Income Group"},
            {"value":"[Time Period].[Year]","label":"Time period (years)"}
         ]
    },

[Philippe Boucher (boucherp)]

can you email me a new version of the file based on what is currently installed on gva1sucreon? I'm in a meeting for the next 20 minutes, but then I can roll it back into the deployed version on gva1sucreon

[Philippe Boucher (boucherp)]

oh yeah, Jessica gets a chocolate

[Philippe Boucher (boucherp)]

I've tried the new version of the file, but I still get not-included and not-applicable - I'm looking at this table:

mdg -> mdg4 child mortality -> under 5 mortality rate

[moores (moores)]

OK, I will fix. Basically, wherever you see "[World Bank Income Group].[World Bank Income Group].Members", this needs to be replaced with...

[World Bank Income Group].[All World Bank Income Groups].[Low income],[World Bank Income Group].[All World Bank Income Groups].[Lower middle income],[World Bank Income Group].[All World Bank Income Groups].[Upper middle income],[World Bank Income Group].[All World Bank Income Groups].[High income],[World Bank Income Group].[All World Bank Income Groups].[Global]

...as is the case with the parameter in under-5 mortality in menu.js. I will review and replace. FYI

[Philippe Boucher (boucherp)]

Instead of making explicit changes to the MDX queries, Steve has re-enabled a condition in the cube, GlobalHealthObservatory.xml, so that the not-applicable and not-included entries are not used. Code is checked in and now running on gva1sucreon. Setting this to fix-committed.