Problem with the context

[mur76]

Hi,

When I created a Universe, the loop was formed. To resolve the loop I used 2 contexts. When Iam running the report it is prompting which context to choose as a parameter..I can able to Understand which I need to choose...but, when the End user point of view, how this will works?
Any guess?

 

[skrandel]

That means your contexts are defined wrong. Each context should be defined by a fact table. BO only prompts for context when it can't figure out which one to choose.

Steve Krandel
VERITAS Software

 

[mur76]

Thanks.
But, we dont have fact tables in our schema..How to resolve the loops in this case?

 

[DrSmyth]

Have you tried using an alias for the destination table... This can simplify the whole thing...