Multiple contexts issue
I am using Bo XI R3.1. I've 3 classes in universe people Details, Project status Report, project Details. Also based on this classes 3 contexts has been created which are project_status, people and project and joins which belong to these classes has been added in three of this contexts. Now if objects has been taken from different classes (which are based on different contexts) in webi rich client report it is showing as synchronization with two select statements. The display of data is in two tables but there some empty columns. There are no measure objects used in universe. I've gone through the queries based on this issue in this forum but didn't understand.
The option multiple sql statement for each context is also checked under parameters.
I would like to know
If the data coming is correct or not
If we can display all the columns in one table (single query instead of two queries)
Please advise the solution in detail.
Thanks in advance.