Creating a custom RDE

The Reporting and Analysis installation includes logic that allows sponsor users to create scripts that can change the content of the RT_MD_VIEWDICTIONARY and RD_DATADICTIONARY tables to modify the default RDE before data is extracted. Self-hosted customers can modify the structure of the RD views, and can create or drop views based on the data that appears in existing views.

Perform the following steps to customize RDE views:

1. Create a customization SQL file with SQL statements to insert, delete, and update the RT_MD_VIEWDICTIONARY and RD_DATADICTIONARY tables.

   For more information, see Creating a customization script.

2. Run the RD_VIEWS_GEN.GenerateRDViews stored procedure to propagate your changes to the RD views.

   For more information, see Running the customization script.

   Hosted customers who want custom RDEs must contact an Oracle Consulting representative.

• Creating a customization script
  
• Running the customization script
  
• Example: Drop a view
  
• Example: Drop a column from an existing view
  
• Example: Change a column name
  
• Example: Change a view name
  
• Example: Add a where clause to a view
  
• Example: Add a column to a view
  
• Requesting the extract—Hosted customers only