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...
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...
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...
To_Date Function

In Oracle/PLSQL, the to_date function converts a string to a date. Syntax The syntax for the to_date function is: to_date( strin...
OBIEE 11g - How to get proper date sorting in graphs

When using OBIEE, I've run into situations with graphs and tables where, if I want to show a date format of just month (Jan, Feb, ...
OBIEE 11g: Expanding Hierarchy Column

Expanding Hierarchy column at desired level for all sections of a pivot table. In this post I will explain you how to do that. In my ex...
Renaming Dashboards in OBIEE

Renaming Dashboards in OBIEE There are 2 ways to rename the shared dashboards. 1. Using Catalog Manager 2. From Answers admin tab. ...
Creating RTF Templates by Using BI Publisher 11g Template Builder for Word

Overview Template Builder is an extension to MS Word (2003 or later) that simplifies RTF template creation for Oracle BI Publisher repo...
Declaring Variables

What is a variable? In Oracle/PLSQL, a variable allows a programmer to store data temporarily during the execution of code. Syntax ...
Informatica PowerCenter Server Status URL

Here is a really easy way to verify information about an Informatica PowerCenter’s current status. You need not be an administrator or e...

VIEWERS

Visitors map

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