on 05-27-2016 1:16 PM
Hi all,
We have a scenario where we want to load data from IBP to APO via Webservice (on APO side).
1. Query
Extracted the required fields from calculation scenario context using a simple query and filter by date >= 2016.04
2. XML_MAP
In this step we choosed "Generate Schema" -> "Generate schema from web service function", then we mapped columns from the input generated schema as required and final step - proposed the rule in Rule tab.
Testing in Design View:
All fine!
3. Target_Web_Service_Call
Only root node mapped.
Flow successfully validated. Then we run task in Projects Tab and see following error:
I would like to note that if you do not use TSTFR and TSTTO (in first Query step), the data is successfully transferred to the APO, but we need to fill column CALMONTH and that is why we use them.
Please help!
Hi Sergey,
Assuming that you don't need PERIODID (integer) in the Output, I can recommend you the following workaround:
1. Remove PERIODID from Output table
2. Enhance YEAR and MONTH mapping with the following: || substr(XXX.PERIODID,0,0)
Regards
Alecsandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Alecsandra, it works!
Hi Sergey,
the HCI template task 'IBP_KF_PlannedIndependentRequirements' extracts key figures from IBP and writes the data via Web Service as Planned Independent Requirement to APO. This seems very similar to what you try to do. Maybe it helps to take a look at this template to analyze the difference to your task. Additional information on the template can be found in chapter 2.2.8 of the Integration Guide (Link).
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sergey,
I noticed this strange behavior when exporting key figure from IBP.
Using PERIODID in the first query is not enough.
The only solution I found was to add an aggregation transform after the first query, where I keep PERIODID. In this aggregation, I group by all fields (so I do nothing in reality).
This "breaks" this strange link withPERIODID.
After this transform, you can stop using PERIODID.
Hope this can help,
Pierre
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sergey
You also need to add the root attribute PERIODID if you need TSTFR and TSTTO field in the export.
Thanks
Parveen Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.