two fact tables en two attribute-tables

curiousfellow — Mon, 22 Feb 2016 14:30:29 GMT

I have two attribute tables and two fact-tables

Both attribute-tables should be joined with the fact tables

Because the fact-tables don't use allways use the same atrributes I created seperate joins.

So attribute_table 1 has a joint to fact1 and to fact2 and attribute_table2 has a join to fact1 and to fact2

when running the load script I get a message that there is a loop.

The only solution I can think of , is to create seperate attribute tables for facts1 and seperate attribute tables for facts2.

In that case I have to make separate listboxes too, something i want to avoid.

Is there another way to solve this ?

I enclose a qvw to explain the problem i am facing.

Re: two fact tables en two attribute-tables

marcus_sommer — Mon, 22 Feb 2016 14:50:31 GMT

The easiest way would be to concatenate both fact-tables and very probably I would it do this way.

- Marcus

Mark_Little — Mon, 22 Feb 2016 15:35:23 GMT

Hi,

Taking a quick look and like Marcus says, concatenate the two.

Mark