Loop

[#1]

Hi All,

I have two fact tbles in my model - Slaes and Orders as shown in the figure above. Since the dimension tables join to the fact tables on same ids, qlikView will join the two fact tables as the columns will be same. To resolve this, I aliased the columns in the Orders table to xomehting like OrdColumn name and added an extra column in the dimesnion tables and aliased them accordingly. But am enountering loops error here.Any thoughts on this?

Thanks in advance!

[#2]

Concatenate your fact tables to avoid loops.

Fact1:

Load * from fact1.qvd;

Concatenate(Fact1)

Load * from fact2.qvd;

[gandalfgray]

Hi

One solution is to create just one fact table. You can add a type to be able to distinguish between the different sources involved (Orders and Sales in your case).

Something like this:

Fact:

Load 'Sales' As FactType,

     ReportingDate,

     CustomerNumber,

     ...

From Sales;

Concatenate (Fact)

Load 'Orders' As FactType,

     ReportingDate,

     CustomerNumber,

     ...

From Orders;

hth/gg

[#4]

I have measure in both the fact tables with same name. SO when doing analyis, I'll have to always set this filter, correct?

[#5]

Yes, you need to have filter for analysis. Alternativly you can change name of the second fact.

Regards,

Kiran.

[gandalfgray · Accepted solution]

Hi

Either that,

or you can keep the measures in separate fields, like: sales_amount, orders_amount etc.

/gg