protivitiSAP 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…
About 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.
Jacintha Anandaraj
Chris Hickman
Matt Hawkins
Add comment