Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

3010666 · 2016-02-29 07:49:11

I have a Report in OBIEE which access a view table(The physical Layer) in Repository. The View table has access to one of physical table which is partitioned based on DISCOM or group namely 'MG,UG,DG and PG' But when the report runs instead of using table partition DISCOM wise it does a full table scan. It actually should…

How to force OBIEE Reports to use table partitions instead of Full Table Scan

Received Response

102

Views

Comments

Answers

3010666 Rank 2 - Community Beginner

Mar 29, 2016 3:26AM

Hi,

My physical table is partitioned based on region name like 'MG' , 'UG','DG' and 'PG'.

Kindly provide me some examples of how should i write the fragmentaion criteria either in BMM layer or Phycial layer?

Regards

Debyani

0

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

How to force OBIEE Reports to use table partitions instead of Full Table Scan

Answers