sql/plsql tutorial

http://sql-plsql.blogspot.in/2007/03/sql-syntax.html

OBIEE 11G RCU INSTALLATION

OBIEE 11g RCU Install

Weblogic is a Java EE Platform that can be scaled allowing close management of where and how components are run.  But the configuration necessary must be stored somewhere and that is where the RCU (Repository Creation Utility) comes in.
This article will take you through the installation and configuration steps of the RCU in reference to supporting the BI Platform component.  In this example we were installing on an Oracle Express (XE) database.  During installation an error is thrown informing us that the RCU is not compatible with this database; this is the case with some components, but not with BI Platform - this error is not relevant.  However, if you aim to install OBIA 7.9.6.3 using the same database you should be aware that features required by the warehouse schema are not supported and this should be hosted on an Oracle 11g Enterprise Edition database.
Part 1: Installation

Part II: Configuration
Navigate to the folder C:\RCU\bin and run the batch file RCU.bat.  The welcome screen below will be shown.  Click Next


We can choose to Create or to Drop a schema; we want to create a schema, the default; click Next.



Enter the database details and click Next.  For an Oracle DB you must use the SYS aacount.



4



5



6



7



8



9



10



11



12



13

Creating an ODI Project and Procedure to Create and Populate a Relational Table

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/10g/10135/odiprocedure_create_populate_table/odiprocedure_create_populate_table.htm

event pooling table in obiee11g

http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/querycaching.htm#i1005542

How to find image path form obiee11g dashboard

fmap is generaaly mapped to \Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\images also \Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\images \Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1291264099332\analytics.ear\ukjjdc\res\s_blafp\images

How to deploy RPD and catalog without Enterprise manger

How to deploy RPD and catalog without Enterprise manger

Many times the obiee service goes off because of deployment of inconsistent RPD and to make the services up we need to deploy the previous RPD.

To achieve this we change the name of RPD and Catalog in NQSConfig.ini and Instanvceconfig.xml file respectively just similar to obiee 10g RPD and catalog deployment method. But in obiee11g if we change in NQSConfig.ini and Instanceconfig.xml file and restarted the services the obiee 11g revert back the changes whatever we did manually.


Actually there is Central configuration enable by default in obiee11g which allows us to update the configuration with interface. So to disable the central configuration and deploy the RPD and catalog with obiee10g fashion follow the following steps

1) Edit the biee-doamin.xml file from location ORACLE_HOME\user_projects\domains\bifoundation_domain\config\fmwconfig and edit the “centralConfigurationEnabled” tag as shown below

2) Change the RPD name in of RPD in NQSConfig.ini file .The NQSConfig.ini file is located at ORACLE_HOME\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1

3) Change the catalog detail in instanceconfig.xml file.File is located at location at ORACLE_HOME\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

4) Restart all services, now you can see the changes whatever we did in NQSConfid.ini and instanceconfig.xml file are as per our requirement now.

OBIEE 11.1.1.6 - Dashboard prompt show "Null" value in drop-down list

OBIEE 11.1.1.6 - Dashboard prompt show "Null" value in drop-down list

In the dashboard prompt, "NULL" value was added as a choice in every prompt after applying the patch OBIEE 11.1.1.6.

In the above example, to filter the NULL value in prompt

1) Edit the prompt definition for this column, select 'SQL Results' from 'Choice List Values' selection.

2) Add the condition WHERE IS NOT IN ('(Null)') to your SQL statement and click OK to preview the result. This will display all non-null values in the prompt drop-down as below.