How To Enable And Configure Oracle BI Summary Advisor Utility On Exalytics
(Doc ID 1472652.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Exalytics Software - Version 184.108.40.206.0 and later
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 and later
Oracle TimesTen In-Memory Database - Version 18.104.22.168.4 and later
Information in this document applies to any platform.
This document describes how to setup the Oracle BI Summary Advisor. This new feature is only available with the Oracle Exalytics machine and enables creation of aggregate tables to improve query performance.
The Oracle BI Summary Advisor feature requires multiple setup tasks (i.e. enable Summary Advisor feature, set up Oracle Business Intelligence (OBIEE) Admin Tool, gather usage statistics, run the Summary Advisor utility and execute aggregation scripts to create TimesTen summary tables). This document only covers the steps needed to enable Summary Advisor on Oracle Exalytics. For more details on Summary Advisor and Usage Tracking features please see the documentation below:
- Creating and Persisting Aggregates for Oracle BI Server Queries and Using Oracle BI Summary Advisor to Identify Query Candidates for Aggregation in Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1)
- Managing Usage tracking in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Prerequisites for enabling Oracle BI Summary Advisor feature on Oracle Exalytics|
|Enabling and Configuring Oracle BI Summary Advisor|