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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BI + Analytics conference: Aug 9.

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
leo_dec11
Senior Member
Senior Member



Joined: 18 Jun 2009

Posts: 89



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
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4223
Location: Denver Area


flag
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.0100 seconds using 17 queries. (SQL 0.0029 Parse 0.0002 Other 0.0069)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo