Add new fields to a Jet Analytics project

Overview

A major benefit of using Jet Analytics is the ability to adapt standard projects to fit your organization’s specific needs. The following instructions detail the basic steps for adding new fields from a data source into the staging database, progressing to the data warehouse, and ultimately into the OLAP cubes.

Adding Field(s) to Staging Database

1. In the Business Unit, select the data source you would like to add fields from.

   (We recommend synchronizing your data source to ensure the schema is current. You can do this by right-clicking your data source and selecting "Synchronize objects" or "Read Objects".)

   In the Data Selection pane on the right side, select the box beside the field(s) you would like to add. In this example, we will be adding the Address field in the Customer table.

   

   After selecting the box beside the Address field, you will see it appear in the Data Sources under the Customer table.

   

2. Next, navigate to the staging database in the Business Unit. Notice that the affected table(s) are highlighted in red. That indicates that changes were made to the project that require deployment. In this example, we added the ‘Address’ field to the ‘Customer’ table.

   

   You have the option to deploy and execute the entire database or to deploy and execute just the changed objects individually. In the preceding example, we made changes to only one table to make it easier and faster to deploy and execute that one table. To do so, right-click the table and select Deploy and Execute.

Once the deployment and execution are complete, the table structure will include the newly added field, and the data from the source will be loaded in the staging database.

Mapping Field(s) to the Data Warehouse

1. In the Data Warehouse, select the table corresponding to the field(s) you added to your staging database. In our example we added the ‘Address’ field to the ‘Customer’ table. When the table is selected, you will notice that the ‘Data Movement’ pane appears on the right.

   To add newly created fields to the Data Warehouse, select and then drag and drop them into the corresponding table(s) in the Data Warehouse. In our example, we will select the ‘Address’ field in the ‘Data Movement’ pane and drag and drop it into the ‘Customer’ table in the Data Warehouse.

   

2. Now that the field(s) has been added, you will notice your table is highlighted in red with an asterisk, indicating there are undeployed changes. You will need to deploy and execute the table to apply the changes and pull the new data in to the table. You can do so by right-clicking the table and selecting Deploy and Execute.

   

3. Once this deployment and execution have completed, the table(s) will have been rebuilt with the new field(s) and the new data will be loaded into the Data Warehouse.

Mapping New Field(s) to OLAP

1. In the OLAP database, drill down into the dimension that corresponds to the data warehouse table where you mapped your new field(s). Again, in our example, we added the ‘Address’ field to the ‘Customer table

   

2. Right-click a level in this dimension and select Add Quick Levels.

   

3. This will open the Add Quick Levels dialog box. From here, scroll to the field(s) you want to include in this dimension and select the box beside it. In our example, we will select the box next to the Address field. Then click OK.

   

4. Now that the field(s) are added as a level in the dimension of your OLAP, you need to deploy and execute the entire OLAP database. When making changes to a table in the staging or data warehouse databases, you can selectively deploy and execute individual tables. However, a single change to a dimension in the OLAP database could potentially affect multiple cubes. Therefore, you must deploy and execute the entire OLAP database to apply the schema changes and pull the data into the cubes correctly. To do this, right-click on the OLAP database at the top of the tree and select Deploy and Execute.