I am working on BO XIR3.1. i want to know about the query performance between 2 scenario -
1) i have 4 dim obj with aggregate object in single query so all 4 object come under group by i have created 4 table in report with individual object & aggregate table and need to show group by with dim object into each table.
2) i am creating 4 dataprovider with individual dim object and agg. obj.
When data will grow can be million records as per performace wise which scenario will work fast.