Rank

Hello All,

I hope all are good! After long time, I was busy with some work didn’t get time for blogging.

Let’s discuss today Ranks function in obiee 11g

RANK function returns the rank of a number. Suppose, user asking to create report, which shows rank column based on service request created every yearly.

Formula: Rank (expr)

Steps:

Select you’re columns – Year, # of SRs (Service Request) and take any column from subject area (On this column we have to put rank function) here I have taken “Problem type”

Click on Problem type: Go to edit formula and Click on function “F(..)” and select rank function from aggregate folder, you can see in screen shot.

Select the column. Here I have taken for “# of SRs” (Service Request) column.

Click on Ok and Run the report 

Thanks and Regards 

Rakesh Patil
rakeshpatil002@gmail.com

OBIEE Foundation Suite 11g Certified Implementation Specialist