2.3.9.1 Import data into DAT03 Historic Volumes module

JeemarieB
JeemarieB
in Academy Discussions

Hello,

Below are the steps I followed for this activity and the corresponding outcome

image.png
image.png
image.png
image.png

*All other tabs are mapped correctly

Outcome:

image.png

Is there anything I'm missing that causes the other data to be ignored?

Thank you in advance!

Best Answer

  • BrunoRodriguez
    BrunoRodriguez
    Answer ✓

    Hello @JeemarieB ,

    It looks like your model is not connected with the source. Go to the tab that says "Source models" on the left panel and repoint your datahub with your model.

    Cheers!

    Kind regards,

    Bruno Rodriguez

Answers

  • BrunoRodriguez
    BrunoRodriguez

    Hello @JeemarieB ,

    It looks to me like the import is correct. Are you getting all the values in Anaplan?

    With regards to the ignore, have you modified the excel file in any way? It looks to me like +2.5M entries modified is too many.

    Cheers!

    Kind regards,

    Bruno Rodriguez

  • JeemarieB
    JeemarieB

    Hi Bruno,

    No, I haven't modified the excel in a way. It was an import right from a saved view from the Data Hub Model.

    And yes, I'm getting FY19 values but not 100% sure if it's complete due to the ignored data

  • JeemarieB
    JeemarieB
    edited May 2023

    @BrunoRodriguez I also run the process but was unsuccessful. See outcome below:

    image.png
    image.png
    image.png

  • JeemarieB
    JeemarieB

    @BrunoRodriguez works now! Thank you!

    image.png

Categories