You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Emulate the PLSQL (partition) in DV?

Received Response
9
Views
2
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 2 comments

Summary

Is there a way within the DV tool to emulate the PLSQL (partition)?

Content

Is there a way within the DV tool to emulate the PLSQL (partition)? row_number() over (partition by v_BUSINESS_UNIT, v_VOUCHER_ID order by v_BUSINESS_UNIT, v_VOUCHER_ID) rn

Data Flow?

Version

18 , Cloud

Code Snippet

select V_BUSINESS_UNIT
,V_VOUCHER_ID
,PO_PO_ID
,v_entry_status
,V_GROSS_AMT amt
,V_FREIGHT_AMT
,V_MISC_AMT
, row_number() over (partition by v_BUSINESS_UNIT, v_VOUCHER_ID order by v_BUSINESS_UNIT, v_VOUCHER_ID) rn
FROM FACTTable
where  v_entered_dt > '31-DEC-2017'
and po_po_id is not NULL
and po_po_id <> ' '
and po_po_id <> '(null)'
group by  V_BUSINESS_UNIT
,V_VOUCHER_ID
,PO_PO_ID
,v_entry_status
,V_GROSS_AMT
,V_FREIGHT_AMT
,V_MISC_AMT

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!