Derived tables are not real tables at the Database level , but are the selection of few columns in the Table with some aggregations, specific to the report.
This feature is available in BO 6.5 and later versions.
Sel a1,a2,a3,max(a4) from a , (Sel b1, b2, max(b3) as B3, Min(B4) as B4 from B group by b1,b2) as BX where BX.B1= a.a1
group by a1,a2,a3
order by a1,a2,a3
The (Sel b1, b2, max(b3) as B3, Min(B4) as B4 from B group by b1,b2) in the above query is a derived table.
The same definition has to be added in the Universe - by going into Insert >> Derived Tables.
Type the Query - parse it and the new table inserted can be used to any type of join / Contexts etc in the Universe. |
