Skip to Content

Loop in context

Oct 16, 2017 at 03:31 AM


avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jacqueline Rahn
Oct 18, 2017 at 03:50 PM

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.



10 |10000 characters needed characters left characters exceeded