Category Archives: Uncategorized

OBIEE New & Deprecated Terminology and architecture – 12.2.1.0.0 (12c)

Standard

Dear all,

from oracle documentation, here is high level architecture diagram for OBIEE 12c – 12.2.1.0 and terminology difference between 11g & 12c

obiee12c_logical_architecture

Terminology difference.

Terminology Used in 11g Terminology Used in 12c
Middleware home

MW_HOME

In 11g the Middleware home is a container for the Oracle WebLogic Server home, and, optionally, one Oracle Common home and one or more Oracle homes.

This term is eliminated in 12c.

Oracle home

ORACLE_HOME

The Oracle home that is created for all the Oracle Fusion Middleware products on a host computer. It includes binary and library files, the Oracle common directory and the individual product directories for each Oracle Fusion Middleware product you install.

Oracle home

PRODUCT_ORACLE_HOME

Product directory

PRODUCT_DIR

The product directories within the Middleware home are no longer Oracle homes. They are simply directories within the Oracle home that are created for all the Oracle Fusion Middleware products. Most Oracle Fusion Middleware components should be installed in the same Oracle home. The names of the product homes are predefined and can no longer be modified by the user during the installation.

Oracle instance

This term is eliminated in 12c.

The installer will no longer create a separate instance directory for system components, such as Oracle HTTP Server. Instead, you can use the Fusion Middleware Configuration Wizard to configure your system components, just as you do for Java components. Instance information about each system component will be stored in the domain home.
Oracle Fusion Middleware farm

This term is eliminated in 12c.

The term “farm” is no longer necessary for 12c. It was used in 11g to refer to a container for a WLS domain and its associated system component instances when presented in Fusion Middleware Control.

Ref: https://docs.oracle.com/middleware/1212/core/ASCON/whatsnew.htm#ASCON11224

 

Thanks,

Kishore

OBIEE 12c Installation on windows 8

Standard

Hi,

 

obiee 12c (12.2.1.0) installation is success in my windows 8 version (note it is not oracle recommended but for practice purpose i tried and able to install)

Generalizing the process of installation …

Prerequisites:

  1. 64 bit OS is must
  2. Loopback adapter settings..
  3. Make sure you unzip the downloaded setup files in the same machine where you’re intended to install obiee. I saw few issues when extracted file is brought from 2008 r2 to win8.
  4. Decide user with whom you’re proceeding with installations and ensure oraInventory access.
  5. Windows firewall set to Off
  6. JDK 1.8.0_51+
  7. oracle database; 12.1.0.1+; 11.2.0.4+

For more information on certification matrix on oracle fusion middleware 12.2.1.0 certification, click here

Installation Steps:

  • Install Oracle Fusion Middleware Infrastructure (no configuring domain for infrastructure)
  • Install obiee
  • Set BI_PRODUCT_HOME env variable for ex: C:\oracle\product\Middleware\Oracle_Home\bi
  • Configure obiee standard topology using 12c configuration assistant(you can alternatively run rcu part of <ORACLE_HOME>/oracle_common/bin to create schema required then sue configuration assistant to configure obiee)

Follow oracle documentation on installation & configuration here

i could not install obiee 12c (12.2.1.0) on windows 2008 r2 and the same success with windows 8

Note: Oracle certifies only 2012 r2 for obiee 12c

 

Thanks,

Kishore

Complex Joins in OBIEE 11g

Standard

Hi All,

 

Like 10g, we do not have available option to create Complex Joins from Toolbar. Can only create “Foreign Key” Joins.

But we can create complex joins using Join Manager. (This option not available from tool bar)

 

Go to Manage > Joins > Actions > New > Complex Join.

Browser the physical tables on which you want to perform joins then create complex join. 

As you might know complex joins will be used when we have to mention case when condition, or condition..etc in our jion 

 

 

Thanks,

Kishore

Windows Can’t find directory path while installing rcu to install OBIEE 11g

Standard

Directories that rcu file storing shouldn’t contain spaces in it.

 

Here is the path that i stored rcu installer.

E:\kishore\Softwares\OBIEE 11.1.1.5\rcuHome\BIN

There is space in OBIEE 11.1.1.5 between OBIEE & number.

 

There is oracle note that there shouldn’t be any spaces in directories that containing rcu installer.

Remedy: Remove space in directory then try run rcu.bat

 

 

Thanks,

Kishore Guggilla

 

11g: Connection pool is not available in initialization block

Standard

Hi,

 

Today i had issue that: Connection Pools are not being shown in browse list of initialization block.

 

I’ve imported some sources to rpd and trying to create session initialization block which will use the new imported schema to query. Unfortunately i’m unable to see the connection pool list that these new imported db is holding.

 

But it’s visible in Repository initialization block.

 

Anyways, this is happening because, by default the first connection pool specific to each db will not be shown in browse list.

 

Here is note from help document:

By default, the first connection pool under the database object in the Physical layer is not available for selection. This behavior ensures that you cannot use the same connection pool for initialization blocks that you use for queries.

So make sure that every time you import new connection, you’ve duplicated connection pool dedicated to use in initialization block.

 

Thanks

Kishore Guggilla

Show/Pass Request Variable (Session) in section heading

Standard

Hi,

Hope all of you know how to define/use Request variable from Dashboard prompt…

Recently i found one question on OTN.

Requirement is: Show/Pass selected value from drop-down in Dashboard Section heading..

This is quiet easy if prompt is defined with presentation variable, but problem here is: prompt is defined with Request Variable.

Problem with Request Variable is:

Usually, Request variable is session variable defined in rpd and will be override with selected prompt value in front end. Real problem here is: regardless of selected value from the dashboard prompt, it always shows the default value of session variable initialized while creating the variable…

And, this is the way we pass session variable in Section Heading..

@{biServer.variables[‘NQ_SESSION.var_PVar’]}

Work Around is:

I assume Request variable is: var_PVar.

Here are the steps involved to achieve it.

1. Create another prompt with same functionality of main prompt

2. But, this time assign a presentation variable to the prompt, say: var_P.

Note: This prompt should be added to separate Section in Edit Dashboard..

3. Now, call presentation variable directly into Section Heading as shown..

4. Now, hide newly created prompt. Here is the way to hide the prompt..

Hope it’s clear.. 🙂

Regards,

Kishore Guggilla.