Prerequisites

• You will need to be logged into BI User Console to perform any of the following actions.
• You will need to have access to the Schema Workbench.
• The ETL Process on the Evotix 360 database has already been performed.
• The Schema has already been designed and saved.

The information provided in this section is only high level. If you need more detailed instruction, please refer to the Pentaho Online Help.

If you want to use a Schema for Analytics Reports, you need to ...

Perform these steps ...

Publish the Schema to the BI Server.

On the computer which has the BI Tools installed, open Pentaho Enterprise Edition Design Tools Schema Workbench.

• Open the Schema file which you want to use for your report(s).
• Select File Open, and open the Schema
• Select File Publish
• Enter the "Pentaho Credentials" and Publish the Schema.
  
  
  

Create a new Data Source in the User Console

Log into the BI User Console, and

• select Manage Data Sources
• click on the cogwheel icon next to the "New Data Source" Button and select Import Analysis.
  
  
  
• In the Import Analysis Window, select:
  - Mondrian File: select the Schema you have used in the previous step
  - Data Source: select the Database which is the basis for the Schema:
  and Import your settings.