Page Comparison

{color:#000000}For Pentaho Anaysis data source, there are 3 types of OLAP data source types \[Pentaho Analysis, Pentaho Analysis De-normalized, and Pentaho Analysis (Legacy)\].  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}
*JPivot* returns it like this:

 !jpivot.png|border=1!


{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}

!pentaho analysis.png|border=1!

{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}

!pentaho analysis denormalize.png|border=1!


{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}


!pentaho analysis legacy.png|border=1!