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.
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).