If you want to ...

You need to ...

Include a Component in the Data Warehouse.

To include a Component in the Data Warehouse, you will need to set a flag so that the Component will be exported. To do so, you have the following two options (both will have an identical outcome):

OPTION 1: in the Component Management Form.

• Open the required Component
• Tick the flag Use this component in BI Reporting

OPTION 2: navigate to Designer Configuration Management BI Components, and either select:

• Components to ADD to data warehouse (only shows components that are NOT already in the data warehouse), OR
• Components to REMOVE from data warehouse (only shows components that ARE already in the data warehouse)
  

NOTE:

If the you also intend to include any "related component" in your reporting, you will have to do the same for each of these related components.

For example, if you intend to report on Incidents, but also include Reported By and Department Responsible, you would have to mark all these components:

• Incidents
• Person
• Department

Rename Components, Fields and Relationship for the Data Warehouse

In some instances it will be necessary to modify the automatically generated names which are used for the tables, columns, views etc. in the data warehouse.

It will be more likely a necessity for ORACLE clients, since ORACLE has a limit of 30 characters for table, field and view names.

Update the ETL scripts, which define the structure of the Data Warehouse, after having made some configuration changes in SAI360.

If you update a configuration in SAI360, for example by adding/modifying fields and relationships, it will be necessary to reflect these changes in the Data Warehouse.

1. CREATE the ETL scripts, Cube Schemas and JOBS:
   - in SAI360, navigate to Designer System Publish BI and select Run.
2. RUN the ETL scripts, which will update Structure and Content of the Data Warehouse:
   - this will be achieved by an automated process, which will be performed after step 1.