Conformed Dimensions in Oracle Argus Analytics

A conformed dimension is a set of data attributes that have been physically implemented in multiple database tables using the same structure, attributes, values, definitions and concepts in each implementation. It is always a good practice to use Conformed Dimension columns along with the Facts when we create any Requests. By using the conformed dimensions, Oracle Analytics Server forms select statements that choose the correct Fact table to display accurate data.

Non-conformed dimensions imply the existence of logical and/or physical inconsistencies that should be avoided. Using Non-conformed Dimensions with the Fact leads to unwanted Table selection in the Query formation which results the Report to display null values (in case of Aggregates values) and might degrade the Performance of the Request or Report.

For example: If the user selects some of the aggregate measures from Case Version Fact along with the Routing user from User Dimension and Workflow State from State Dimension, the Report does not display the aggregate measures values as both the selected Dimension attributes are Non-conformed Dimensions for the Case Version Fact.

The following table contains the details of the conformed Dimensions for the Facts we have used in Oracle Argus Analytics.

Table 6-1 Retrospective Facts and their Conformed Dimensions

Retrospective Facts	Conformed Dimensions
Case Fact	Enterprise
Case Fact	Case Processing Site
Case Fact	Product
Case Fact	Study
Case Fact	Period - Clock Start Date
Case Fact	Period - Initial Receipt Date
Case Version Fact	Enterprise
Case Version Fact	Case Processing Site
Case Version Fact	Product
Case Version Fact	Study
Case Version Fact	Period - Clock Start Date
Case Version Fact	Period - Initial Receipt Date
Case Version Fact	Period - Version Receipt Date
Case Routing Fact	Enterprise
Case Routing Fact	Case Processing Site
Case Routing Fact	Product
Case Routing Fact	Study
Case Routing Fact	Period - Clock Start Date
Case Routing Fact	Period - Initial Receipt Date
Case Routing Fact	Period - Version Receipt Date
Case Workflow State Fact	Enterprise
Case Workflow State Fact	Case Processing Site
Case Workflow State Fact	Product
Case Workflow State Fact	Study
Case Workflow State Fact	Period - Clock Start Date
Case Workflow State Fact	Period - Initial Receipt Date
Case Workflow State Fact	Period - Version Receipt Date
Case Work User Fact	Enterprise
Case Work User Fact	Case Processing Site
Case Work User Fact	Product
Case Work User Fact	Study
Case Work User Fact	Period - Clock Start Date
Case Work User Fact	Period - Initial Receipt Date
Case Work User Fact	Period - Version Receipt Date
Case Work Fact	Enterprise
Case Work Fact	Case Processing Site
Case Work Fact	Product
Case Work Fact	Study
Case Work Fact	Period - Clock Start Date
Case Work Fact	Period - Initial Receipt Date
Case Work Fact	Period - Version Receipt Date
Expedited Submission	Enterprise
Expedited Submission	Case Processing Site
Expedited Submission	Product
Expedited Submission	Study
Expedited Submission	Period - Clock Start Date
Expedited Submission	Period - Initial Receipt Date
Expedited Submission	Period - Version Receipt Date
Expedited Submission	Expedited Submission Dimensions - Report Generation Date
Expedited Submission	Expedited Submission Dimensions - Report Submission Or MDN Date
Expedited Submission	Expedited Submission Dimensions - License
Expedited Submission	Expedited Submission Dimensions - Report Destination
Report Routing	Enterprise
Report Routing	Case Processing Site
Report Routing	Product
Report Routing	Study

Table 6-2 Current Facts and their Conformed Dimensions

Current Facts	Conformed Dimensions
Pending Cases	Enterprise
Pending Cases	Case Processing Site
Pending Cases	Product
Pending Cases	Study
Pending Cases	Period - Initial Receipt Date
Pending Reports	Enterprise
Pending Reports	Case Processing Site
Pending Reports	Product
Pending Reports	Study
Pending Reports	Period - Initial Receipt Date
Pending Reports	Pending Report Dimensions - License
Pending Reports	Pending Report Dimensions - Report Destination