BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: IBIS 2018: Jun 18, BI & HANA 2018 Prague: Jun 29.

rank function in bods

Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Senior Member
Senior Member

Joined: 18 Jun 2009

Posts: 96

PostPosted: Wed Jul 12, 2017 7:15 am 
Post subject: rank function in bods

Hi guys

I am need rank functionality in the dataflow.. I tried Rank() OVER (ORDER BY ID) in sql server which works fine... data look like:-

ID Rank_expected
101 1
101 1
101 1
102 4
103 5
103 5

I tried order by ID in 1 query transform and used gen_row_num_by_group(ID) in next query transform but the result is not coming as per expected

ID Rank_DS_Generate
101 1
101 2
101 3
102 1
103 1
103 2
Back to top
Forum Addict
Forum Addict

Joined: 12 Sep 2007
Posts: 4277
Location: Denver Area

PostPosted: Tue Jul 18, 2017 12:28 pm 
Post subject: Re: rank function in bods

When using functions that require data to appear in an ordered state the same way every time, be sure you set the DOP to 1 for the Dataflow. If you don't do that then the Dataflow can split the data after it is sorted and in subsequent transforms the data will be processed out of order.

Try doing that first. If that doesn't work then post back here and let's see what else needs to be done.

Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0103 seconds using 17 queries. (SQL 0.0033 Parse 0.0002 Other 0.0069)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo