How do I view the HTML output of a Oracle BI Publisher report with 700 thousand rows?

Ngoc Phung

Hi everyone,

I'm currently using BI Publisher embedded in Oracle Analytics Server 2024. I have a report that uses 2 parameters: P_BRANCHES and P_DATE
For P_BRANCHES = 'ALL' (all the branches), the report will return all the values for the column BRANCH_NAME and the remaining columns, which is 700 thousand rows plus in total.

The rtf template of this report was made by BI Publisher Desktop in Words and the template uses GROUP BY BRANCH_NAME (in Table Wizard), then the sum for each column of each BRANCH_NAME is calculated in a row at the end of every BRANCH_NAME.

The sheer amount of rows and the calculation of each BRANCH_NAME make the report run extremely slowly if someone chooses P_BRANCHES = 'ALL'.
I was able to export the .xlsx file in about 20 minutes and the file was 49,8 MB, but the HTML output took forever to run.

Is there any practical way for me to make the report run faster when I choose P_BRANCHES = 'ALL' and HTML as the output? If not, please suggest a different approach to fetch the output for the case P_BRANCHES = 'ALL' faster.