Enabling Report Schema (Oracle BI EE) by Default

  To enable Report Schema (Oracle BI EE) by Default:

1. Add the below content to personal_config.properties/site.properties

   # Report database information
   Database.IOP_report_datasource.Name=IOP_report_${System.InstanceName}_datasource
   Database.IOP_report_datasource.DriverClassName=${Database.IOP_datasource.DriverClassName}
   Database.IOP_report_datasource.URL=${Database.IOP_datasource.URL}
   Database.IOP_report_datasource.User=interlacerept
   Database.IOP_report_datasource.Password=password
   Database.IOP_report_datasource.Properties=${Database.IOP_datasource.Properties}
   Database.IOP_report_datasource.TestTable=${Database.IOP_datasource.TestTable} 
   
   ReportSchema.Enabled=true
   ReportSchema.ViewPrefix=REP

2. Create the database user with credential interlacerept/ password as specified in personal_config.properties.

3. Run the isreset command.

4. Do one of the following:

   • Run bootstrap.bat for Windows, or bootstrap.bat for Linux, to populate report schema.

   • To drop and repopulate the report schema, execute generatereportschema.batfor Windows or .generatereportschema.sh for Linux.