SAP 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