Multiple selects generated from simple aliased relations

I created a rather simple class composed of 3 table aliases. When I select an object from each table to report on , BO creates three separate select statements, one for each table, rather one select statement with the three objects in it. Does anyione know why this happens and how to prevent it?


Listserv Archives (BOB member since 2002-06-25)

Edward,since you have created 3 different aliases of the same table which will be joined to some common dimension tables , you can try out any one of these :
a) In your Universe properties check the check-box saying ‘allow multiple context for a single measure’ ;
b) Include joins between all three alias tables and some dimension(if applicable) in a single context ;
and last but not least never use the 3 objects (coming from different aliases)together … :slight_smile:


Listserv Archives (BOB member since 2002-06-25)