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
|
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.
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 »
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)
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;