Import for Weekly Data

Sravan_Kumar
Community Boss

Import for Weekly Data

I am trying to import Historical Weekly Data, but am constantly getting error.

Please assist how to import Weekly Data?

 

I tried several times, I have attached Screenshot.

 

 

4 ACCEPTED SOLUTIONS

Accepted Solutions
Harsha
Frequent Contributor

Re: Import for Weekly Data

Please map the columns as per the screen shots.

View solution in original post

Misbah
Moderator

Re: Import for Weekly Data

@Sravan_Kumar 

 

Can you please map it like below

Column 3 : Weeks - Time

Column 2 : Accounts - Accounts Flat

Column 1 : SKU - SKU Flat

Column Headers -  DAT03 Historic Volumes Line Items

 

Last mapping you are doing it incorrectly as you are mapping it the Column 4: Volume

 

Hope that helps

Misbah

View solution in original post

kavinkumar
Certified Master Anaplanner

Re: Import for Weekly Data

HI @Sravan_Kumar,

The issue is not with the time dimension. The error says that the mapping you made to the line items is wrong. 

Based on the mapping, the system will read each value in the 'Volume' column and try to map it with the line items present in the target modules. Fr ex, Anaplan try to find a line item with the name 58.87728739 as per 1st record. But this should be the case. 

My understanding is, you are trying to import the volume data at  Acct, SKU and Weekly level. Please do the mapping correctly. 

If there is only one data that needs to be imported, then make use of the option 'Fixed Line item' else 'Column header' as per @Misbah post.

To help, please find below,

 

Column 3: WeekTime   
Column 1: SKUAccount Flat list   
Column 2: AccountSKU Flat list   
Fixed line itemDat03 history volumes line item Data Values from 

Column 4: Volume

 

And finally in the line items tab (last tab), mark the destination line item.

 

image.pngimage.png

 

I hope you understand!! Let me know in case of any concerns.

Regards,

Kavin.

Regards,
Kavin.

View solution in original post

matt_m-p
New Contributor

Re: Import for Weekly Data

Hi @Sravan_Kumar,

 

Thank you for your post. 

 

I can understand how this issue can be frustrating. 

 

For your Source, if you have

"Week" => to Time

"SKU" => to SKU Flat

"Account" => to Account Flat

Fixed line Item => to DAT03 

 

You are good.  

 

It is when you are under the "Time" tab that the issue may arise.

 

You need to select the Match names option in the "How to map the source data into the timescale" section.  This is because Anaplan is reading Week 1 FY19, Week 2 FY19, and so on as specific names not as units of time.

 

I hope this helps.

 

Matt

View solution in original post

13 REPLIES 13
Harsha
Frequent Contributor

Re: Import for Weekly Data

Hi,

 

In Mapping tab, Please select "Column 3: Week" for Time and (Column Headers) for Volumes line item. 

In Time tab, select match names.

 

Run the import again.

 

Thanks,

Harsha

Sravan_Kumar
Community Boss

Re: Import for Weekly Data

Hi @Harsha,

 

I tried your instructions, but it returned the same error.

 

Regards,

Sravan.

Manuela_Apostol
Certified Master Anaplanner

Re: Import for Weekly Data

HI @Sravan_Kumar , 

 

You have to map Time to columns 3 weeks (and apply the match item indicated in a post above) and Column Headers to Data03 

Manuela_Apostol
Certified Master Anaplanner

Re: Import for Weekly Data

and can you attach the error messages you get with the new mapping? 

I don't think the weeks is the problem 

Sravan_Kumar
Community Boss

Re: Import for Weekly Data

Hi @Manuela_Apostol,

 

I have attached the error messages.

Can you please have a check and assist a possible way.

 

Regards,

Sravan.

 

 

Harsha
Frequent Contributor

Re: Import for Weekly Data

Please map the columns as per the screen shots.

View solution in original post

Sravan_Kumar
Community Boss

Re: Import for Weekly Data

Hi @Harsha ,

 

Did the import work for you?

I tried your suggested way again, but was thrown the same earlier error log.

Even I kept Data values either Blank or selecting Weeks or Volume but every time it failed.

 

Regards,

S. Kumar.

Misbah
Moderator

Re: Import for Weekly Data

@Sravan_Kumar 

 

Can you please map it like below

Column 3 : Weeks - Time

Column 2 : Accounts - Accounts Flat

Column 1 : SKU - SKU Flat

Column Headers -  DAT03 Historic Volumes Line Items

 

Last mapping you are doing it incorrectly as you are mapping it the Column 4: Volume

 

Hope that helps

Misbah

View solution in original post

Sravan_Kumar
Community Boss

Re: Import for Weekly Data

Hi @Misbah,

 

It is not working.

The error is with Time Mapping and I am trying hard but with no success.

It would be of real help, if you can guide me out with this.

 

Regards,

Sravan.