Oracle® Healthcare Operating Room Analytics User and Administrator Guide Release 1.0.1 E16680-03 |
|
|
PDF · Mobi · ePub |
This chapter contains the following topics:
Maintaining the Oracle Healthcare Operating Room Analytics Repository
Maintaining the Oracle Healthcare Operating Room Analytics Warehouse
You can modify the ORA-delivered repository file (RPD) for any one of the following reasons:
You have added a column or table to the data warehouse, and now need to propagate that addition into the layers of the repository.
To add a calculated column as a function of some set of physical layer columns.
To modify a repository variable value, or add a new repository variable, for use in some Web Catalog calculation.
To modify a group, an account, or a privilege maintained through the repository.
Caution:
Exercise caution when you modify the RPD. Please conform with the following recommendations.The following rules apply when you modify the RPD:
Privileges to make changes should be granted only to a limited set of users who need to make such changes and also know how to make them correctly.
At upgrade time, use the OBIEE utility equalizerpds.exe
to merge your modified RPD with the Oracle-supplied RPD.
See Also:
Oracle Business Intelligence Server Administration Guide for more information about modifying the RPD.
Oracle Business Intelligence Server Administration Guide for more information about modifying the RPD.
For better performance of the dashboards and analyses, you should partition the following tables:
Table 4-1 Tables for Partitioning
Table | Partition Type | Columns Involved |
---|---|---|
W_EHA_CASE_F |
PARTITION BY RANGE |
CASE_DT_WID |
W_EHA_OR_UTILIZATION_F |
PARTITION BY RANGE |
UTILIZATION_DT_WID |
W_EHA_PROCEDURE_F |
PARTITION BY RANGE |
PROCEDURE_DT_WID |
W_EHA_SCHD_PROCEDURE_F |
PARTITION BY RANGE |
SCHD_PROCEDURE_CREATION_DT_WID |
W_EHA_SCHEDULED_CASE_F |
PARTITION BY RANGE |
SCHEDULED_CASE_CREATION_DT_WID |
You should make partitions such that one partition holds data for one calendar month for a fact. For example, if the warehouse table has data for one year, there should be 12 partitions created based on the values of the partitioned column.
Also, the create script for bitmap indexes on partitioned tables should be changed. For example:
CREATE BITMAP INDEX IDX1 ON TAB1 (COL) local;