ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 337,412 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for September, 2011

OBIEE 10g Nested Presentation Tables

Posted by Santosh Kumar Gidadmani on September 11, 2011

To give the appearance of nested folders in Oracle BI Answers, create the presentation folders in order.

You can nest presentation folders in two ways.

1) You can enter a hyphen and a greater than sign in the description field of the table to achieve the result.

2) Or, prefix the name of the presentation folder to be nested with a hyphen and a space and place it after the folder in which it nests to achieve the same result as shown below.

Result

– Santosh

Advertisements

Posted in Nested Presentation Tables, OBIEE 10g, OBIEE 10g Answers, OBIEE 10g Dashboard | 2 Comments »

OBIEE 10g Merge two different RPDs and Web Catalogs.

Posted by Santosh Kumar Gidadmani on September 9, 2011

Stop the services so you can merge the RPDs in offline mode.

Go to Admin Tool and create a dummy RPD (KPIT_OBIEE_Demo.rpd) save and close.
Open the 1st RPD (Sample Sales.rpd) which you want to merge with another RPD (sh.RPD)

Click on file and merge

Select the dummy RPD (KPIT_OBIEE_Demo.RPD), provide the user and password.

Click select for the Modified Repository and select 2nd RPD (sh.rpd)

In decision you can either select Modified or Current.

You will see both the repositories merged into one as below.

Merge Web Catalog Reports into New web catalog.

Create a folder in OracleBIDataWebCatalog as SampleSales_SH

Add this folder name in the instanceconfi.xml file

Save and run the services. Oracle BI Presentation server will create default sub folders.

Merge the Sample Sales and SH web catalogs into SampleSales_SH.

Stop the services, so we can merge the web catalogs in offline mode.

Open two web catalog mangers (one old and another new) and copy respective folders from old to the new web catalog folder. Copy from both the old web catalog folders to new web catalog folder

Add the new RPD file name in the NQconfig.INI and run both the services.

You should get the new Web Catalog running on Interactive Dashboard.

– Santosh

Posted in Merge RPDs & Web Catalogs, OBIEE 10g, OBIEE 10g Dashboard, OBIEE 10g RPD | Leave a Comment »

Passing User Name & Password in the OBIEE URL

Posted by Santosh Kumar Gidadmani on September 2, 2011

Most of the times, we login to OBIEE Answers or Dashboard in development, testing or training environments to quickly check the results on Answers or Dashboard. You can avoid giving user name and password everytime you login to OBIEE Answers or Dahboard.

If you want to login to OBIEE Answers use the below URL and save it to your favorites. Next time, just click on this link to directly navigate to Answers.

http://santosh-5319:9704/analytics/saw.dll?Answers&PostRequest=PostRequest&nQUser=Administrator&nQPassword=Administrator

If you want to login to OBIEE Dashboard use the below URL and save it to your favorites. Next time, just click on this link to directly navigate to default Dashboard.

http://santosh-5319:9704/analytics/saw.dll?dashboard&PostRequest=PostRequest&nQUser=Administrator&nQPassword=Administrator

– Santosh

Posted in OBIEE 10g, OBIEE 10g Answers, OBIEE 10g Dashboard | 1 Comment »

 
%d bloggers like this: