Add New Dimension Using Flex Bucketing

Note:

In the Oracle Argus Safety Aggregate Reporting Data Model, you may update any column value. For more information, refer to Extending with User Exits in the Oracle Argus Safety Flexible Reporting Extensibility Guide.

For Example:

PROLONGED EXPOSURE column which exists in the Oracle Analytics Server RPD can be updated in the Aggregate Reporting Data Model and it can be used for analysis in the Oracle Analytics Server Answers/Dashboards.

New dimensions can be created on the existing RPD.

The following are the steps of creating a dimension from the source RM_CODE_LIST_DETAIL_DISCRETE_D, explained with the help of an example:

1. Open the Oracle Argus Insight RPD using the default password (insight 123), or the password changed using the steps mentioned in the Oracle Argus Safety and Oracle Argus Insight Installation Guide.
2. At the Physical Layer, right-click on RM_CODE_LIST_DETAIL_DISCRETE_D, and create an alias.

   Figure 5-6 Physical Layer — Creating Alias

   
3. Enter the dimension name for the alias.

   For example: Dim_CASE_SERIOUSNESS

   Figure 5-7 Dimension Properties

   
4. Create join with the corresponding Fact table in this case FACT_RM_RPT_AGG_CASE, as shown below:

   Figure 5-8 Join with the Fact table

   

   Figure 5-9 Join Definition

   
5. Drag this dimension into the Business Layer and set the WHERE clause at the business layer.

   Figure 5-10 Business Layer — WHERE clause

   
6. Right-click and create a logical dimension.
7. Go to Facts > Sources, and add the dimension to the corresponding logical table source.

   Figure 5-11 Logical Table Source

   
8. Drag the dimension to the presentation layer in the corresponding tree level.

   Figure 5-12 RPD — Presentation Layer

   
9. When the RPD is deployed, the new dimension can be used in the Oracle Analytics Answers/Dashboards.