Schema Workbench Part 2 (PDM2006S)


Please click the button below to enroll for this training.



(2 hrs) Self-paced, interactive online training with a simulated practice environment (Part of PDM2000S).


This self-paced eLearning module continues from PDM2005S and provides further details about Pentaho Schema Workbench which is visual application for building and testing Mondrian schema files.



Some basic knowledge of database design and dimensional modeling is desirable as well as knowledge of Pentaho Interactive Reports and Pentaho Analyzer. These are covered within the course “Pentaho Business Analytics” (PBA1000S self-paced, or PBA1000L instructor-led), or individually in “Pentaho Interactive Reports” (PBA1004S) and “Pentaho Analyzer” (PBA1005S).

This eLearning module builds on "Schema Workbench Part 1" (PDM2005) - which should be completed first.


This training includes:

  • Creating a time period dimension
  • Adding annotations for time period dimensions
  • Adding annotations for geography dimensions
  • Adding member properties
  • Creating a degenerate dimension
  • Creating a calculated measure
  • Testing the schema in MDX query mode
  • Publishing the schema
  • Using the cube in Analyzer
  • Access control in Schema Workbench
  • Introduction to the Food Mart sample schema file