Enabling or Disabling Standard Dimensions
Your company may not require all of the standard dimensions provided by Oracle Project Analysis Collection Pack. Disabling any unnecessary dimensions can improve the performance of Oracle Project Analysis Collection Pack and your data warehouse by reducing the amount of information processed by collection programs and by minimizing the size of your data mart and data warehouse.
Warning: Plan and execute all of your customizations before you load information into the interface tables and generate your data warehouse. Performing customizations after you implement and use the data warehouse requires the regeneration of the data warehouse, which can be very time-consuming.
Attention: You must disable dimensions before freezing the data warehouse metadata in the OADW repository and before customizing your collection views. If you subsequently enable or disable a dimension after you have generated the OADW runtime warehouse, you must regenerate the runtime warehouse to collect data based on the new set of dimensions.
1. From the Navigator window, choose Setup > Collection Pack > Dimension.
2. Check the Enable check box next to the dimension you want to enable, or uncheck it if you want to disable the dimension.
4. Choose Regenerate Views to regenerate the collection views based on the new set of dimensions.
The view generation process creates a view definition file in the concurrent processes log file. You can use the concurrent request log file to extract the script to customize the view definition file after the generation process has executed successfully.
Disabling a dimension replaces the column representing the dimension with -1 or UNKNOWN, depending on the datatype of the column.
Attention: You must submit the PRC: Refresh Dimension and Fact Tables process after you regenerate your views to update information based on your changes if you ran either collection process before enabling or disabling the dimensions.