Skip to content

Step 6: Creating a Time Dimension in Oracle Analytics Cloud

Oracle Analytics Cloud modeler can create a custom Time dimension, without needing a physical table. Our sample analysis and dashboards will make use of a hierarchical display, based on this time dimension.

Click on “Lock and Edit” to launch the modeler tool again (Screen 26).

Screen 26

Click on the “Add” button in Dimension Tables and choose “Create Time Dimension” (Screen 27).

screen-27-oracle-analytics-cloud-create-time-dimension

Screen 27

Choose “Year” and “Month” levels for the time dimension. Click “Next” and then “Create”. The time dimension table in the database will automatically be created and loaded (Screen 28).

screen-28-oracle-analytics-cloud-create-time-dimension

Screen 28

Now we need to join this time dimension with our fact table. Create the join between Time dimension and the Paid date (Time_paid_dt) column.

The model now has one fact table, five dimension tables, and five joins, as shown below (Screen 29).

screen-29-oracle-analytics-cloud-create-time-dimension

Step 7: Creating an Analysis in Oracle Analytics Cloud

Now that we have created a Time Dimension, we are ready for the next step: creating an Analysis. Click “Next step” to go to Step 7: Creating an Analysis in Oracle Analytics Cloud.