Looping with Link tables

[#1]

Hi All

I have issues with looping within my data structure where I get the message "One or more loops have been detected in your database structure...."

I have looked at below article about link tables and it doesn't seem to help me.

http://www.quickqlearqool.nl/?p=910

I have two fact tables connected to two dimensions.

I can't share the actual qvw file due to data protection issue but have created the problem in the attached sample qvw file.

I have had to implement the solution this way due to the data source etc..

Thanks for your help.

Kash

[hic · Accepted solution]

I would concatenate the two fact tables. Just make sure that the common keys have the same names whe you do it.

Example:

Fact:

Load

     LocationID,

     ProductID,

     <OtherFields1>

     From Facts1;

Concatenate Load

     LocationID,

     ProductID,

     <OtherFields2>

     From Facts2;

and then load the dimensional tables.

HIC