Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to get number of rows from data set of query used in BI publisher report(OEM in subject & Header
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. ?
Answers
-
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
Let us know if this is of any help.
Best regards,
Abhilash
0
