RSS
 

Posts Tagged ‘rpd’

How to catch report physical query and increase the log level in OBIEE 10g

18 Oct

1 – Introduction

I write this post because many times people asked me to help them by setting up the OBIEE log level in order to do not face the “No Log Found” warning message in the Manage Session console.

2 – Catch a report physical query

Sometimes is useful to catch the physical query that OBIEE executes when a report is running. To get the query we need to access the presentation services with the Administrator’s user and identify the running report by click on Settings -> Administration -> Manage Sessions; once the report is identified we click on the related “View log” link.

If we get a “No Log Found” warning message, we need to increase the OBIEE 10g log level by following the instructions below. Read the rest of this entry »

 
2 Comments

Posted in Business Intelligence

 

Connect ESSBASE to OBIEE 10g’s repository

18 Oct

1 – Introduction

In this topic we will see how to connect essbase to the OBIEE 10g repository and use it as data source for our reports.

2 – Prerequisites

2.1 The following product versions need to be installed:
OBIEE 10.1.3.3.2 or higher.
Essbase 7.1.6 or higher.

Essbase libraries need to be installed in the same machine where OBIEE server is installed.
We will assume that an Essbase server instance is already running somewhere as well as the OBIEE 10g, so we just need to link the two products; in order to connect Essbase to OBIEE 10g we need to install the Essbase client.

2.2 To install Essbase Client, you need to download the following software from http://otn.oracle.com (aproximately 8 Gb):
Hyperion EPM System Foundation Services (System Installer, Foundation Services, Architect)
Oracle Essbase (Client, Server, Provider Services)

Read the rest of this entry »

 
2 Comments

Posted in Business Intelligence, Data Warehousing, Database

 

How to setup multiple repositories on a single OBIEE 10g installation instance

14 Oct

1 – Introduction

This topic explains how to setup multiple repositories on a single OBIEE installation instance.

Having multiple repositories on a single OBIEE 10g instance could be useful especially if want to manage different projects in a development environment or if you are sales people that need to show different solutions to the customers without having multiple OBIEE 10g installations on your laptop.

2 – Configure different repositories

The steps to setup multiple repositories on a single OBIEE 10g instance are really few.

2.1 First of all we need to add in the <OBIEE_HOME>/BI/Server/config/nqsconfig.ini the reference to another repository file:

Assuming that one of the repositories is the default one that comes with the first OBIEE 10g installation, your new configuration should look like the following:

Repository
Star1    =            myNewRepository.rpd, DEFAULT;
Star2    =            samplesales.rpd;

Read the rest of this entry »

 
2 Comments

Posted in Business Intelligence