Import to time based module with "ask each time" time selection

Hi!

i have met the following issue.

There are two modules:

- Target Module: Time based (Year)

- Source Module: no time dimension

when doing import , I chose "ask each time " option for time dimension , and during import run i select that single year which is presented in the module. the import is running successfully but all ignored and nothing is being loaded.

if i add text field in source module with year name "FY19" and map it in import settings, the data is loaded successfully.

So I do not understand why fist option is not working for me.

thank you

Accepted answers

All comments

VIGNESH.M

Hi,

I have tried your scenario, for me its working fine.

Source Module:

List: Employee

Line Item: salary

Target Module:

List: Employee & Time

Line Item: salary

I have selected "ASK each time import" option, to import data to particular year based on my year selection.

Please check your source and target dimensions, there is some mismatch.

Regards,

Vignesh M

AleksandraE

Hi @VIGNESH.M thank you for your reply, here are some more details:

Source and Target modules are located in different models- this is truth (i do not think it should be the reason for the issue) , but all dimensions are mapped successfully in import settings (except for time)

- Source module:

List: Currency, Line Item: CY Ex Rate

- Target Module:

List: Source Currency (both currency lists have the same codes and mapped successfully), Line items: Ex rate (mapped manually to Line item "CY Ex Rate") , time year.

so when selecting time during upload : import is successfully completed and all elements ignored.

VIGNESH.M

Hi Aleksandra,

Tried to recreate the scenario you are working, For me its working perfectly fine. Not sure where is the problem exactly.

Is your currency list is the number list?. if it's number list, then map code to Currency List. Include Column code in source Module.

Thanks,

Vignesh M

Quick Links

Can you help?

Unanswered questions

Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…