Module to module import

karank_*4578

Hi Guys

I am trying to import data from data hub module structured with just line items (no dimensions)

into

A module in spoke model also structured as just line items ( no dimensions)

and it just doesnt work . The value field doesnt come up

source module

time(line item) date formated

target module

time(line item) date formated

PS: i have also tried importing into Text formated line item with no luck

Accepted answers

VIGNESH.M

Hi Karank,

As per my understanding, the source table should be always more than 1 dimension.

if it's 1 dimension, then this is how the grid appears in the import tab.

Photo1.png.jpg

~Vignesh

All comments

VIGNESH.M

Hi Karank,

if the source and target table dimensioned by line item, then it won't work, you have to add Dummy dimension in your source table.

Follow the below steps,

Step 1: create Dummy List, with 1 list item. Photo1.png.jpg

Step 2: In your source module, add this "Dummy Import" Dimension.

Note: Add this extra dimension only in your source table, not in Target Table.

Photo1.png.jpg

Step 3: Create the import action as shown below

Photo1.png.jpg

~Vignesh

karank_*4578

Thanks Vignesh

For a very detailed response , i really appreciate your effort .

One thing i would like to understand is why i doesnt work .

Thanks again

VIGNESH.M

Hi Karank,

As per my understanding, the source table should be always more than 1 dimension.

if it's 1 dimension, then this is how the grid appears in the import tab.

Photo1.png.jpg

~Vignesh

dkolka

Hi,

Said differently, it takes 2 dimensions to form an intersection. The intersection is where the data will live - by at least row and column. Most row/column database systems need 2 dimensions by which to store data.

Hope that provides additional perspective,

Dave

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…