Module to module import

Certified Master Anaplanner

Module to module import

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 

 

 

 

Message 1 of 5
4 REPLIES 4
Certified Master Anaplanner

Re: Module to module import

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

Message 2 of 5
Highlighted
Certified Master Anaplanner

Re: Module to module import

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

Message 3 of 5
Certified Master Anaplanner

Re: Module to module import

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

 

Message 4 of 5
Contributor

Re: Module to module import

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

Message 5 of 5