Looping with Link tables

Tue, 19 Feb 2013 15:26:55 GMT

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.

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

Re: Looping with Link tables

hic — Tue, 19 Feb 2013 20:28:31 GMT

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,

From Facts1;

Concatenate Load

LocationID,

ProductID,

From Facts2;

and then load the dimensional tables.

HIC