RSS
 

Archive for the ‘Business Intelligence’ Category

PHP Analytics’s demo

27 May

1. Introduction

This post will show some examples of PHP Analytics reports; the plugin has been installed on this blog and some views have been created and published below.

2. A report example

I want to show how a report could appear once published on your page. In this example we will see a fake distribution of the employees of a consulting company on the different lines of business.

Consultants per LOBs

LOB CONSULTANTS
BIW 25
EBS 2
Hyperion 18
IDM 6
JDE 4
People Soft 9
SOA 13

Read the rest of this entry »

 

PHP Analytics’s preview: Transform your WordPress Platform in a reporting tool

18 May

Introduction

I am delighted to announce that the first beta version of PHP Analytics will be soon available.
After several months of development the product has come out exactly how I wanted; few enanchements would be needed, but currently it’s working fine and without any critical major issue.

What is PHP Analytics?

PHP Analytics is a WordPress plugin that extends your blog platform’s functionalities by adding the chance to define connections to the database, execute queries and build views over the returned resultset (mainly tables and charts).
The full process to create a report could be resume as follows:
1. Create a Connection
2. Create a query
3. Create a view
4. Publish

Read the rest of this entry »

 

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 »

 

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 »

 

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 »