Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERPI Source Adapter load to FDM - No Records Found

Mike_LauAug 12 2014 — edited Aug 25 2014

Hello All,

I am trying to implement an FDM data load that pulls data from ERPI.  I setup the ERPI components and when I run the Data Load Rule in ERPi, I see results in the Data Load Workbench.  When I try to import the data (using the same data load rule) into FDM i get an error saying No records found for Load ID (###).  When I go to ERPI Process Details to see the log for Load ID (###) I see that records were processed and records were inserted into the TDATASEG table.  So it seems like the call to fTransferData in the GETDATA action script of the adapter doesn't seem to be pulling the correct data, or something is not configured correctly and it can't see the data.  Any help would be greatly appreciated.

Both ERPI and FDM are on Oracle databases.

We are running 11.1.2.1

Thanks,

Mike Lau

Comments

user12947051
Answer

Seems that when I use strings directly, something foes wrong. I have to use different notation, like

&formulaUse4=code

&col4="bla-bla3"."Year%20Month"

&op4=bet

&val4="[Dim bla-bla3].[<Year%20Month Decriptor ID>].&[201501]"+"[Dim bla-bla3].[<Year%20Month Decriptor ID>].&[201504]"

In this case not strings are being compared, but string IDs. In my case "Jan 2015" < "Apr 2015", so no data returned. After putting data into fields and manual press on Apply button OBIEE already uses IDs instead of strings. Wow.

Marked as Answer by user12947051 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 22 2014
Added on Aug 12 2014
10 comments
2,677 views