Step 1: Open a browser give the cloud url. Provide your Identity domain. Check the Save your identity domain selection for future sign-ins. Click on Go.
Step 2: Sign in to Cloud by providing your username and password.
Step 3: In the Oracle Cloud Homepage click the Data Modeler.
Step 4: The Data Modeler opens, here you can see that the model is made up of the Facts tables, the Dimension tables and the Joins between them. Click on the Lock to Edit button to make changes to the model.
Step 5: Click on the Model Actions. Click on Create Time Dimension.
Step 6: In the Create Time Dimension Dialog box, specify the names of the database table, dimension tables and the hierarchical columns and your own custom level of hierarchies. Change the names if required. Click next.
Step 7: Click Create and the following objects will be added to your model.
Step 8: When you see the message ,”The time dimension was created successfully.”, Click done.
Step 9: Now you see the database table appear in the database pane and you can also check for the data.
Step 10: Click on time in the dimension pane and then click the source data.
Step 11: Now you can validate the data model by clicking on the tick symbol. Then you can see the message the , ‘This model is valid’.
Step 12: Now you can publish the model with no errors to the subject area. Click on publish. This will also unlock the model.
Step 13: You can now navigate to the visual analyzer to use the time dimension that is available in the subject area to create projects, reports & dashboards.