• Oracle Bi Administration Tool Download

To import the metadata for this Oracle OLAP analytic workspace into an Oracle BI Repository, make sure you are using OBIEE 11.1.1.5 and start the Oracle BI Administration tool from the Windows Start Menu. New Features in Oracle Business Intelligence 11g Release 1 (11.1.1.5). The Oracle Business Intelligence client tools installer is provided for organizations that. Automated BI information distribution. Oracle BI analytic applications. Health check program. Select Oracle Call Interface (OCI). After installation finishes, restart BI Administration Tool.

6/44 1 Introduction to Oracle Business Intelligence System Administration This chapter introduces system administration in Oracle Business Intelligence, explains what a system administrator does; describes where to get started with typical system administration tasks; describes the Oracle Business Intelligence architecture; lists the tools that can help you complete system administration tasks, and provides links to system requirements and certification information. This chapter includes the following topics:. 1.1 What Are the Oracle Business Intelligence System Administration Tasks? Administering an Oracle Business Intelligence system involves the following tasks:.

Configuring a system for deployment after installation Configuring metadata and content, general preferences, and default system settings. Starting and stopping the system when required Bringing the system up and down during system maintenance tasks. Configuring security Securing access to the Oracle Business Intelligence system, metadata, and data, configuring Secure Sockets Layer (SSL) and Single Sign-On (SSO), and integration with identity management systems. Scaling out and configuring for high availability Configuring the Oracle Business Intelligence system for linear scale-out and identifying and removing single points of failure. Managing performance and availability Monitoring service levels and tuning performance. Managing and resolving issues Diagnosing errors and establishing resolutions. Moving a system from test to production Managing the steps for moving from a test to a production environment.

Backing up and recovering data Preparing for and recovering from unexpected events. For more information about these tasks, see.

Table 1-1 Oracle Business Intelligence System Administration Tasks System Administration Task More Information Learning about Oracle Business Intelligence system administration For more information, see the topics in this section. Contains information about the system architecture, components, tools, links to other related topics, and certification information. Viewing Oracle Business Intelligence status Also contains information about using Fusion Middleware Control and using WebLogic Server Administration Console. Configuring Oracle Business Intelligence Contains information about the available methods for updating configuration settings and where configuration files are located. Starting and stopping Oracle Business Intelligence Contains various topics on starting and stopping components, in addition to troubleshooting information.

Managing availability and capacity Contains chapters about scaling the environment, deploying for high availability, performance tuning, and query caching. Diagnosing problems and resolving issues Contains chapters about diagnosing and resolving issues and about usage tracking. Configuring Oracle Business Intelligence Contains chapters about required configuration such as configuring repositories and connections to external systems. Modifying advanced configuration settings Contains chapters about advanced and optional configuration settings for features such as analyses, dashboards, and maps. Configuring Oracle BI Scheduler For more information, see Automating management of an Oracle Business Intelligence system Describes the Oracle BI Systems Management API.

Managing the life cycle. Contains chapters about life cycle management tasks such as patching, moving between environments, and backup and recovery. Securing the system.

Defines administrative role membership. Secures middle-tier communications Secure Sockets Layer (SSL) and Single Sign-On (SSO) are not described in this guide. For information, see. 1.3.1.1 A Single Host and Enterprise Install In an Enterprise Install type, the following components are installed in the Oracle BI Domain on the single host. The BI Domain consists of Java components that are deployed into one or more Java EE (JEE) containers within a single WebLogic server domain; system (non-JEE) components and processes; and required configuration files, metadata repositories, and infrastructure.

Java Components — Deployed as JEE applications to service SOAP, HTTP, and other forms of requests. For more information, see. Administration Server — Deployed as a JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system. These components include Oracle WebLogic Server Administration Console, Oracle Fusion Middleware Control, and JMX MBeans. For more information, see. Managed Server — Deployed as a JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system.

These services and applications include BI Publisher and Oracle Real-Time Decisions. An Oracle BI domain contains one or more Managed Servers that are distributed across one or more host computers. Node Manager — Provides process management services for the Administration Server and Managed Server processes. For more information, see. System Components — Deployed as server processes and provide the core services that enable Oracle Business Intelligence, including OPMN.

OPMN (Oracle Process Manager and Notification server) maintains the Oracle Business Intelligence system component processes. For more information, see For more information about OPMN, see. Other Domain Contents — Includes all the necessary software, metadata, configuration files, RPD files, Oracle BI Presentation Catalog, and connection and database configuration information that are required to run an Oracle Business Intelligence system. Illustrates the Oracle Business Intelligence system architecture on a single host for an Enterprise Install type. 1.3.1.2 A Single Host and Simple Install The architecture for the Simple Install type is similar to that of the Enterprise Install type, with the differences that are outlined in the following list:.

The Node Manager is not installed. All components that are part of the Managed Server in an Enterprise Install type are instead part of the Administration Server. The Managed Server is not installed. Illustrates the Oracle Business Intelligence system architecture on a single host for a Simple Install type. 1.3.3.1 About Java Components Java components are deployed as one or more Java EE applications and are described in the following list:. Administrative Components — Oracle WebLogic Server Administration Console, Fusion Middleware Control, and JMX MBeans for managing all configuration and run-time settings for Oracle Business Intelligence. Oracle BI Publisher — This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.

Oracle BI for Microsoft Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products. Oracle BI Action Services — This component provides the dedicated Web services that are required by the Action Framework and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions. Oracle Real-Time Decisions (Oracle RTD) — This component provides enterprise analytics software solutions that enable companies to make better decisions in real time at key, high-value points in operational business processes. Oracle BI Security Services — This component provides dedicated Web services that enable the integration of the Oracle BI Server with the Oracle Fusion Middleware security platform. Oracle BI SOA Services — This component provides dedicated Web services for objects in the Oracle BI Presentation Catalog, to invoke analyses, agents, and conditions. These services make it easy to invoke Oracle Business Intelligence functionality from Business Process Execution Language (BPEL) processes. Oracle BI Presentation Services Plug-in — This component is a JEE application that routes HTTP and SOAP requests to Oracle BI Presentation Services.

1.3.3.2 About System Components System components are deployed as non-JEE components, such as processes and services written in C and J2SE, and are described in the following list:. Oracle BI Server — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with an.RPD extension). Oracle BI Presentation Services — This component provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework. Oracle BI Scheduler — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler.).

Oracle BI JavaHost — This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation. It also enables Oracle BI Server query access to Hyperion Financial Management and Oracle OLAP data sources. Oracle BI Cluster Controller — This component distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.

1.3.4 What Is the Administration Server? The Administration Server contains the administrative components that enable administration of a single or multinode (that is, distributed) BI domain, as described in the following list:. For Enterprise and Simple Install types, the Administration Server contains the following components:.

JMX MBeans — Java components that provide programmatic access for managing a BI domain. Fusion Middleware Control — An administrative user interface that is used to manage the BI domain. WebLogic Server Administration Console — An administrative user interface that provides advanced management for WebLogic, JEE components, and security. For Simple Install types, the Administration Server also contains the components that comprise the Managed Server in an Enterprise Install type, such as Action Services and Oracle BI Publisher.

Table 1-2 System Administration Tools for Oracle Business Intelligence Section Tool Purpose Fusion Middleware Control Monitor, manage, and configure system components for Oracle Business Intelligence. Oracle WebLogic Server Administration Console Monitor and manage JEE Java components for Oracle Business Intelligence. Oracle Process Manager and Notification Server (OPMN) Manage system components for Oracle Business Intelligence (for advanced users).

Oracle Weblogic Scripting Tool (WLST) Programmatically administer Oracle Business Intelligence. Oracle BI Administration Tool Manage the metadata repository for Oracle Business Intelligence. Job Manager Manage the Oracle BI Scheduler. 1.4.1 Fusion Middleware Control Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring Oracle Business Intelligence components. 1.4.2 Oracle WebLogic Server Administration Console Oracle WebLogic Server is a Java EE application server that supports the deployment of Oracle Business Intelligence Java components in a robust, secure, highly available, and scalable environment.

For more information, see Oracle WebLogic Server Administration Console enables you to monitor and manage a WebLogic Server domain. Its capabilities include the following:. Monitoring the health and performance of JEE servers. Configuring WebLogic server domains. Stopping and starting JEE servers.

Viewing JEE server logs. Managing user populations in the LDAP Server of the Oracle WebLogic Server For more information, see Oracle Technology Network at the following location:. Note: Fusion Middleware Control is the recommended approach for starting, stopping, and viewing the status of components. However, following a restart on Linux you must use the opmnctl start, or startall command. OPMN is suitable only for advanced users. OPMN provides the following functionality to manage the Oracle Business Intelligence system components:. A command-line interface for advanced users to control Oracle Fusion Middleware components.

For information, see. Automatic restart of processes when they become unresponsive or terminate unexpectedly. An integrated way to manage Oracle Fusion Middleware components. 1.4.4 Oracle Weblogic Scripting Tool (WLST) The Oracle Weblogic Scripting Tool (WLST) is a command-line scripting environment (for advanced administrator use), which enables you to programmatically administer Oracle Business Intelligence.

The WLST scripting environment is based on the Java scripting interpreter Jython. You can use this tool interactively on the command line, in batch scripts that are supplied in a file (Script Mode, where scripts invoke a sequence of WLST commands without requiring your input), or embedded in Java code. You can extend the WebLogic scripting language by following the Jython language syntax.

Oracle Bi Administration Tool Download

For more information, see:. Table 1-3 Topics Covered in Other Guides Topic Where to Go for More Information Third-party tools and relational data source adapters Configuration tasks for Oracle BI Scheduler Configuring data sources Security, including configuring SSO and SSL Installing and upgrading Configuring comments and status overrides in Oracle Scorecard and Strategy Management Converting Oracle Business Intelligence proprietary metadata to an XML file and importing the metadata into your Oracle or IBM DB2 database Propagating UI hints (labels and tooltips) from an ADF data source to display in Oracle BI Answers. 1.8 System Requirements and Certification Refer to the system requirements and certification documentation for information about hardware and software requirements, platforms, databases, and other information. Both of these documents are available on Oracle Technology Network (OTN).

Serial stories lady swings. The system requirements document covers information such as hardware and software requirements, minimum disk space and memory requirements, and required system libraries, packages, or patches: The certification document covers supported installation types, platforms, operating systems, databases, JDKs, and third-party products: Scripting on this page enhances content navigation, but does not change the content in any way.

IMHO A little incorrect agregation example on F2 Revenue Aggregate. The table granularity is PRODUCT, QUARTER, When you map only measure columns (Units, Revenue) to F1 Revenue and set all Aggregate Content to total except the H1 Time (Quarter) you get the DISTINCT Sql as you correct pointed in "Inspect the log. Notice that the query uses the expected tables: D1 Time Quarter Grain and F2 Revenue Aggregate" The mistake is that it's possible to have in the aggregate table different records with the same quarter and revenue but containing the different products and the result is incorrect in this case (but for the year level it's OK anyway as the SUM is used).