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

    • 357,311 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for July, 2011

Direct Database Request (DDR) OBIEE10g\11g

Posted by Santosh Kumar Gidadmani on July 25, 2011

What is Direct Database Request in OBIEE?

The Direct Database Request (DDR) allows you to perform SQL statement directly on database. Users with the appropriate permissions can create and issue a direct database request directly to a physical back end database. The results of the request can be displayed and manipulated within Oracle BI Answers, and subsequently incorporated into Oracle BI Interactive dashboard.

What are the advantages of DDR?

Check physical connectivity to the database.
Check report or dashboard performance issues
Can be used for performance tuning techniques
Check the result retrieval time if the reports are fetching data slowly.
Write any complex table function query.

What are the disadvantages of DDR?
User can by pass a data level security defined in RPD.
User overload production database.
Users can modify the data in the database object.
It’s always recommended to disable DDR option to Production users.

Warning: You can perform SELECT but also CREATE or even DELETE and DROP statement!
The query will directly hit the database and will not connect to any BMM layer and Security.

How to create a Direct Database Access?

Firstly, provide privileges to the users
Admin tool

Go to manager – Security – Select the user name – Permission.
Select Allow on the Execute direct database request.

Answers – Settings – Administration
Go to Manage Privileges
Search by Direct database request and add User to the permission.

* Edit DDR and Execute DDR: Users should be added to these two permissions.

Create Direct Database Request

In the OBIEE11g, go to global header, click on new, click on Analysis, then click on create Direct Database request.

In the OBIEE10g, Go to Answers, you will find Direct Database request.

Provide the Connection Pool details

Give the connection pool details in quotes as below with first database name and connection pool name
“SH_SANTOSH”.”SH” (SH_SANTOSH – database name, SH – Connection pool name)

You can write direct SQL statement in the body and click on Validate SQL and Retrieve Columns.

Click on Result to check the data.

Save this request and place in dashboard.

– Santosh

Advertisements

Posted in Direct Database Request, OBIEE 10g, OBIEE 10g Answers, OBIEE 11g, OBIEE 11g Analysis | 11 Comments »

Deploy New Web Catalog in OBIEE11g

Posted by Santosh Kumar Gidadmani on July 13, 2011

The process for deploying a new web catalog is similar to deploying a new RPD in OBIEE 11g but we need to provide a new web catalog name in the same Enterprise Manager Web link. Let me give the steps.

Click on the business intelligence and on coreapplication

Click on “lock and edit configuration” to enable to change the web catalog default path settings

The configuration will change and click on close button

Give the new name in the presentation services repository section, I have given as Santosh as the new web catalog for demonstration.

Now, click on Active changes,

This will take some time to change the activation and click on close

Now, click on Restart to apply recent changes

This will take you to the screen where you can re-start the services. if you have done the changes on online mode, you need not restart the services.

To restart the services, go to Business Intelligencecoreapplication and click on Availability tab and click on Restart all Services (blue button) to restart the services.

Click yes if you get message confirming for start services

The system will process the request and it will show you the successful restart of service confirmation.

Now, login into request (Answers), navigate to Presentation service Administration link.

You can see that the web catalog has changed to Santosh.

Navigate to the below directory and you can see that there is a new web catalog folder (Santosh)

– Santosh

Posted in Deploy New Web Catalog, OBIEE 11g, OBIEE 11g Dashboards | 1 Comment »

Deploy New RPD in OBIEE11g

Posted by Santosh Kumar Gidadmani on July 12, 2011

After long time, started posting articles on OBIEE11g, let me start with deploying a new RPD in OBIEE11g so that I can use this in my blog articles.

To deploy a new RPD, first login to Enterprise Manager Link

Click on the business intelligence and on coreapplication

Click on lock and edit configuration to enable to change the repository default path settings.

The configuration will change and click on close button

Select your RPD from the browse and provide your repository (RPD) password

Again it will ask to browse the RPD, select the RPD and click ok and click on apply button.

You will see that the OBIEE has changed the RPD file name from SampleApp_BI0001 to SampleApp_BI0013. This is automatically done by the system.

Now, click on Active changes,

This will take some time to change the activation and click on close

Now, click on Restart to apply recent changes

This will take you to the screen where you can re-start the services.

Go to Business Intelligence coreapplication and click on Availability tab and click on Restart all Services (blue button) to restart the services.

Click yes if you get message confirming for start services

The system will process the request and it will show you the successful restart of service confirmation.

The setting in the NQSconfig.INI will automatically change to the current RPD path. You need not manually change in NQSConfig.INI file as done in OBIEE 10g.

If you open your RPD in online mode, your current RPD will open as below

Next article, we will see how to change the default web catalog folder.

– Santosh

Posted in Deploy New RPD, OBIEE 11g, OBIEE 11g RPD | 7 Comments »

 
%d bloggers like this: