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)"}
]
},
This part of the file js/mdx_templates.js (line 120) should be replaced as such:
BEFORE
{ "comment": "Alternate view MDX by WB Income", .[Year] .Members/ *End*/} ) ON COLUMNS , { [World Bank Income Group].[World Bank Income Group].Members } ON ROWS FROM [%cube] /*COMMAND: EMPTY=[Region] */ " ,
"hierarchyRemo ve": [
{" value": "World Bank income group"},
{" value": "Indicator"}
{" value": "[World Bank Income Group].[World Bank Income Group]" ,"label" :"World Bank Income Group"},
{" value": "[Time Period] .[Year] ","label" :"Time period (years)"}
"id": "5",
"mdx": "SELECT NON EMPTY Crossjoin( { %param1 } , {/*Start*/[Time Period]
"cube": "Regional Yearly Core Sums",
],
"filter": [
]
},
AFTER
{ "comment": "Alternate view MDX by WB Income", .[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] */ " ,
"hierarchyRemo ve": [
{" value": "World Bank income group"},
{" value": "Indicator"}
{" value": "[World Bank Income Group].[World Bank Income Group]" ,"label" :"World Bank Income Group"},
{" value": "[Time Period] .[Year] ","label" :"Time period (years)"}
"id": "5",
"mdx": "SELECT NON EMPTY Crossjoin( { %param1 } , {/*Start*/[Time Period]
"cube": "Regional Yearly Core Sums",
],
"filter": [
]
},