how to install oracle sample V309r2

how to check if database insntance is open ?

SQL> select status from v$instance;

 STATUS
------------------
OPEN

how to install obiee 11g on windows xp

For Installing RCU use below link

https://sites.google.com/site/oraclebusinessintelligence11g/creating-metadata-repository-using-oracle-repository-creation-utility

For installing loopback adapter use below link

https://sites.google.com/site/oraclebusinessintelligence11g/installing-a-loopback-adapter-on-windows-xp

For installing obiee 11g Refer below link

https://sites.google.com/site/oraclebusinessintelligence11g/install-obiee-11g-on-windows-xp

How to replace nulls in pivot table ?

Use below link

http://total-bi.com/2010/10/replace-nulls-in-obiee-pivot-table/

Learning OBIEE external table security

a very nice write up by kumar ,

https://obieeblog.wordpress.com/tag/obiee-authentication/

Must read.!

Oracle BI Server

Oracle BI Server

Oracle BI Server is the core server behind Oracle Business Intelligence. It is an optimized query

engine that receives analytical requests, intelligently accesses multiple physical data sources,

generates SQL to query data in the data sources, and then structures the results to satisfy the requests.

It also handles requests from a variety of front ends, including Oracle BI applications as well as

third-party tools. Oracle BI Server allows a single information request to query multiple data sources,

providing information access to members of the enterprise and, in Web-based applications, to

suppliers, customers, prospects, or any authorized user with Web access.

Oracle BI Server serves as a portal to structured data that resides in one or more data sources:

multiple data marts, the Oracle BI Data Warehouse, an enterprise data warehouse, an operational

data store, transaction system databases, personal databases, and so on. Transparent to both end users

and query tools, Oracle BI Server functions as the integrating component of a complex decision

support system by acting as a layer of abstraction and unification over the underlying databases. This

offers users a simplified query environment in which they can ask business questions that span

information sources across the enterprise and beyond.

Oracle BI Server runs as a service in the Windows environment on your classroom machine

How to Enable Session Timeout In OBIEE 10g

For this we need to make changes to instanceconfig.xml file.

Add the below entry to the file where time in minutes needs to be mentioned.

<ConnectionExpireMinutes>1</ConnectionExpireMinutes>
<ClientSessionExpireMinutes>1</ClientSessionExpireMinutes>
<LogOnExpireMinutes>1</LogOnExpireMinutes>

This needs to be added above the serverinstance tag in the instanceconfig.xml file

</ServerInstance>
</WebConfig>

Best Sites for Learning Oracle BI

http://obinsight.blogspot.in/2012/04/collection-of-blogs-and-sites-for-obiee.html

http://bischool.wordpress.com/

http://total-bi.com/