Context Question

Hi all,
I was trying to include a new table to already existing universe.
This new table is a a common table between two already existing tables.
So I added two new contexts recommened by BO designer. andnow i’m trying to refresh a report which was already created with one select statement. but after adding this context it’s pulling few columns from different cube, now i have more than one select statement in my report. What is that I’m doing wrong. Please suggest.


koushik7777 (BOB member since 2004-07-05)

It doesn’t sound like you are doing much wrong.
Contexts are meant to generate separate select statements.
If you have a look at the SQL generated (via the query panel button) is it a join or synchronisation?

Review that all the joins in your universe belong to at least one context. Then review your contexts regarding which joins they include (pay attention to chasm/fan traps while doing that).


Andreas :de: (BOB member since 2002-06-20)

It’s a Scnycronization


koushik7777 (BOB member since 2004-07-05)

Then I would suggest doing what Andreas has advised.