OBIEE Architecture

OBIEE  Architecture

1)A Request is made by the users through answer and send it into Presentation server.
2)Presentation server convert request into Logical SQL and send it to Oracle BI Server.
3)Oracle BI Server  Convert Logical to Physical SQL and send it to database.
4)Now result get back to you.

Thanks

OBIEE Directory Structure

OBIEE Directory Structure

difference between obiee 10g and 11g

Some important points/enhancements in OBIEE 11g when compared to OBIEE 10g are listed below

1. OBIEE 11g uses WebLogic Server as the application server as compared to Oracle AS or OC4J in OBIEE 10g.
2. The clustering process in much easier and automated in OBIEE 11g.
3. We can now model lookup tables in the repository.
4. The new UI called Unified Framework now combines Answers, Dashboards, and Delivers.
5. A new column called the hierarchical column in introduced.
6. BI Publishers is fully and seamlessly integrated with OBIEE 11g.
7. New time series functions PERIOD ROLLING and AGGREGATE AT are introduced.
8. In OBIEE 11g we can create KPIs to represent business metrics.
9. The aggregate persistence wizard creates indexes automatically.
10. The session variables get initialized when they are actually used in OBIEE 11g unlike OBIEE 10g where they were initialized as soon as a user logs in.
11. OBIEE 11g now supports Ragged (Unbalanced) and Skipped Hierarchy.
12. You can also define Parent-Child hierarchy in OBIEE 11g as well.
13. SELECT_PHYSICAL command is supported in OBIEE 11g.

In OBIEE 11g there are some changes in the terminology as well.

• iBots are renamed as Agents.
• Requests are renamed as Analyses.
• Charts are renamed as Graphs.
• Presentation Columns are renamed as Attribute Columns.

Managed Weblogic Server

A domain is the basic administration unit for WebLogic Server instances. A domain consists of one or more WebLogic Server instances (and their associated resources such as JDBC resource or JMS resource) that can be managed with a single Administration Server.

A minimal domain can contain only one WebLogic Server instance, which functions both as an Administration Server, and as a Managed server. This instance is called as Weblogic Administration Server or Weblogic Admin Sever.

As it is the only instance present in domain so this Weblogic Admin Server can also be used as Managed Weblogic Server.

WEBLOGIC ADMIN SERVER OR WEBLOGIC ADMINISTRATION SERVER:

The minimum requirement for a Weblogic Domain to exist is that it must contain one Administration Server. This Weblogic Server Instance is basically used for the Administrative purpose of complete Weblogic domain.

This Admin Server can also be used for the purpose of deployment of applications along with Administrative purpose and in that case the Admin Server is acting as Managed Weblogic Server instance.

MANAGED WEBLOGIC SERVER:

Any other server instance other than Administrative Server of a Weblogic domain is called as Managed Weblogic Server. Managed Servers host the components and associated resources that constitute the applications—for example, JSPs and EJBs.

Node Manager ?

Node Manager

Oracle Business Intelligence runs within Oracle WebLogic Server, and therefore Oracle WebLogic Administration Server must be started before Oracle Business Intelligence components can be started and maintained.

To start the Oracle Business Intelligence system, you start:

• the Node Manager(It is by default windows service in Enterprise Installation of OBIEE 11G)
• the Administration Server (It is weblogic Admin Server)
• the Managed Servers(Comes with Enterprise Installation of OBIEE 11G)
• and then you start the system components.(All OBIEE Components : BI Server,Presentation Server,Schedular,Java Host,Cluster Services.

Steps involved to start Weblogic node manager and OBIEE11g is as follows.

In order to start all the services your Oracle database need to be up and running.

Start Weblogic Node Manager

run the below tag in command prompt.

ORACLE_BIEE_HOME/wlserver_10.3/server/bin/startNodeManager.cmd

Steps to Manually Start Oracle BIEE 11g

Run the following commands in command prompt
1. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startWebLogic.cmd

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.cmdbi_server1

3. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl startall

Steps to Manually Stop Oracle BIEE 11g

Run the following commands in command prompt
1. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl shutdown

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.cmdbi_server1

3.ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.cmd

Excel as a Source in informatica 9.0.1

Excel as a  Source in informatica 9.0.1

Go to below link --

http://www.dwbiconcepts.com/etl/14-etl-informatica/53-informatica-excel-source.html

Importing Flat Files with Newline Characters in Informatica

Importing Flat Files with Newline Characters in Informatica:-

We were given multiple comma-delimited csv files with several fields utilizing a double quote text qualifier.
Normally this would not be an issue; however inside the double quotes were newline characters. Below is an example of the issue

“C,2010-05-25 18:47:36,3:9,0,db_id:11111
U,2010-05-25 18:47:53,3:9,0,db_id:11111,date_approved,0000-00-00,
date_submitted,0000-00-00
U,2010-05-26 20:37:17,3:9,0,db_id:11111,date_submitted,0000-00-00,
approval_status,’O’,date_approved,0000-00-00?

or
U,2010-05-25 18:47:53,3:9,0,db_id:11111,date_approved,0000-00-00


-00",test

NOTE:-I found two viable solutions to this issue, one of which is impractical.
1) The first approach was to open the csv files in Notepad and manually remove
the newline characters. but this is an time consuming process or 1 or 2 small file.

2) I have a better solution for that  adding a new entry to the Custom Properties field in the session configuration.

Goto-> session confi -> Custom Properties-> and  write here attribute

‘MatchQuotesPastEndOfLine’ and set the value to ‘Yes’.

or
MatchQuotesPastEndOfLine=Yes;

‘MatchQuotesPastEndOfLine=Yes';’