Oracle BI 11G Design Best Practices: Oracle BI Principles

The purpose of the article is to document best practices to be used in Oracle BI. The article covers:
• Oracle BI Principles
• Repository design best practices
• Dashboards and reports design best practices
• 10g Upgrade considerations

In this very post, we are explaining main principles of Oracle BI. In the subsequent post, we will cover the other respective articles.

OBIEE 11g: How to Display the Export link Above a Analysis/Report

By default, the report links (such as Refresh, Print, Export etc.) are displayed below the results at the bottom of the page when an analysis is embedded in a dashboard.

How can you add an Export link be displayed above the analysis at the top of the page?

You can add the Export link above the analysis in the dashboard by embedding HTML code in a text object in the dashboard.

OBIEE 11g: How To Display the Appropriate Dashboard Page for each User, Dependent on their Application Role(s)?

When a user logs in to OBIEE, how can you set it up, so that the Dashboard the user sees is dependent on their application role(s)?

This can be setup using system session variable ROLES and PORATLPATH.

How to refresh GUIDs for OBIEE 11g ?

APPLIES TO:
Oracle Business Intelligence Enterprise Edition

PURPOSE
The purpose of this document is to provide clear steps for refreshing GUIDs in OBIEE 11g. The document also shows what to expect in the logs to confirm GUID refresh has completed successfully.

Location of Configuration files in OBIEE 11G

Configuration Files
Source: Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition > Where are Configuration Files Located?

New Features in the Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1

New Features in the Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1

• Enforce Limits Per Logical SQL Query
• Support for TimesTen Parallel Insert

OBIEE 11g: How To Display The Difference Between Two TimeStamp Dates As HH:MM:SS?

You have cases where end users need to display the difference between two time stamp date columns in the format HH:MM:SS.
End-users may find it complex to use the TimeStampDiff function to get the desired output.

TimeStampDiff is the out of the box function that returns the total number of specified intervals between two timestamps.

To display the difference between two time stamp date columns in the format HH:MM:SS, use the following syntax: