I am trying to import data from data hub module structured with just line items (no dimensions)
A module in spoke model also structured as just line items ( no dimensions)
and it just doesnt work . The value field doesnt come up
time(line item) date formated
PS: i have also tried importing into Text formated line item with no luck
Go to Solution.
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
For a very detailed response , i really appreciate your effort .
One thing i would like to understand is why i doesnt work .
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.
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,