Datawarehouse Architect

  Database Setup Use the preconfigured scripts that come with each server installation to quickly create the usage tracking table. Common SQL scripts are located in the \OracleBI\server\Schema folder and are named as SAACT.xxx.sql The option exists to not directly insert records into a database table and have the information collect in flat files on the Oracle BI Server. A „best practice‟ is to directly insert the records into the database. A Usage Tracking „best practice‟ is to create the s_nq_acct table in its own schema in the underlying database. This will allow your DBA‟s to isolate the Oracle BI Server writing to the database. Metadata Configuration  Once the table has been imported and the second connection pool has been created, test to make sure each connection pool is functioning correctly. A "best practice‟ is to create two connection pools when reporting against the usage tracking table. One connection for the server to insert data and another to report on the tabl...

  Why OBIEE Server Caching? 1. Improve Speed of Queries 2. Reduce Network I/O 3. Reduce Database Processing 4. Reduce System Cost (charge back environments) 5. Reduce OBIEE Server Processing Caching Strategy 1. Volatility of Data 2. Granularity of Data 3. Predictability of Changes 4. Volume of Queries 5. Purging 6. Seed Cache Volatility of Data in Caching Strategy Volatility pertains to the frequency of data change in your environment. Volatile data changes more frequently (relative) than non-volatile data. Typically, the benefits of OBIEE server caching diminish as the data becomes more volatile. In other words, the amount of effort and processes to keep the cache synchronized with the data outweigh the benefits. In volatile environments, effort should be concentrated to performance tuning at the database level through a well-designed data model, physical architecture, indexing, and database caching strategy. Granularity in Caching Strategy  Tied directly to volatility i...