nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How to calculate the amount of data in the summary ?

Vitalii_Alliance_dgtl

Hello everybody)

I send the report via bursting to the mail. Is it possible to include as many lines in the file as possible in the message? Can we count such a number?

Find more posts tagged with

BI Publisher

BI Publisher Data Models

BI Publisher Report Templates

Accepted answers

Mallikarjuna Kuppauru-Oracle

Hi @Vitalii_Alliance_dgtl

As per your update, you can write an Data model query for summary calculation or try before/after triggers .

If you think i have answered your question, you can mark as Answered and close this Thread.

Regards

Arjun

All comments

Mallikarjuna Kuppauru-Oracle

Hi @Vitalii_Alliance_dgtl

can you provide more details about your quesiton?

Regards,

Arjun

Vitalii_Alliance_dgtl

https://community.oracle.com/products/oracleanalytics/discussion/comment/52924#Comment_52924

I create a report in excel and send it using bursting. Is it possible to count the number of rows in the report? if you look at the logs, the number of formed lines is stored there, is it possible to somehow put them in a letter or in an attachment of a letter? is it possible to somehow write this quantity into a variable and then use it?

Mallikarjuna Kuppauru-Oracle

Hi @Vitalii_Alliance_dgtl

As per your update, you can write an Data model query for summary calculation or try before/after triggers .

If you think i have answered your question, you can mark as Answered and close this Thread.

Regards

Arjun

Top Leaders

MandeepGupta 70

RVohra 50

Ngoc Phung 45

Mallikarjuna Kuppauru-Oracle 35

Nilesh Kumar Mal-Oracle 30

Top Questions

Scheduled report in BI Publisher 12c returns garbled excel output
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that have excel templates to run, their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
OIC SOAP Connection — OAuth Authentication Fails Intermittently
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM - what is the size limitation for oracle BI Publisher rtf template?
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
BIP Report for Assignment Transactional History Detail Report
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…
How to generate a CSV file with headers only ?
Hello Team, I am generating a BI Publisher report scheduled through an ESS Job with the output format as CSV. When the report returns no data, I need the output file to contain only the column headers. However, the generated CSV contains the headers followed by an additional first data line with delimiters only, which is…