Comment 4 for bug 497760

Revision history for this message
moores (moores) wrote :

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)"}
         ]
    },