RSS
 

Posts Tagged ‘dashboard’

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 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 10g: Nested tabs by embedding a dashboard into a page

17 Dec

1. Introduction

This post explains a very weird and tricky way to embed an OBIEE dashboard (a set of pages) inside a dashboard page.
The objective is to give the illusion of having multiple nested tabs.
Bare in mind that this is not really a solution cause OBIEE does not support natively this functionality.
I decided to write this article cause I have been asked to find a possible workorund in order to simulate a nested tabs view.

2. The Idea

The idea is to define N dashboard, where N is the depth level referred to the nesting tabs level.
A dashboard is a set of pages displayed as tabs; once we have created the first dashboard, we will embed a new one inside one page, by using an IFRAME.
Later we will make some customization in order to adjust the layout.
As you have probably understood, this kind of solution cannot be easily manteined, especially if we increase the tab depth level. Read the rest of this entry »

 
6 Comments

Posted in Business Intelligence

 

OBIEE Tips #2: Remove BI Publisher link form the “More Products” menu list

24 Nov



To remove the BI Publisher link from the More Products menu list in the dashboard, we need to edit the  <OracleBI>/web/msgdb/messages/commonuitemplates.xml file as follows:

1. Take a backup of the original file

2. Open the file and find the following line:

<a class="NQWMenuItem" name="advReporting" href="@{advReportingURL}" target="@{target}"><sawm:messageRef name="kmsgUIAdvancedReporting"/></a>

3. Comment the line as follows:

<!-- <a class="NQWMenuItem" name="advReporting" href="@{advReportingURL}" target="@{target}"><sawm:messageRef name="kmsgUIAdvancedReporting"/></a> -->

4. Now we should restart the Presentation Services in order to ge the desired result.

This tip is also useful if you want to add/edit new links to the menu list; you just need to preserve the structure of the file and use the right xml syntax to add new items.

 
2 Comments

Posted in Business Intelligence