Hitachi Vantara Pentaho Community Wiki
Child pages
  • Creating a Prototype Schema With a PDI Data Source

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Creating a Prototype Schema With a PDI Data Source

  1. Start Spoon and connect to your repository, if you are using one.
    Code Block
    cd ~/pentaho/design-tools/data-integration/ && ./spoon.sh
    
  2. Open the transformation that produces the data source you want to create a OLAP schema for.
  3. Right-click your output step, then select Model from the context menu.
  4. Drag items from the Data pane on the left and drop them into either the Measures or Dimensions groups in the Model pane in the center. The Measures and Dimensions groups will expand to include the items you drag into them.
  5. Select each new measure and dimension item, and modify its details accordingly in the Properties pane on the right.
  6. Save your model through the File menu, or publish it to the BA Server using the Publish icon above the Model pane.

You now have a basic OLAP schema. You should test it yourself before putting it into production. To do this, continue on to Testing With Pentaho Analyzer and Report Wizard.