I am facing issue in receiving data from Informatica cloud

anitha123

Hi ,

I am receiving the below error .please let me know the reason.

Error in Anaplan.png

I am not getting data into target module.I am not understanding what is the issue

Accepted answers

All comments

seymatas1

Hi Anitha,

It looks like the mapping for your import action got broken. Here are some simple troubleshooting steps to help you fix it:

Open your data file, IC_BU_Actuals_NPNL_csv, and check the column names.
Open your target model, likely a data hub model.
Go to Modules and open DAT013c.
Compare the column names in your file with the line item names in the module. If they don’t match, it means either the file or the module line items were changed. You can either update the file or the line items to match, or map them manually.

Here’s how to manually map:

Go to Actions, find Import into DAT013c BU Actuals action.
Click Edit.
Go to the Line Items tab. You’ll see the line item names like GROSS_MARGIN, OPERATING_MARGIN, NET_REVENUE_SNOW_Asset_License, etc.
Map each column manually to the correct line item.

Note: Anaplan is not case-sensitive, so no need to worry about upper or lower case mismatches.

I hope this helps.

Seyma 🌷🙂

anitha123

Hi Seyma,

Actually the issue was between Informatica cloud and anaplan.the issue was resolved after unique id mapping in Informatica end but no records are flowing into anaplan.Manual uploads done in anaplan is working.The last action showing 0 successful rows

{C6B73891-22C7-4CD2-9C32-924DD7248D1A}.png

Quick Links

Can you help?

Unanswered questions

XL3SetProperty to navigate
Hi everyone, I'm trying to use this function on specific members of my grid, as described in the documentation. In my example, the grid contains two row elements: ACTIF and PASSIF. The problem is that when I use this function, it affects all elements in the grid, whereas I only want it to apply to the specified member:…
Anaplan XL - Member Properties
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
How to calculate the weight?...
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…