Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
Can some one help me how to use link tables as i have two fact tables connecting to same dimmension tables, thus causing cirrcular loops and syntetic keys
Please find attachment
Thanks
Hi,
Concatenate() will often work better than a link table. Something like:
Data:
LOAD
'type1' AS FactType,
*
From....;
Concatenate (Data)
LOAD
'type2' AS FactType,
*
From....;
Hope this helps,
Jason
Hi i cannot concatinate the fact tables as they deal with different measures one fact table is sales and the other fact table is orders
Which is why you use the FactType field. In your chart expressions you can use set analysis to distinguish between the different fact types - Sales and Orders.