Sales Planning Model: A2 List

jjconn13
jjconn13
in Academy Discussions

Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this saved module view into the Sales Planning A2 list and there are missing items. Perhaps my import mapping is wrong? Any guidance would be greatly appreciated! Please see the below screenshots for your reference. 

 

(Saved Module view in the Data Hub used for import)

jjconn13_0-1616416316787.png

(Import mapping for A2 list in Sales Planning model)

jjconn13_1-1616416343832.png

(Result of import - missing items from the saved view import)

jjconn13_2-1616416423352.png

 

 

 

Tagged:

Comments

  • Misbah
    Misbah

    @jjconn13 

     

    Your Import mapping looks perfect and your saved view too looks ok to me. Double check if you are importing it from the correct saved view. Here is one hint for you

     

    Hint: Your item count should be 4511

  • jjconn13
    jjconn13

    Thanks for the response. I double-checked the saved view and it appears to be ok. Below is the number of items being imported which does not match the 4511. For some reason it is skipping some of the items in the saved view. For example, the Candyate account - it appears to be imported every other line almost. 

     

    (Import result)

    jjconn13_0-1616420896193.png

    (Import Saved view in Data Hub)

    jjconn13_1-1616420998451.png

    (Resulting A2 list in Sales Planning model) - Missing P001, P003, P005 etc. 

    jjconn13_2-1616421070799.png

     

     

     

  • jakesachs
    jakesachs

    Did you ever figure this out? I'm also getting the 4358, but I am seeing those candyrate list members...

  • jjconn13
    jjconn13

    I ended up deleting and creating the list again in the Sales Planning model and imported the data from the datahub again. It seemed to solve the issue but I'm not exactly sure why. Maybe it's just me, but the import screens seem to act a bit weird sometimes. 

  • jjconn13
    jjconn13

    To clarify, I meant it fixed the missing list items that were not importing but my total was still the 4358. 

  • jakesachs
    jakesachs
    Am I right to assume that this didn't lead to any issues down the line?
  • ssicefox
    ssicefox

    Hi @jjconn13 @Misbah @jakesachs 

     

    I imported 7950 rows.

     

    ssicefox_0-1629481671707.png

     

    ssicefox_1-1629481769671.png

     

     

  • BruceSonos
    BruceSonos

    I got 4509 totally, before you import , the list itself had 151 items, after you imported, add 4358, totally is 4509, almost 4511, but I still have no idea how to get 4511.

  • Ghita
    Ghita

    I also managed to import 4358, but I'm not sure why, the system is generating new code instead of using the mapped codes, I'm struggling with this so bad !!

    here is my mapping, does anyone see what is wrong here ?

    Ghita_0-1654674022598.png

     

     

  • BruceSonos
    BruceSonos
    What's your code look like? This code should come from datahub module.

Categories