Kishore Analytics Solutions

OBIEE 11g - Date Format change based on Locale Setting

This piece of information is a very base to locale setting. When a user requested to change the date format, as the user couldnt al...
Calculate the average between two dates

Question: I am trying to find the average time between two dates, using PLSQL. For example: If I wanted the average time between May...
OBIEE 11g - Sorting on the Total in a Pivot

Pivots in OBIEE are a great option of displaying data, especially monthly data. However, I often run into a situation where the custo...
Action Framework and Conditions

Using the OBIEE 11g Action Framework, I can define actions in the web catalog that can launch additional reports, display web pages or gu...
Rank function syntax in OBIEE

“how do I display the TopN most expensive projects across a range of years? For example, the top 3 most expensive projects on a year-b...
Exploring Advanced Features of Oracle BI Publisher

Overview The Getting Started with Oracle BI Publisher OBE covered the regular features such as creating reports from various data sou...
statistical technique for drawing a line through a set of data points

Linear regression is a statistical technique for drawing a line through a set of data points that “best fits” the data. It is a useful an...
OBIEE 11g - Description ID column

OBIEE 11g rpd we have new feature to show double columns value using a single one (column) – Description ID double click on a...
OBIEE 11g Creating Analyses and Building Dashboards 11.1.1.6.2

Purpose In this tutorial, you will learn how to build, format, and customize Oracle Business Intelligence (BI) analyses and how to crea...
[OBIEE11g] ADD Row Number in Answers

To add a row number column to your analysis, you need to do the following: Add any columns from your subject area to your analysis Edit...

VIEWERS

Visitors map

Oracle Business Intelligence. Awesome Inc. theme. Powered by Blogger.