Skip to Content
0
Jun 06, 2018 at 03:28 AM

SAP BO IDT Universe Including Oracle Partition in From Clause

228 Views

Hi All,

Currently I am creating Webi reports on Oracle 12 DB which contains huge amount data.

So take advantage of Partion feature from performance perspective is it possible to add oracle Partition or Partition clause in Universe Generated SQL automatically.

For example, If I am having table called Sales can we configure UNX in cush a way the resultant query will be

SELECT * FROM sales PARTITION (nov98);