Use of minus within subquery

building semantic layer
1

Hi Guys,

In our report requirement we have below scenario:

Select table1.A, table1.B, table2.c
from table1, (select table3.X from table3 
                                  MINUS
                   select table4.x from table4) table2
where table1.A=table2.X

So now we have 3 option to implement this in our report.

  1. Create derived table at universe level.
  2. Create custom query at report level.
  3. Can we use minus in subquery at report level.

chetan86 :india: (BOB member since 2011-01-18)

2

Hi chetan86,
Better you design the same on universe in derived table if your design is freezed.
The less no of rows you get from universe the report performance will be more better.

swap_l (BOB member since 2009-04-09)

3

Hi Swap,

I have used derived table at universe level and it is working finr.
Thanks…

chetan86 :india: (BOB member since 2011-01-18)