Download & Deploy - OBIEE 11g Samplesales

Hi All,
Here I am sharing the OBIEE 11g (in 11.1.1.6.0) upgraded samplesales application.
Download the '11g Sample Sales.rar' from the Google Document Link. 
Please Refer the below screen to download the files:

I have upgraded the 10g samplesales application using Upgrade Assistant (ua.bat) and sharing the same to you to deploy the samplesales in 11g.
My weblogic Repository password is 'Admin123'
User Name:       Administrator
User Password: Administrator
Login with presentation services using Administrator User Name to access the dashboard with full privileges (Edit, View, Analyze and etc.,).


This zip file contains three folders
1. Repository
2. Catalog
3. Data


After downloaded the file, unzip it and  copy the repository, catalog and xml fiels files to corresponding repository, catalog and data path.


Copy the 'server' folder from downloaded zipfiles/Data folder and copy into the below path:
Drive<MiddlewareHome>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obips1


If you want to know how to deploy catalog and repository in OBIEE 11g, Refer here


Happy Blogging,
Bose

OBIEE 11g: Deploy/Undeploy View in Physical Layer

Same like OBIEE 10G we can create opaque view in OBIEE 11G also. Here is screenshot and steps how to create opaque view in OBIEE 11G. If you want to know how to create view in OBIEE 10G click here Opaque view in OBIEE 10G

The steps are almost same like OBIEE 1OG. So giving the screenshot by stepwise. What is basically happening behind Deploy and Undeploy is, if we are deploying the view created in physical layer, it will create the view in the database. We could go and check the view in DB. Undeploying the same will drop the view from DB and just keep the definition in physical layer.

Deploying View:

Here I want to create a view on employee table which need to be show only Indian Employee. So I am restricting the table here itself by creating view.

Right click on Employee Table and select Properties or Double click on the table to see the properties window.

From properties windows select  Table Type:Select and write the query in the 'Default Initialization String'. After that click 'OK'.

Now save the repository

If we are looking at the employee table now It will display with different icon. Right click on the table and click 'Deploy View(s)'. Click Check out if it asked for.

Click 'OK' with the below window

 Now the view is deployed in the physical layer. Click 'Close' with the below window

Now if we are updating the row count of the table it will be shown only the result of our SQL Query.

UnDeploying View:

If we are not in the need of view which we deployed, we can undeploy the view by the straight opposite process of deploying view.

Right click on view and click 'Undeploy View(s)'

In the next screen just click 'OK'. The view will be undeployed  and will get below window. Click 'Close' with the below screen.

Note:

After you undeployed the view check the table name whether the table name is matching with source table name. If it is not then rename the table with the same name of source table name.

Cheers!

Bose

Error 'One or more entries are found in HSS_COMPONENT table'

This post title is an error we are getting when are trying to install BI 11g system. How to resolve this error and can continue my Installation???

Reason:

When we are running RCU It will create two schemas called BIPLATFORM, MDS. This schemas are having all the necessary tables to run BI 11G system. So whenever we are installing BI 11g system It will make an entry in the HSS_COMPONENT table in BIPLATFORM Schema. 

But for any reasons you have uninstalled BI 11g system and trying to install again in the same machine with the same RCU schema which we already installed then we are getting this error.

Assumption:

There are number of assumptions I am getting from various links and site. In all the links I have referred are saying to delete RCU schemas and its related tablespaces from oracle database system and are telling to install it again.

Solution:

But there is no need to delete/uninstall RCU schemas. We can continue BI 11G installation again with the same schema which we have already installed.

Here is workaround:

Login into SQLPLUS and connect BIPLATFORM Schema with the same credentials which we have given when we installed.

syntax: conn BIPLATFORM/password@connectionstring

SQL> conn DEV_BIPLATFORM/Admin123@orcl

once we connected with BIPLATFORM Schema delete the entry which is available in the HSS_COMPONENT table and commit the table.

SQL> DELETE FROM HSS_COMPONENT;
One entry deleted

SQL> COMMIT;
Commit Complete;

Now start the installation and give the BIPLATFORM AND MDS schema details in its related steps. The error will no more exist.

Note:

Do not forget to 'COMMIT' once we deleted the entry from HSS_COMPONENT table. because 'DELETE' command will not be updated without commit.

Happy Blogging,

Bose