How to get number of rows from data set of query used in BI publisher report(OEM in subject & Header

Question

I am using BI publisher of OEM 13c cloud control to generate reports.

One of the report is to get shared accounts in our one of database but I want that number of rows whatsoever coming report , that num rows should be displayed in subject of email which sends this report and also in header of report i.e.

Banner_Shared_Account_Report-Numrows=12 (example)  ( rows are retrieved 12 in report from query used).

I checked oracle documentation  and found something about BURSTING but there are examples are of splitting data based on columns of tables used in query and then sending emails of reports.

How can I achieve this number of rows of a report in header and also in subject line of email sending report. ?

Abhilash K - Deloitte USI · Answer

I am not very sure on this with OEM 13c cloud, in ERP Cloud, you can create a global variable and get the count in the xml. And use the bursting query with your dataset query and fetch count using query and you would use in subject.

you can find a sample bursting query below

https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-B82CA941-977F-4EF6-91DC-BC9A70F56B93.htm

Let us know if this is of any help.

Best regards,

Abhilash