Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module

Candy
Contributor

Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module

Hello,

I'm stuck on mapping Volume. It says manual mapping is unavailable but I can't see if items are matched correctly through 'Match on names or codes'.

Other dimensions are mapped without problem so I don't know what to do with Volumes.

 

Below are the mappings.

Candy_0-1616746965422.png

Candy_1-1616746981876.png

Candy_2-1616747013368.png

Candy_4-1616747054032.png

Candy_6-1616747096752.png

 

Please help.

Thank you! 😊

Candy

 

 

 

 

4 REPLIES 4
Misbah
Moderator

Re: Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module

@Candy 

 

 I see multiple issues with this import mapping

 

1. Time can 't be Fixed in this case. Kindly change it and Map Column 3  to Time

2. Target module has Yearly timescale. Change it to weeks

3. You can map Column 4 Volume to Line Items or you can keep that as Fixed Line item. (Optional)

Candy
Contributor

Re: Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module

@Misbah 

 

Thank you for your assistance. But I am still confused and perhaps you can explain.

1. Time can't be fixed

All the data in the source relates to FY19 so shouldn't it be fixed? If it's not fixed then how should I map the time tab.

 

Candy_0-1616750810556.png

Candy_1-1616750844847.png

 

2. Target module has week as the Timescale in the Blueprint view.

Is there another place I need to change?

Candy_2-1616751001350.png

3. Column 4 Volume has been mapped to DAT03 line item Volume in the target (summary mapping).

But individual tab is not showing what has been mapped. Is the current mapping incorrect?

Why would Volume be mapped as a fixed line item?

Candy_4-1616751769024.png

 

Candy_3-1616751422972.png

 

Thank you.

Candy

 

 

 

Misbah
Moderator

Re: Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module

@Candy 

 

See below

 

This has to be Column 3 from dropdown and not Fixed Time.

 

Misbah_0-1616762574418.png

 

harshitha.narayan@sony.com
Occasional Contributor

Re: Level 2 Sprint 1 - L1.5.6.2 Import Data into Historic Volumes Module

Hi Candy,

 

Need your help here. 

I am too facing the same issue and it would be great if you can guide on how this was resolved.

 

Thank you,

Har**bleep**ha