Context Setup

building semantic layer
1

Hi All,

I know this problem was beaten to death,but i still couldn’t find a solution to this.

I have a universe that has many contexts.But there are two contexts in particular that need attention.

Context 1 : A-B-C-D
Context 2 : A-B-C-D-E-F-G

Now, my reporting requirements are asking for reports that involve the tables A-B-C-D.So, the context dialog box is popping up for the users to choose. don’t know how to resolve this issue. Please help.

Thanks!
Rajani

rajani (BOB member since 2005-10-18)

2

as long as your query is limited to A-B-C-D you should not be prompted for context selection as the query will be exactly same for either of the contexts.
Whats your Universe parameters ? I tried at my end… am not getting the prompt to select a context…

sbhusan :canada: (BOB member since 2006-06-26)

3

There is a special parameter that can be added to your universe in this case. It’s supposed to negate the prompt for the context if the SQL would be the same in any case, meaning no matter which context is selected. See if your universe has a parameter COMPARE_CONTEXTS_WITH_JOINS and what the value is, and if not, try adding it and setting it to Yes.

On the other hand, why have the ABCD context at all? It is contained within the ABCDEFG context and therefore not necessary.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

Thanks Dave! I remember having seen it set to Yes.I’ll take another look tomorrow.

Actually,context 1 has other tables which are not in Context 2. I just mentioned it to explain my predicament.

But if we have this situation,how should we deal with it?
I have been hearing all the time that they shouldn’t be built that way,but what if the business is like that?

Thanks for all the help!

rajani (BOB member since 2005-10-18)