I'm trying to create link tables to avoid the circular references. I have read this article: http://www.quickqlearqool.nl/?p=910
I have Fact1 and Fact2 loaded as aggregations by ProjectCode, Year and Month. Projects and Time (Year and Month) are the dimensions. For Fact1 and Fact2 the key field is the set of ProjectCode, Year and Month. I have followed the example in the article and it doesn't function. I think that I create a key field for each Fact table and I don't renaming the dimension fields in the link table.
In this manner, the link table doesn't function:
LOAD DISTINCT ProjectCode as ProjCode_Lnk, Year as Year_Lnk, Month as Month_Lnk RESIDENT Fact1
LOAD DISTINCT ProjectCode as ProjCode_Lnk, Year as Year_Lnk, Month as Month_Lnk RESIDENT Fact2
Does anyone use the link tables? Thanks