Home > Data Services > Implementing Rank Functionality in SAP Data Services

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.

Categories: Data Services
  1. September 24, 2014 at 12:50 pm

    Hello! I’ve been reading your website for a long time
    now and finally got the courage to go ahead and give you a shout out from Atascocita Texas!
    Just wanted to say keep up the good job!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: