OBIEE Repository Creation Utility (RCU)

Here’s the Oracle Guide to RCU with Screen Prints.

http://docs.oracle.com/cd/E23943_01/doc.1111/e14259/rcu_screens.htm

 

Advertisements

How to check version of OBIEE 10g and 11g

Check the version of OBIEE 10g

In the directory: OracleBI/version.txt

Build: 10.1.3.4.1.corda
Release Version: Oracle Business Intelligence 10.1.3.4.1 QF 495
Package: corda
BLR: 9862160

Check the version of OBIEE 11g

In the directory <FMW_HOME>\Oracle_BI1\bifoundation\version.txt

Build: 11.1.1.6.0.BIFNDN_11.1.1.6.2BP1_LINUX.X64_120605.2000
Release Version: Oracle Business Intelligence 11.1.1.6.0
Package: 120605.0926.000

for example, in “C:\OBIEE11G\Oracle_BI1\bifoundation\ version.txt”. You can find the current patch level from the Answers & Dashboards home page by selecting the menu item “Help”, followed by “About Oracle BI EE”.

OBIEE 10g Installation

Oracle Business Intelligence Suite Enterprise Edition includes the following key components:

  • Oracle Business Intelligence Server
  • Oracle Business Intelligence Dashboard
  • Oracle Business Intelligence Answers (ad hoc query and analysis)
  • Oracle Business Intelligence Delivers (proactive detection and alerts)
  • Oracle Business Intelligence Publisher
  • Oracle Business Intelligence Disconnected Analytics
  • Oracle Business Intelligence Server Administrator

Example for UNIX Systems
You specified /usr/local as the installation directory:
■ OracleBI_HOME is /usr/local/OracleBI
■ OracleBIData_HOME is /usr/local/OracleBIData

NOTE: The definition of this and other environment variables required for an Oracle BI installation
are located in the file sa-init.sh under UNIX systems. The Oracle BI setup script sets environment
variable definitions in this shell script. Do not edit or delete this file.

Related book titles for the Oracle Business Intelligence Enterprise Edition suite:
■ Oracle Business Intelligence Server Administration Guide
■ Oracle Business Intelligence Presentation Services Administration Guide
■ Oracle Business Intelligence Scheduler Guide
■ Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide
■ Oracle Business Intelligence Enterprise Edition Deployment Guide

OBIEE 11g Components

OBIEE Components

OLTP DATABASE => ETL  => OLAP DATABASE => OBIEE

In OBIEE

RPD =>  BI server  => Presentation Server =>  Reports/Dashboards

Components of OBIEE :

OBIEE can be divided into 3 parts

  1. Repository or Administration Tools
  2. Reports / Dashboards
  3. iBOTS (10g) or Agents (11g) / Delivers

OBIEE has two types of components

  1. Server Component
    1. Oracle BI Server
    2. BI Scheduler
    3. BI Presentation  Server
    4. BI JAVA Host
    5. Cluster Controller

 

  1. JAVA Components
    1. Admin Server
      1. WLS Admin Console
      2. Fusion Middleware Control (EM)
      3. JMX Beans
    2. Managed Server
      1. Action Service
      2. BI Office
      3. RTD
      4. BI Publisher
      5. Web Services SOA
      6. BI Plugin
      7. Security

 

Oracle BI Server: It is a core engine acts as a heart of entire OBIEE software which performs following operations. It controls/coordinates all reporting/repository building operations by communicating/coordinating with other server components. It takes the logical SQL requests from Presentation server and generates the optimized queries against the report request. These queries are send to physical database for execution. It manages cache to redirect queries to cache /purge cache ..etc. It is also responsible for security implementation, online repository building, Multi user development..etc. following are the other components which BI server controls/coordinates.

 

Repository: Repository is a meta data of physical data warehouse structures which were converted to Logical dimensional structures. Presentation Layer of the repository contains the objects which needed to exposed to users for report generation. This repository stores in a file with extension .rpd.

NQSConfig:         This file is  key configuration file from where OBIEE server reads the initial parameters information before it starts. It is by default located at \OracleBI\server\Config (for 10g) and  \Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository(for 11g). In 11g you can change the repository using EM

 

Log files: All the log files are placed by default at x:\OracleBI\server\Log(For 10g) and in 11g you can directly find them from EM

I

NQCluster: Logs OBIEE clustering information if it is configured as cluster.

NQQuery:   Records all the step by step process of each and every report/query activity in OBIEE. We can see all physical and logical queries in this log.

Physical Query: OBIEE server will convert logical queries to database specific physical queries which can be executed on DW database. Logical queries are converted to physical queries based on logical/physical model metadata definitions in repository file.

A repository is a collection of data definitions. Or data about data (Metadata).

Cache: Caching is a process of storing the Info on separate layer after fetching data from physical warehouse. This helps to reuse the Information which is frequently going queried by users without hitting the database for every request.

 

Presentation Server:

Presentation service is a Single application that provides Oracle BI Answers, Dashboards, delivers etc via web browsers.

·        Take the request form the client tools and pars the request to OBIEE server.

·        Since presentation services are service components, in order to work on presentation services it requires a application server.

Application Server:

Application Server is the server which provides the 3-tier Architecture features and helps to work on web based client components and by default oracle provides oc4j(10g) application server along with OBIEE s/w. These can be changed in case organization wants to go with diff app. Servers like IIs or web sphere. OBIEE provides a default application server by name OC4J. In the real production servers we can replace this by any other

OBIEE 11g uses weblogic server

OBI Scheduler:

Is a server component helps to schedule a job. To install and configure BI Scheduler requires a relational repository. We need to create an empty user and configure to BI scheduler. While creating repository OBIEE will create required tables in this user. It stores all schedule related information. For running iBots this components is mandatory. The jobs which are schedule by BI Scheduler can be monitored by job manager.
iBots are known as Agents in 11g

Non web based client components :

OBIEE Administration tool is used to  build a repositories (metadata model) on top of physical data ware house It contains three layers.

·        Physical layer

·        Business layer

Presentation This helps to easily navigate unix folder structures via graphical interface.

ODBC Client: allows to connect to a database and execute SQL commands. Mostly BIEE testers will use this tool to test the repository/reports.

Browser based Clients : These tools will wok only on any internet browser. Following the tool.

1.     Interactive Dashboards : Dashboard is a logical container of components developed by OBIEE like answers, other web pages, other dashboards. This provides additional features like prompts, guided navigation etc.

2.   Answers : Oracle BI Answers also called as reports provides a highly Interactive user interfaces to generate reports/analytics with complex calculations and multiple views and filters etc.s

3.   Oracle Delivers : Create proactive alerts with the help of a engine called iBots. It  also helps to deliver the contents in various formats to different. Destinations.

4.   Disconnected Analytics : Simulated online working environment even though not connected to data ware housing.

5.   MS_Office Plugin : Integrates the OBIEE generated data with all MS_Office product which can further analyzed on local desktop Office products.

6.   BI presentation Service Administration : Client component helps to admin the activities which are being in progress within presentation services.

7.   BI Publisher : OBI publisher which was knows as XML publisher allows to create reports based on the layouts created in MS word or Excel. The report output can be published/bursted to various media and various people.

 

OBIEE 11g Configuration and Log Files Location and Scripts Location

BI Configuration Files

1. NQSConfig.INI and logconfig.xml

\OBI11G\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1

2. instanceconfig.xml

\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

3. ClusterConfig.xml
ccslogging.xml

\instances\instance1\config\OracleBIApplication\coreapplication

4. instanceconfig.xml (Second instanceconfig.xml dedicated file for BI Scheduler)
\instances\instance1\config\OracleBISchedulerComponent\coreapplication_obisch1

5. config.xml and logging_config.xml
\instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1

6. bridgeconfig.properties (For BI Persentation services Plug-in)

\OBI11G\user_projects\domains\bifoundation_domain\config\fmwconfig\biinstances\coreapplication

7. opmn.xml (OPMN Config file)
/OBI11G/instance/instance1/config/OPMN/opmn/opmn.xml
(It contains the PATH and LD_LIBRARY_PATH values for the system components and the port number for OPMN and optional SSL configuration.)

8. boot.properties
/OBI11G/user_projects/domains/bifoundation_domain/servers/[managed_server]/security

Script Files
1. startNodeManager.sh
(Must be started to allow Managed Server to be started from Weblogic console)
/OBI11G/wlserver_10.3/server/bin/startNodeManager.sh

2. opmnctl(Command line tool to start BI services)
/OBI11G/instance/instance1/bin
— OPMN can be used to automatically start BI on linux system. To do that following commands must be included in opmn startup script:

/OBI11G/instance/instance1/bin ./opmnctl startall

3. startWebLogic.sh(Script to start Weblogic server)
/OBI11G/user_projects/domains/bifoundation_domain/bin.

./startManagedWebLogic.sh
/OBI11G/user_projects/domains/bifoundation_domain/bin
To start Managed Server – But this typically can be started from Webogic Console after weblogic server is in running mode.

./startManagedWebLogic.sh bi_server1 http://administration_server_host_name:7001

Log Files:

1. Admin Server (Or weblogic server issues)
\user_projects\domains\bifoundation_domain\servers\AdminServer\logs

2. Managed Server
\user_projects\domains\bifoundation_domain\servers\bi_server1\logs\

3. BI Server
\OBI11G\instance\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

4. BI Persentation Server:
\OBI11G\instance\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

OBIEE Comparison between 10g and 11g features

OBIEE Comparison between 10g and 11g features

Apart from major architectural differences, OBIEE 11g has several new features that were not available in 10g.

Some of the key features include:

  • Supports creating hierarchy objects in Subject Area
  • Export to xml or export to tab delimited/ and power point
  • 11g lets variable have multiple values
  • 11g RPD cannot be without a password
  • 11g supports ragged hierarchies
  • Column selector in 11g can be defined on multiple columns, compared to just one column in 10g.

Key Terminology Changes

In 11g, the following terminology changes have been made:

  • iBots have been renamed to agents (also known as intelligent agents)
  • Requests (or reports) have been renamed to analyses, and the term reports now refers to BI Publisher reports
  • Presentation columns have been renamed to attribute columns, and a new column type, hierarchical column, is introduced
  • Charts have been renamed to graphs
  • Security terminology and architecture has changed.

The user interface has undergone major improvements in several areas, including a new Home page and redesigned editors and panes.

  • You can use a “selection step” to limit data for columns by specifying the criteria for a set of members
  • Drill in data (expanding a member, without impacting rest of the report)
  • Sorting in 11g is now enabled by default. Sorts can be applied to members, measures, and rows in views such as tables, pivot tables, graphs, and maps
  • In a pivot table, you can easily drag and drop columns to various edges, to rearrange the display to suit your needs
  • Graphs and gauges come with new feature of section sliders.
  • Map view is a new view type that presents data in spatial form
  • We can also create master-detail relationships among certain view types
  • We can create calculated items to perform mathematical operations on members. In 10g, we could create a calculated item for an attribute column. In 11g, we can create a calculated item for the members of an attribute column or of a hierarchical column
  • 11g allows us to work with multiple subject areas in same report. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include additional subject areas that are related to the primary subject area with which to work

Interaction with Other Oracle Products

  • Oracle BI Publisher is a fully integrated member of the Oracle BI EE 11g by default. All of the BI Publisher functionality appears seamlessly within the Oracle BI EE application, and all of the reports and related objects are created within Oracle BI EE and saved to the Oracle BI Presentation Catalog
  • Oracle Hyperion Smart View is available for download from the Oracle BI EE Home page
  • Interface with MS Office is enhanced, including an additional functionality to download to CSV. In 10g, there was an option to download data, but it was only ‘Tab delimited’, not Comma seperated.

SQL Functions for Time Series Calculations and Level-Based Measures

The following new and revised SQL functions enable you to create time series calculations and level-based measures:

  • PERIODROLLING is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time.
  • AGGREGATE AT is a new function that aggregates columns based on the level or levels specified.
  • AGO is a time series aggregation function that calculates the aggregated value from the current time back to a specified time period. In this release, the time_level argument is optional, and there are additional syntax changes. This function was called PERIODAGO in the previous release.
  • TODATE is a time series aggregation function that aggregates a measure attribute from the beginning of a specified time period to the currently displayed time. The syntax for this function has changed in this release. This function was called PERIODTODATE in the previous release.

Enhanced database function usage capability

OBIEE 11g allows calling EVALUATE, EVALUATE_AGGR, and EVALUATE_PREDICATE function for advanced calculations.

Enhancements to the Oracle BI Presentation Catalog

The Oracle BI Presentation Catalog is a powerful, underlying storage directory-based system that contains the objects (dashboards, scorecards, prompts, and KPIs for example) that you create. If you use BI Publisher, then the catalog also contains BI Publisher data and objects (data models and schedules, for example). Using the catalog, you can:

  • Perform basic tasks such as creating, deleting, and copying objects and folders.
  • Perform object-specific tasks (for example, modifying settings using the associated editor, or creating and assigning an agent).
  • Find objects by performing a search.

In addition to these tasks, administrators can:

  • Access the root folder that contains system-wide object and user data.
  • Specify permissions that determine the folders and objects that users can view.
  • Create folders.
  • Work with properties such as changing the ownership of a folder or viewing the creation date of an object.
  • Archive the entire catalog, folders, or objects to unzip them in another directory location.

Actions

You can create actions that navigate to related content or that invoke operations, functions, or processes in external systems. You can include actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives, and KPIs

Top level location for installation

Top level location for installation

OBIEE Oracle Home :OBIEE11g\Oracle_BI1
Contains core Oracle OBIEE components and template files used by the configuration phase of the install process
Common Oracle Home: OBIEE11g\Oracle_Common
Contains general Oracle files
WebLogic Server: OBIEE11g\wlserver_10.3
Contains the Oracle WebLogic Server OBIEE binaries

OBIEE WebLogic Domain: OBIEE11g\user_projects\domains\OBIEEfoundation_domain
Contains the WebLogic Admin and Managed Servers that host the Oracle J2EE components
Instance Home: OBIEE11g\instances\instance1
Contains sub directories that hold the Oracle OBIEE system components, OPMN control, configuration files (e.g. NQSConfig.INI and instanceconfig.xml), RPD, Webcat and diagnostic logfiles. In this case, the name of the instance is ‘instance1’