One of the great benefits of using Jet Analytics is being able to customize the standard projects to fit the needs of the organization. The steps below walk through the basic steps of adding new fields from a data source in to the staging database, in to the data warehouse, and then in to 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.
(I 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, check the box beside the field(s) you would like to add. In this example, I'll be adding the Address field in the Customer table.
After checking the box beside the Address field, you will see it appear in the data source under the Customer table.
2. Then, navigate to the Staging database in the business unit. You'll notice the affected table(s) are highlighted in red, indicating that changes have been made to the project that are undeployed. In my example, the Address field has been added to the Customer table.
You will need to deploy and execute these modified tables. You can deploy and execute the entire database or, to save time, just deploy and execute the individual tables. In my demonstration, I will deploy and execute just this table by right clicking the table and selecting "Deploy and Execute"
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 stage.
Mapping Field(s) to Data Warehouse
1. In your Data Warehouse, select the table corresponding to the field that was added in to the staging database. In my example, the field Address was added in the Customer table. When you select the table, you will notice the Data Movement pane appears on the right.
From this data movement pane, you will click and drag the new field(s) and drop them on the corresponding 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"
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 your OLAP database, drill down in to the dimension that corresponds to the data warehouse table where you've mapped a new field. In my example, I 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" dialogue box. From here, you will scroll to the field(s) you would like to include in this dimension in your OLAP and check the box beside them. In my example, I am just adding the "Address" field. Click "OK"
4. Now that this field has been added as a level in a dimension in your OLAP, you will need to Deploy and execute your entire OLAP database. When making changes to a table in the staging database or data warehouse, we could deploy and execute just those tables. When making changes to a dimension in the OLAP database, however, multiple cubes will be impacted by the change made to this one dimension. Therefore, you will need to deploy and execute your entire OLAP database to apply the changes to the schema and pull the new data in to the cubes. You can do this by right clicking the OLAP and selecting "Deploy and Execute.