hi,

[Former Member]

5 fact tables and 5 dimension tables in universe,one fact table is connected with other 5 dimension tables that all are joined how can i resolve loop in this case?

[CdnConnection · Accepted solution]

Raja,

    Without see the tables structure it's hard to say but one the best rules to follow is ONE Context for ONE Fact table.

Any visual attachment would help.

Regards,

Ajay\

[Former Member · Accepted solution]

Hi,Ajay,

Thanks for reply.

[vijaymuniraj]

Hi

Create 5 context with all dimensions. For ex:-

Context 1 = fact table 1 + 5 dimension

Context 2 = fact table 2 + 5 dimension

Context 3 = fact table 3 + 5 dimension

Context 4 = fact table 4 + 5 dimension

Context 5 = fact table 5 + 5 dimension

Give some meaningful name for each context based on fact table.