3.3.3.2 Import Data into DAT04 module

vyshnavsk

I was trying to import from data hub to supply chain model, but it was not working out,

Accepted answers

ClauN

No you should not modify the Data HUB.

You are trying to import datas from the Data Hub to the supply chain model right ?

DATA HUB Source : Time (HY) ———> Target Supply Chain : Time (Weeks)

Currently you are not importing anything into the Supply Chain model cause Anaplan can't import HF datas into weeks.

So you need to have :

DATA HUB Source : Time (HY) ———> Target Supply Chain : Time (~~Weeks~~ HY )

All comments

ClauN

Hi !

You can see in the mapping that something seems to not work for the P3 dimension.

Your P3 list seems empty. Can you show us the P3 SKU tab ?

vyshnavsk

@ClauN

ClauN

Ok, you P3 list is correct, can you send us a screenshot of every tab ?

The problem might come from the module, could you please send a screenshot of the grid view of the DATA04 ? We need to see the Applies to column

The import seems successful for me, i don't think you have any problem ?

vyshnavsk

@ClauN

sorry its this one, this is data hub model from where its getting imported to supply chain model

ClauN

Your Time scale in your data hub model is Half Year.

You need the same time Scale in the Target module.

You can not import HY datas into weeks.

Make the change and i think your problem will be solved

vyshnavsk

@ClauN so i should change the data hub model time scale to weeks?

ClauN

No you should not modify the Data HUB.

You are trying to import datas from the Data Hub to the supply chain model right ?

DATA HUB Source : Time (HY) ———> Target Supply Chain : Time (Weeks)

Currently you are not importing anything into the Supply Chain model cause Anaplan can't import HF datas into weeks.

So you need to have :

DATA HUB Source : Time (HY) ———> Target Supply Chain : Time (~~Weeks~~ HY )

vyshnavsk

@ClauN thank you

ClauN

Happy to help : )

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…