RSS
 

Posts Tagged ‘presentation services’

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

 

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

 

Understand and configure the “writeback” option in OBIEE 10g

12 Oct

1 – Introduction

The OBIEE writeback functionality allows the end-user to write informations in the database with some limitations.

Often the writeback functionality is used to allow the users to apply a comment to certain data in the report or to input values for a caluclation.

This option can be integrated only in Table Views; Gauge, Pivot and other views do not support the writeback.

2 – Best Practice

The best practice is to do not allow the user to directly modify the datamart structure; is always useful to provide a table  that will store the data inserted via writeback. That table is usually imported in the repository and linked with the other tables in order to be used in the reports.

3 – Setup the writeback functionality

3.1 The SQL statement that are executed by the server to complete a writeback operation are stored in xml template that need to be create in the following folder: <OBIEE_HOME>\OracleBI\web\msgdb\customMessages\

3.2 Give whatever name to the file and write the followin xml code inside it:

<?xml version=”1.0″ encoding=”utf-8″ ?>
<WebMessageTables xmlns:sawm=”com.siebel.analytics.web/message/v1″>
<WebMessageTable lang=”en-us” system=”WriteBack” table=”Messages”>
<WebMessage name=”<Message Name that will be used in the presentation later [case sensitive!!!]>“>
<XML>
<writeBack connectionPool=”<Connection Pool Name used in the repository [case sensitive!!!]>“>
<insert> <Insert statement> </insert>
<update> <update statement> </update>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>

Remember: The <insert> and <update> tags need to be defined in the xml file even if there is no statement defined for that particular operation. In this case, a blank has to be inserted between the open/close tags; e.g. <insert> </insert>

Read the rest of this entry »

 
No Comments

Posted in Business Intelligence

 

How to completely setup the Oracle BIEE 10g cache options

08 Oct

1 – Introducion

This topic is meant to fully understand the OBIEE 10g cache mechanism.

The cache funcionalities provided by OBIEE 10g should be used in a production environment; in a development environment we usually want to see data changing whenever we modify data in the data source; for this reason, cache settings will be different for each environment.

2 – OBIEE 10g Server Cache Settings

The Server chache is activated by default when you installed OBIEE 10g; cached items correspond to files in the filesystem.

Obviously we can define the amount of space to be dedicated to this files by editing the <OBIEE_HOME>\OracleBI\server\Config\NQSConfig.INI file, changing the following parameter:

DATA_STORAGE_PATHS            =            “D:\oracle\product\10.1.3.4.1\OracleBIData\cache” 5000 MB;

We can also change the directory path for the cache files; if we take a look to the cache directory, we will find several files with a .TBL extension.

Read the rest of this entry »

 
No Comments

Posted in Business Intelligence

 
« Older Entries