Building the Fact Table and Dimension Table in Data Modeler
- In the Data Modeler, click Lock to Edit button.
- The Information dialog box displays confirming that you have successfully locked the model for editing.
- Click OK. The model is locked by the current user for editing.
- In the Database accordion, select the W_AP_AGING_SUPPLIER_A table, click the Table Actions icon , and select Add To Model.
- The Add W_AP_AGING_SUPPLIER_A to SampleApp dialog box is displayed.
- Select the Add as Fact and Dimension Tables option, deselect the Let Data Modeler Recommend option, and click OK.
- The Add W_AP_AGING_SUPPLIER_A to SampleApp wizard is displayed.
8. Create a new dimension table by selecting the following columns from the W_AP_AGING_SUPPLIER_A table and dragging them under NEW_DIMENSION :
- Click the name of the new dimension table, and change it to Location and Date.
10. Click Add to add a new dimension table .
A new dimension table is added below the Location and Date dimension table.
- Create a new dimension table by selecting the following columns from W_AP_AGING_SUPPLIER_A table and dragging them under NEW_DIMENSION :
- Click the name of the new dimension table, and change it to Payables.
- You can also add more dimension tables, by clicking on the Add button, if required.
- Create a fact table by completing the following steps:
a) Select the following columns from the W_AP_AGING_SUUPLER_A table and drag them under NEW_FACT.
b) In the Location and Date dimension table, select the LOC_CURR_CODE column as a primary key. This adds the LOC_CURR_CODE column to the fact table and creates a join between the Location and dimension table and the fact table.
c) In the Payables dimension table, select the OUTSTAND_XACT_CNT column as a primary key. This adds the OUTSTAND_XACT_CNT column to the fact table and creates a join between the Payables table and the fact table.
- Click the name of the new fact table, and change it to Facts.
- Click Next.
The wizard displays three Database views, a Fact table, two dimension tables and two joins.
- Review the listed objects, and click Create.
The three Database Views, a Fact Table, two Dimension Tables and two Joins are created in the model.
- Click Done.
The SampleApp data model is displayed with the names of the fact table, dimension tables, and joins.