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

 

 

 

 

Comments

  • @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)

  • @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

     

     

     

  • @Candy 

     

    See below

     

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

     

    Misbah_0-1616762574418.png

     

  • 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

  • Hi,

     

    I tried mapping the time scale for the same issue as shown below, but its still failing or ignored.

    kalakantisneha_0-1637359826104.pngkalakantisneha_1-1637359856946.pngkalakantisneha_2-1637359896594.png

     

    Kindly help on how to map the time scale for Importing Historic Volumes (Level2 - Sprint1 - 1.5.6.2 Import Data into Historic Volumes Module)

     

    Thank you,

    Sneha.

  • Thank you. Very good support.

  • Thank you! This is really helpful!

  • Thank you so much, you really made good efforts.

  • Thanks for help. Really helpful.