RSS
 

Posts Tagged ‘obiee’

Oracle BIEE-like reporting tool by using low cost web technologies

06 Jun

1. Introduction

In this interesting post we will see how to mount an OBIEE-like reporting tool by using low cost web technologies.

In the example we are going to see how to combinate PHP Analytics and WordPress templates to get close to that objective.

2. The idea

PHP Analytics is a plugin that transform your WordPress platform in a reporting tool. It allows you to build views (tables and chart) that you can publish in a WordPress page/post.

Once we have our defined reports (see the offical documentation to use PHP Analytics), we just need to modify a WordPress template to give to our platform the OBIEE look&feel.
Moreover we have to play a little bit with the code in order to emulate the OBIEE frontend main logic.

Read the rest of this entry »

 
2 Comments

Posted in Business Intelligence, Development, Web

 

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 #6: Get a direct link to a dashboard

21 Dec

To get a link that points to a dashboard you can use the following::
http://<hostname>:<port>/analytics/saw.dll?Dashboard&PortalPath=<DASHBOARD_PATH>
<hostname> is the host name/address
<port> is the presentation service port (9704 for the default stand alone installation)
<DASHBOARD_PATH> is the path to the target dashboard inside the catalog.

You can get the <DASHBOARD_PATH> using the administration panel:

Read the rest of this entry »

 
No Comments

Posted in Business Intelligence

 

OBIEE Tips #5: Too many values in single select prompt

20 Dec

OBIEE’s single select prompt can’t display by default more than 256 values (It displays a “Too Many Values” value at the end of the list when the number of values is greater than 256).

This can be fixed in two ways:

1) edit the instanceconfig.xml file by adding the following line:

<Prompts><MaxDropDownValues>MAX_VALUES</MaxDropDownValues></Prompts>

where MAX_VALUES is the number of values the prompt will display.
Take care: a big value could affect the performances.

Read the rest of this entry »

 
No Comments

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

 
« Older Entries