To view a general summary of the target details, navigate to the Summary section, by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

The Summary section provides background information about the target, which helps you locate the target binaries, log files, metadata files, and configuration files for viewing or editing purposes.

Table 8-2 describes the elements of the Summary section.

To view the status and availability history of a target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Monitoring, then select Status History.

Sometimes, due to network problems and system errors, the target might be down, or the Oracle Management Service (OMS) might not be able to reach the Management Agent that monitors the target. The Availability (Status History) page provides information about when, and for how long these situations occurred for a particular target. This information is essential for troubleshooting target related incidents.

The Availability (Status History) page consists of the Overall Availability, Downtime History, and General sections. The Overall Availability section consists of a pie chart depicting the availability of the target, from the time it was discovered. The Downtime History section provides detailed information about the periods when the target was down.

Table 8-3 describes the elements of the General section.

To view the performance or resource usage of a target, navigate to the Response or CPU and Memory Usage section, by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target. Graphs depicting the target performance or target resource usage are displayed.

4. (Optional) To view the performance or resource usage data in a tabular format, click Table View.

The Response and Load section displays the performance of the BI Instance, BI Server, or BI Presentation Server target. For these targets, the Response and Load section can consist of the following graphs:

• The variation of Average Query Time with time

  Average Query Time is the average time the BI Server or BI Presentation Server takes to execute a query. The Average Query Time is collected and uploaded to the Oracle Management Repository every fifteen minutes, by default.

• The variation of Server Queries (per second) with time

  Server Queries (per second) is the number of queries processed by the BI Server or BI Presentation Server in one second. Server Queries (per second) is collected and uploaded to the Oracle Management Repository every fifteen minutes, by default.

• The variation of Completed Requests (per second) with time

  Completed Requests (per second) is the number of requests completed by the BI Presentation Server in one second. Completed Requests (per second) is collected and uploaded to the Oracle Management Repository every fifteen minutes, by default.

Carefully observing these graphs can sometimes provide early warnings about server overloading, reduced server access, and so on. Analyzing graphical data collected over a long period of time can help you set up a more efficient BI Server or BI Presentation Server.

For detailed information on target performance, access the Performance Summary page. To access this page, from the Business Intelligence Instance, BI Server or BI Presentation Services menu, select Monitoring, then select Performance Summary.

The CPU and Memory Usage section displays the resource usage of the target. It consists of two graphs:

• The variation of CPU Usage (%) with time

  CPU Usage specifies the percentage of CPU time used by the target. A large value of CPU Usage can cause the Business Intelligence components and applications to slow down, reducing their performance. The CPU Usage is collected and uploaded to the Oracle Management Repository every fifteen minutes by default.

• The variation of Memory Usage (MB) with time

  Memory Usage specifies the amount of memory used by the target. A large value of Memory Usage can cause the Business Intelligence components and applications to slow down. The Memory Usage is collected and uploaded to the Oracle Management Repository every fifteen minutes by default.

Carefully observing these graphs can sometimes provide early warnings about application overloading, component downtime, and so on.

To view all the metrics collected for a particular target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Monitoring, then select All Metrics.

The All Metrics page displays details about all the metrics collected for a particular target. The average value, threshold values, collection schedule, and metric value history is displayed for each collected metric.

To view and edit the metric and collection settings for a particular target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Monitoring, then select Metric and Collection Settings.

5. To edit the collection schedule or thresholds of a metric, or any other collected item, click the corresponding icon present in the Edit column.

The Metric and Collection Settings page provides details about target metric collection thresholds and target metric collection schedules. Using this page, administrators can edit the warning threshold and critical threshold values of target metrics and other collected items, as well as the time intervals at which these are collected.

To view the metric collection errors for a particular target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Monitoring, then select Metric Collection Errors.

The Metric Collection Errors page provides details about the errors encountered while obtaining target metrics. These details give you an idea of the metrics that may not represent the performance of the target accurately, as errors were encountered while collecting them.

To view a summary of the health of the target, navigate to the Monitoring and Diagnostics section, by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

The Monitoring and Diagnostics section specifies the number of abnormal occurrences related to the target that require user action, and the number of changes made to the target configuration, within a particular time interval. This information is useful to administrators who want to quickly get an idea of the overall health of the target, and know the number of issues that need to be resolved. For more details on target configuration, access Configuration from the BI Instance component menu or Essbase target menu.

Table 8-4 describes the elements of the Monitoring and Diagnostics section.

To view the alert history of a particular target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Monitoring, then select Alert History.

The Alert History page provides details about target metrics, such as the periods when a particular metric was beyond its critical threshold value, the periods when the metric could not be calculated, and so on. These details help you plan corrective measures for metric-related problems, before any severe damage or prolonged downtime can occur.

Table 8-5 describes the elements of the Alert History page.

To view the incidents related to the target, navigate to the Incidents section, by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

The Incidents section provides details about the various events, related to the target, that negatively impact the business intelligence system. These events require user action. The details provided by this section, such as the incident summary, severity, target, target type, and so on, are essential for troubleshooting.

For detailed reports on target incidents, access the Incident Manager page. To access this page, from the BI Instance component menu or Essbase target menu, select Monitoring, then select Incident Manager.

For details on the elements of the Incidents section, refer to Oracle Enterprise Manager Cloud Control Administrator's Guide.

To view the log messages related to a particular target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the BI Instance component or Essbase target menu displayed on the target home page, select Logs, then select View Log Messages.

4. (Optional) To view or download the target log files, click Target Log Files, select the required log file, then click View Log File or Download, respectively.

5. (Optional) To export log messages to a file, from the Log Messages page, select the required messages. From the Export Messages to File menu, click the file format you want to export the selected messages to. Choose a location, and download the file.

The target logs are a repository of target error messages, warnings, and notifications. They can be used for tracing the intermediate steps of an operation, and are essential for troubleshooting incidents and problems.

You can use the Log Messages page to view all log messages, search for a particular message, view messages related to a message, export messages to a file, view the target log files, and download the log files. For more information about log files, refer to Oracle Enterprise Manager Cloud Control Administrator's Guide.

For the BI Instance target, this page displays log messages related to all system components and Java EE components. For the BI Instance component targets and Essbase targets, this page displays only those log messages that are related to the target.

Table 8-6 describes the elements of the Log Messages page.

To view the configuration data of a target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Configuration, then select Last Collected to access the Target Configuration browser.

5. (Optional) To export target configuration data to a configuration file, click Export. The exported target configuration data is stored in a .xls file.

Use the Target Configuration browser to view the latest configuration data of the target. Using the browser, you can also search for configuration data, view saved target configurations, compare target configurations, and view the target configuration history.

To view the past, currently running, and scheduled jobs related to a target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Job Activity.

The Job Activity page displays target jobs related to target administrative tasks, such as starting the target, stopping the target, target blackouts, and so on.

Use the Job Activity page to search for a particular job and retrieve job details such as the owner, status, scheduled start time, and so on. You can also use the Job Activity page to perform target job administration tasks, such as creating, editing, suspending, and resuming a job.

To view the compliance of a target to compliance standards or compliance frameworks, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Compliance, then select Results.

5. To view the compliance results of a target with respect to a particular compliance standard, select Compliance Standards. To view the compliance results of a target with respect to a particular compliance framework, select Compliance Frameworks.

Use the Compliance Results page to view the compliance of a target to compliance standards and compliance frameworks. This page also lists the number of violations made to compliance standards and compliance frameworks, hence giving you an idea of whether the targets in your enterprise adhere to established standards or not.

For more information on target compliance, refer to Oracle Enterprise Manager Lifecycle Management Administrator's Guide.

To view Oracle Business Intelligence dashboard reports, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance. Click the BI Instance name.

3. From the Business Intelligence Instance menu, select Dashboard Reports.

4. From the View list, select the set of dashboard reports you want to view.

Using this page, you can view the dashboard usage in the past 7 days, the dashboards that failed in the past 24 hours, the top dashboards by resource usage in the past 7 days, and the top users by resource usage in the past 7 days. These details tell you which dashboards are the most popular, which dashboards failed recently, which dashboards use the maximum resources, and which user is the most active. An in-depth analysis of these details can provide important insights into the functioning of an enterprise.

You can also perform a SQL drill down of the dashboard by selecting Top Dashboards by Resource Usage in last 7 days, and then clicking the SQL details icon.

In order to do a SQL drill down, you need to discover the database from where the dashboards are fetching the data. To do this, from the Business Intelligence Instance menu, select Target setup, and then select Monitoring Credentials. Select the database which has been discovered and add it using the target selector icon.

Table 8-7 describes the elements of the Dashboard Reports page.

To view Oracle Business Intelligence scheduler reports, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance. Click the BI Instance name.

3. From the Business Intelligence Instance menu, select Scheduler Reports.

4. From the View list, select the set of scheduler reports you want to view.

Using this page, you can view the BI Instance target jobs that failed in the past 24 hours, and the BI Instance target jobs that have been scheduled to begin later. These details inform you about the jobs that failed recently and the jobs scheduled to take place in the future, giving you a summary of the BI Instance past and future job activity.

Table 8-8 describes the elements of the Scheduler Reports page.

To view the key metrics related to the BI Instance target, navigate to the Metrics section by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance. Click the BI Instance name.

The Metrics section displays the key metrics used to monitor the performance of the BI Instance. Analyzing these metrics provides early warnings of errors and incidents, and helps you identify problem areas quickly.

To view all BI Instance metrics, access the All Metrics page. To access this page, from the Business Intelligence Instance menu, select Monitoring, then select All Metrics. For more information on this page, see Viewing Target Metrics.

Table 8-9 describes the elements of the Metrics section.

To view a summary of Oracle Business Intelligence Essbase applications, navigate to the Applications section, by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having an Essbase Server target. Click the Essbase Server name.

The Applications section provides details about the status, resource usage, and data storage type of the various Essbase applications under the Essbase server. This section is useful to administrators who want to quickly obtain an overview of the availability and storage details of the Essbase applications being monitored.

Table 8-10 describes the elements of this section.

To view details about how data for an Oracle Business Intelligence Essbase application is stored, navigate to the Cubes section, by following these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having an Essbase Server target. Click the Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required Essbase application.

The Cubes section provides structural and usage information about the cubes contained in the Essbase application. These details tell you about how data storage is designed for the application, and how accessible the application data is at the moment.

Table 8-11 describes the elements of this section.

To start, stop, or restart a target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. Click Start Up, Shut Down, or Restart to start, stop, or restart the target, respectively. Alternatively, from the BI Instance component menu or Essbase target menu, select Control, then select Start Up, Shut Down, or Restart.

To run certain patching and maintenance tasks, you may need to stop the target, perform the task, and restart it once the operation is complete.

To manage the access privileges for a target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Target Setup, then select Administrator Access.

5. Click Add to grant target access privileges to a role or an administrator.

Use the Access page to set target privileges for roles and administrators. The available privileges are View, Operator, and Full.

View only allows you to view the target in the console, whereas Operator allows you to view targets, and perform all administrative actions except deleting targets. Full allows you to view targets, and perform all administrative actions.

To administer the blackouts for a target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Monitoring, then select Blackouts.

Blackouts suspend data collection on a monitored target. Blackouts are useful when you want to perform scheduled maintenance tasks on monitored targets.

Use the Blackouts page to search for existing target blackouts, edit existing blackouts, define new blackouts, and stop blackouts. You can also create and stop blackouts using the BI Instance component menu, or the Essbase target menu. To create or stop a blackout, from the BI Instance component menu, or the Essbase target menu, select Control, then select Create Blackout or End Blackout, respectively.

To view the monitoring configuration details for a particular target, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance or Essbase Server target. Click the BI Instance or Essbase Server name.

3. From the navigation tree in the Target Navigation window, click the name of the required target.

4. From the BI Instance component menu or Essbase target menu displayed on the target home page, select Target Setup, then select Monitoring Configuration.

The Monitoring Configuration page provides information about instance properties of the target, which provide internal details about target monitoring.

Table 8-12 describes the elements of the Monitoring Configuration page.

To view the BI Instance component failovers, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having a BI Instance target. Click the BI Instance name.

3. Select the Availability tab, then select Failover.

This page displays the risk levels of BI Instance component failure, the recommended backup actions to prevent component failures, and the backup or secondary hosts for components that have failovers configured. Administrators can use this information to plan failovers for BI Instance components that have a high risk of failure.

For more information on the recommended backup actions to avoid BI Instance component failures, refer to Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

To edit the BI Instance monitoring credentials, follow these steps:

1. From the Targets menu, select Middleware.

2. From the navigation tree, select the Oracle Fusion Middleware farm having an BI Instance. Click the BI Instance name.

3. From the Business Intelligence Instance menu, select Target Setup, then select Monitoring Credentials.

4. Edit the required fields, then click Save.

This page enables you to specify and edit the credentials required to connect to the database which stores scheduling and usage tracking information. Without specifying the correct credentials on this page, you cannot access certain dashboard reports. Hence, ensure that you specify the appropriate credentials on this page before accessing the Dashboard Reports page.

Table 8-13 describes the elements of the Monitoring Credentials page.