"Error" message using Import to clear user input date data

Highlighted
Occasional Contributor

"Error" message using Import to clear user input date data

Hello, Community

 

In a daily replenishment planning model I've recently deployed for a customer, everyday, the planners may need to manually override below line items (format in brackets):

 

ADS Values (number)

ADS % Changes (%number)
Cancel Order? (boolean)
Manual Order Input (number)
Override Delivery Date (date)

 

Hence, I created a clearing process to clear out previous day inputs every morning when they refresh the data

1. Built a clearing module with 5 line items matching the same data formats as target line items (listed above)

2. Keep data fields as 0/false/blank

3. Run import from target module to pull data from the clearing module

The actions work perfectly for the first 4 targets. For clearing out the dates, an "error" message attached in screenshot will appear. I double quoted the error because in fact, the dates are cleared out successfully, yet Anaplan is throwing the message.

 

I have played around with different options with date formats or set as No Data, but the "error" message still exist. For now I put it as the last step of the process so that it won't affect other actions and asked the customer to ignore the message. But definitely this is not a preferred way to handle this.

 

Not sure anyone encountered such situation before or it is a platform bug. Any insights/workarounds will be appreciated.

 

 

13 REPLIES 13
Highlighted
Frequent Contributor

Re: "Error" message using Import to clear user input date data

Hello @tingtingxia 

 

Instead of creating another new module to clear the line items, create blank line items in the same module and import from saved view to saved view. In this you won't get any dimension issue.

 

1. To Clear few line items for all the rows, you can create another line item say "CLEAR" with "No Data" format and create saved view with only clear line items. 

2. Import into same module with clear saved view. Map CLEAR line item to the line item which you want to clear before importing. you can ignore remaining which you don't want to clear.

 Note: You have to create multiple CLEAR line items to clear the multiple line items. 

 

Thanks,

Harsha

 

Highlighted
Occasional Contributor

Re: "Error" message using Import to clear user input date data

Hi Harsha

 

Thanks for the reply.

I tried this method also. The dates will get cleared out yet Anaplan would still give the "error" message. You may refer to the screenshots I shared for the mapping details. 

Screenshot 2020-05-12 at 2.23.51 PM.pngScreenshot 2020-05-12 at 2.24.12 PM.pngScreenshot 2020-05-12 at 2.24.31 PM.png

Frequent Contributor

Re: "Error" message using Import to clear user input date data

Hey @tingtingxia 

 

Subsidiary view created in the module causing the issue. Its not just for Date format.  Even if you hide it in saved view, you'll get this issue. 

When you trying to import from same module, instead of selecting "Not applicable to this import" option, try to map subsidiary view list to the same line item. 

 

Action will run without any errors.

 

Harsha_D_1-1589266426289.png

 

In My case, column 5:task is subsidiary line item with list Parent. So I mapped the same.  

Harsha_D_2-1589266835562.png

Harsha_D_3-1589266941445.png

 

 

 

 

thanks,

Harsha

 

Highlighted
Certified Master Anaplanner

Re: "Error" message using Import to clear user input date data

Hi @tingtingxia,

 

Please find below the screenshots. I have created "Clear Values" module and marked as "No Data" for all the line items. 
Kindly check your Import action mapping to fix the error.

 

Sathya_0-1589254267331.pngSathya_1-1589254318211.png

Sathya_2-1589254378946.png

Sathya_3-1589254410388.png

Thanks

Sathya

Highlighted
Occasional Contributor

Re: "Error" message using Import to clear user input date data

Hi Sathya

 

Yes, mappings are correctly done. I am not sure:

1. whether is it related to subsidiary views in target module

2. if it is related to Point 1, why only throwing "error" message for dates clearing while others are run smoothly.

 

Best Regards

Highlighted
Certified Master Anaplanner

Re: "Error" message using Import to clear user input date data

Hi @tingtingxia,

Please try the below method.

 

Sathya_1-1589265602990.png

Create an import action to load Clear (No Data) into all the other line items. Make sure to click on "All items" in the mapping.

Sathya_2-1589265725584.pngSathya_3-1589265744924.png

All the values got cleared!

Sathya_4-1589265765311.png

Thanks

Sathya

 

Highlighted
Community Boss

Re: "Error" message using Import to clear user input date data

Harsha is probably right, date line item might be a subsidiary view, can you confirm ?
Can you show us the import mapping ?

Nathan Rudman, Anaplan Model Builder
Highlighted
Frequent Contributor

Re: "Error" message using Import to clear user input date data

Nathan,

 

Subsidiary view which is present in the module will throw this error when you select "Not Applicable to this Import" while importing. 

 

I have created this module to replicate the issue what is mentioned above :  I am mapping CL_Date line to Date line item to clear the value.

Task line item is subsidiary view with Parent list. 

Harsha_D_0-1589269748925.png

This is import selected for Parent list:  Even when we hide subsidiary line item from the saved view, we get this option.

Harsha_D_1-1589269816093.png

When you run this action, import will fail with this error.

Harsha_D_2-1589270010142.png

 

 

Thanks,

Harsha

 

 

 

Highlighted
Occasional Contributor

Re: "Error" message using Import to clear user input date data

Hi Nathan @Harsha_D 

Below are line items related to that Override Delivery Date (target to clear). This specific line item is not a subsidiary view, but I have a Today Date which is dimensionless. 

Screenshot 2020-05-13 at 9.34.59 AM.png

 My current mapping (shown to Harsha before) is as below and my question is how I can bring in other 4 dimensions for mapping? Currently in my dropdown list I don't have the selection.

Screenshot 2020-05-12 at 2.23.51 PM.png

Screenshot 2020-05-13 at 9.55.30 AM.png