...
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.
Based on the following MDX query using SteelWheels:
| Code Block |
|---|
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! |
JPivot returns it like this:
For the Pentaho Analysis datasource aka Banded MDX. The columns return like this:
[Product].[All],
[Product].[Line],
[Measure].[Quantity]/[Markets].[All Markets],
[Measure].[Quantity]/[Markets].[All Markets].[APAC],
[Measure].[Quantity]/[Markets].[All Markets].[EMEA],
[Measure].[Quantity]/[Markets].[All Markets].[Japan],
[Measure].[Quantity]/[Markets].[All Markets].[NA].
For the Pentaho Analysis (De-Normalize) datasource aka Denormalized MDX. The columns return like this where it de-normalizes the crosstab data:
[Product].[All],
[Product].[Line],
[Measures].[MeasuresLevel],
[Markets].[All],
[Markets].[Territory],
Measure
For the Pentaho Analysis (legacy) datasource aka Legacy Banded MDX, 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 and beyond. The columns return like this:
Product,
Product{},
Quantity/APAC/Markets,
Quantity/All Markets/Markets,
Quantity/EMEA/Markets,
Quantity/Japan/Markets,
