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!
Data set in Data Model which doesnt work
Summary
Data set in Data Model which doesnt workContent
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:
1