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);