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

Export One Row like Period Member using EPM Integration Agent

Received Response
43
Views
1
Comments
edited Jul 10, 2023 3:18PM in Planning 1 comment

Summary:

Hi Team,

we are working on EPM PBCS integration with OnPrem ERP Staging Tables using EPM Integration Agent.

Our requirement is:

=======================================

PO_Week(Period), Account, Scenario, Version, Data

05/18/2023, 11111, Plan, Working, 100

05/18/2023, 2222, Plan, Working, 200

05/18/2023, 3333, Plan, Working, 300

05/18/2023, 4444, Plan, Working, 400

=====================================

Export of above Data to table is working as expected but requirement is to export only PO_Week.

We used Query method from Data Exchange. Below is query.

INSERT INTO <TABLE> PO_WEEK VALUES(~PO_WEEK~)

Above query inserts 4 Rows in PO_WEEK Column of Table

PO_Week

05/18/2023

05/18/2023

05/18/2023

05/18/2023

---------------

But we need only 1 Row to be inserted. Like below. Is it possible using Data Exchange? Appreciate your inputs.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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