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 

 

 

 

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.

 

~Vignesh

 

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.

 

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.

 

 

Step 3: Create the import action as shown below

 

~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

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