Page Comparison

  The difference between them are how the column names are created from the MDX statement and how the data is organized.{color}

{color:#000000}{*}Based on the following MDX query using SteelWheels:*{color}

{code}
select NON EMPTY Crossjoin({

[Measures

].

[Quantity

]}, Union({

[Markets

].

[All Markets

]}, 

[Markets

].

[All Markets

].Children)) ON COLUMNS,

  NON EMPTY Hierarchize(Union({

[Product

].

[All Products

]}, 

[Product

].

[All Products

].Children)) ON ROWS

from [SteelWheelsSales]

{code}
{color:#000000}For the {color}{color:#000000}{*}Pentaho Analysis{*}{color}{color:#000000} datasource aka {color}{color:#000000}{*}Banded MDX{*}{color}{color:#000000}.  The columns return like this:{color}{color:#000000}* *{color}
{color:#000000}*\[Product\].\[All\], *{color}
{color:#000000}*\[Product\].\[Line\], *{color}
{color:#000000}*\[Measure\].\[Quantity\]/\[Markets\].\[All Markets\],*{color}
{color:#000000}*\[Measure\].\[Quantity\]/\[Markets\].\[All Markets\].\[APAC\], *{color}
{color:#000000}*\[Measure\].\[Quantity\]/\[Markets\].\[All Markets\].\[EMEA\], *{color}
{color:#000000}*\[Measure\].\[Quantity\]/\[Markets\].\[All Markets\].\[Japan\], *{color}
{color:#000000}*\[Measure\].\[Quantity\]/\[Markets\].\[All Markets\].\[NA\].*{color}
{color:#000000}For the {color}{color:#000000}{*}Pentaho Analysis  (De-Normalize) *{color}{color:#000000}datasource aka {color}{color:#000000}{*}Denormalized MDX{*}{color}{color:#000000}.  The columns return like this where it de-normalizes the crosstab data:{color}{color:#000000}* *{color}
{color:#000000}*\[Product\].\[All\],  *{color}
{color:#000000}*\[Product\].\[Line\], *{color}
{color:#000000}*\[Measures\].\[MeasuresLevel\], *{color}
{color:#000000}*\[Markets\].\[All\],*{color}
{color:#000000}*\[Markets\].\[Territory\], *{color}
{color:#000000}{*}Measure{*}{color}
{color:#000000}For the {color}{color:#000000}{*}Pentaho Analysis (legacy)*{color}{color:#000000} datasource aka {color}{color:#000000}{*}Legacy Banded MDX{*}{color}{color:#000000}, this is the old way the columns returned prior to Pentaho Report Designer 3.5 and created so that reports migrated easily to 3.5  The columns return like this:  {color}
{color:#000000}{*}Product, *{color}
{color:#000000}{*}Product{*}{color}{1}{color:#000000}, {color}
{color:#000000}{*}Quantity/APAC/Markets, *{color}
{color:#000000}{*}Quantity/All Markets/Markets, *{color}
{color:#000000}{*}Quantity/EMEA/Markets, *{color}
{color:#000000}{*}Quantity/Japan/Markets, *{color}