RSS
 

Posts Tagged ‘repository’

OBIEE 10g repository and catalog migration-merging

21 Dec

1 – Introduction

This post will explain how to migrate/merge modifications from a development repository to a production one. Moreover will explain how to move development catalog modifications to a production one.

In order to provide some screenshots, I have used the same demo repository and catalog; I created 2 copies and I have applied few modifications.

So the screenshots won’t reflect a real and complex situation but at least will be helpful to understand all the steps.

First to go on with the migration, just take a look to the different object we want to migrate.

Environment A
Repository Dashboard Answers
Environment B
Repository Dashboard Answers

Read the rest of this entry »

 
1 Comment

Posted in Business Intelligence

 

OBIEE Tips #4: Presentation Layer Aliases

18 Dec

1. Introduction

The purpose of this post is to show the usage of aliases in the OBIEE presentation layer.
OBIEE uses aliases in presentation layer in order to avoid report failure whenever a source column or source table name changes in the repository.

2. Create an alias

Automatically

- For a Table
A table alias is created automatically when the table’s name  is changed only and exclusively by taking the following actions: right click -> rename; if a table’s name changes by taking a different action, the alias is not created automatically.

Read the rest of this entry »

 
1 Comment

Posted in Business Intelligence

 

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

 

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