MDX Query to Populate Hierarchy Levels in Different Columns ON ROWS
Summary
MDX Query to Populate Hierarchy Levels in Different Columns ON ROWSContent
I would like to know if there is a way to retrieve cube hierarchy's levels side by side ON ROWS using MDX query
i.e. I want the below query's resultset to be
||Level1|| Level 2||YEAR ||
|| Hello || World || 2018
However, the resultset given is the following
||Level ||YEAR ||
|| Hello || 2018 ||
|| World || 2018 ||
Here is the MDX query
SELECT
{
([HierarchyName].Levels(1).Members)
,([HierarchyName].Levels(2).Members)
} ON ROWS
,
{
([Year])
} ON COLUMNS
FROM CUBE_NAME
1