Creating a Prototype Schema With a Non-PDI Data Source
Your data sources must be configured, running, and available before you can proceed with this step.
Follow the below procedure to create a OLAP schema prototype from an existing database, file, or data warehouse.
Note: If you are already using PDI to create your data source, skip these instructions and refer to Creating a Prototype Schema With a PDI Data Source instead.
- Start Spoon and connect to your repository, if you are using one.
- Go to the File menu, then select the New sub-menu, then click on Model. The interface will switch over to the Model perspective.
- In the Properties pane on the right, click Select. A data source selection window will appear.
- Click the round green + icon in the upper right corner of the window. The Database Connection dialogue will appear.
- Enter in and select the connection details for your data source, then click Test to ensure that everything is correct. Click OK when you're done.
- Select your newly-added data source, then click OK. The *Database Explorer *will appear.
- Traverse the database hierarchy until you get to the table you want to create a model for. Right-click the table, then select Model from the context menu. The Database Explorer will close and bring you back to the Model perspective.
- 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.
- Select each new measure and dimension item, and modify its details accordingly in the Properties pane on the right.
- 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.