Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Friday, 24 January 2014

Dimension Usage Example in Pentaho Schema Workbench

Many of us have a bit confusion when to use Dimension and Dimension Usage.

Today, I have explored it by opening the FoodMart.xml schema example.
I'd like to share what I understand from this...

Software:
 Mondrian- Pentaho Schema Workbench 3.6.1 stable.
Download link:
http://jaist.dl.sourceforge.net/project/mondrian/schema%20workbench/3.6.1-stable/psw-ce-3.6.1.zip

My understanding points


1) Add "Dimension" to your schema.(Externally to the schema but not to any CUBES)
2) Use the same "Dimension" added to your schema in any number of CUBES as "Add Dimension Usage"
3) Suppose you are using a dimension in 3 different cubes you may think of creating that dimension 3 times. The problem which I understand is replication of dimension is taking place in the schema file.

Using "Add Dimension Usage" feature we can eliminate it.

Also, I read some thing about it in the Mondrian technical document at page 113 - I need to have a complete understanding on it.


Example which I extracted from FoodMart.xml schema is described below.

Click here to download the example


A quick understanding image is given below.

Example developed using : foodmart database of postgresql which is an example database for jasperserver postgres.