Import for Weekly Data

Sravan_Kumar

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.

 

 

Harsha

Please map the columns as per the screen shots.

Misbah

@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

kavinkumar

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: Week	Time
Column 1: SKU	Account Flat list
Column 2: Account	SKU Flat list
Fixed line item	Dat03 history volumes line item		Data Values from	Column 4: Volume

 

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

 

 

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

Regards,

Kavin.

matt_m-p

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

Harsha

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

Hi @Harsha,

 

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

 

Regards,

Sravan.

Manuela_Apostol

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

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

I don't think the weeks is the problem 

Sravan_Kumar

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.

Sravan_Kumar

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.

Sravan_Kumar

Hi @Manuela_Apostol,

 

I have attached the error messages.

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

 

Regards,

Sravan.

 

 

Sravan_Kumar

Thanks & @Harsha , @kavinkumar & @Misbah,

 

For your generous help.

I was able to import successfully.

 

Regards,

Sravan K.

LilyLiuAnaplan

match names is the key. Thank you very much!