Dear Friends,
We are using BI7.00. For one of our reports, we load data to the ODS which contains 578068 records, When the respective query is executed, it takes long time to provide the output. I do not have any formulas in the query.
Can experts provide step by step solution to improve the query performance so that the output is fast.
Regards,
M.M