Loop in context

[former_member266879]

Hi I have Ad hoc universe with table A,B,C,D, the join is A->B->C and A->D->C This join having loop.

A IS fact table

B is a Fact table

D is a fact table

C is a Dimension table

From table C we are using dimension object ,table C connected with Audit trial and other fact tables, so I can't create a alias on table C , based on business this object will create a query either with Audit fact and other facts etc...

Also when user crates a report from table A and C the join always should be A->B->C and A->D->C But it has a loop and I can't create a Alias on table C

Also I have context which is having join A->B->C and A->D->C

Please advise how to resolve this issue or can we have a loop in this universe since its having valid join(A->B->C and A->D->C)

Note:I can't create Alias in my current requirement and join would be (A->B->C and A->D->C)

Please help me

[former_member193452 · Accepted solution]

Each Fact table should be in a separate context. Separate aggregation is done on each fact table. All loops should be resolved (except is special cases) Loops are resolved by either alias or context. Mutlple sql for each measure and Multiple sql for each context may need to be enabled.

Regards,

Jacqueline