Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Data set in Data Model which doesnt work — Cloud Customer Connect
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

Data set in Data Model which doesnt work

Received Response
26
Views
26
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 26 comments

Summary

Data set in Data Model which doesnt work

Content

Hello,

I'm working on an RTF template on which I want to display certain information of a table called "shipment_stop_debrief". Fyi I didn't create this data model from the start, i'm new at this.

I created another Data set with this content:

SELECT ITEM_PACKAGE_COUNT FROM

(

select t.*, row_number() over (partition by s_ship_unit_gid ORDER BY INSERT_DATE DESC) rn

FROM shipment_stop_debrief t) ITEM_PACKAGE_COUNT_DEBRIEF

where rn = 1

I linked this data set to another one via the SHIPMENT_GID field a follows:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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