SAP BI Blog

Implementing Rank Functionality in SAP Data Services

SAP Data Services is a versatile and powerful enterprise information management tool that can extract, transform, and load data between many different systems and databases.  In this post, I will detail how to implement a rank functionality using tools available to you within SAP Data Services.

The RANK function is becoming a more and more common requirement in today’s business world because it is able to limit the number of records that are displayed on a report or dashboard down to a meaningful set.  Typically, ranking is used to limit records to those that are most recent.  This is helpful in dashboards and mobile reports where a user certainly would not want to be accessing every piece of data that is available.

A rank function simply should assign a numeric rank to a value that is part of a set of values based on your ranking criteria.  For example, if you wanted to assign ranks to the set of dates {2/5/2013, 12/25/2012, 3/15/2013, 1/2/2013, 11/27/2012} in order of descending values, your output would look like:

Download full PDF and Continue Reading…

Richard HauserAbout Richard Hauser
Rich is a business intelligence consultant specializing in Enterprise Information Management.  He has delivered customized SAP BusinessObjects solutions for customers of all sizes across a variety of industries.  With Decision First Technologies, Rich utilizes SAP Data Services and SAP Information Steward.

protiviti

protiviti

Add comment

Your Header Sidebar area is currently empty. Hurry up and add some widgets.