Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

when we scheduled the OTBI report in excel format recipient get missed(reduced file) count

Received Response
82
Views
4
Comments

Summary:

Hi Team,

when we scheduled the OTBI report in excel format recipient get missed count  like in report total count 38855 rows but after shcedule it will reduced .


Thanks,

Ajay


Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 6 - Analytics Lead

    Hi,

    Is that schedule being executed by the Recipient? if Yes, then it might be the security that's restricting the data.

    When you say the file is having 38K record who is executing that? Ideally ask the recipient to execute the report directly to see how many data they are getting.

    Hope this help.

    Cheers,

  • AjayKumar Maddipati
    AjayKumar Maddipati Rank 5 - Community Champion

    No, I'm the admin and I'm schedling the report to recipient

  • Swapnil Kashid
    Swapnil Kashid Rank 4 - Community Specialist

    Hi @AjayKumar Maddipati ,

    Could you please share more details in terms of report permissions screenshot and also the way you are trying to schedule the report.

    Also please check if there are any data access set restrictions or secured views being used.

    Regards,

    Swapnil

  • AjayKumar Maddipati
    AjayKumar Maddipati Rank 5 - Community Champion

    Hi@Swapnil Kashid ,

    actually I'm sceeduling to me even my side also this report missing the count

    I'm adaminstrator.