Oracle Analytics Cloud and Server

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

Scheduled Agent only returns 250 rows from a report with over 3k records.

Received Response
233
Views
9
Comments
User_XBGA6
User_XBGA6 Rank 2 - Community Beginner

Hi Everyone,

I have a scheduled agent that successfully runs but only pulls 250 records from an analysis of over 3k records and growing. I have tried having the Agent use a condition such that the analysis row count is 3k which returns True when I test but still doesn't attach all the data in an excel whenever the agent runs. I have tested the delivery content using both Dashboard Page options and Condition Analysis and they both send the same results. I am seeking expert help from anyone here so that I can get over this blocker. We use OBIEE 11g (11.1.1). Thank you.


Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ User_XBGA6 ,

    Welcome to the Oracle Analytics Online Forum!

    To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence. Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

    Refer below MOS doc -

    OBIEE 11g & 12c: How To Increase the Number of Rows Displayed in a Report in an Agent (Doc ID 1381801.1)

    Regards,

    Arjun

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ User_XBGA6 ,

    Support Identifier --> you may request/check with your sales team or Admin who can able to provide an access to oracle support portal access.

    The <DefaultRowsDisplayedInDelivery> parameter in instanceconfig.xml controls the number of rows to be delivered in an Agent. For example, to set the limit to 25000 rows, you would set the parameter as follows:

    <DefaultRowsDisplayedInDelivery>25000</DefaultRowsDisplayedInDelivery>

    Better to do at /em console level instead of file change.

    Regards,

    Arjun

  • User_XBGA6
    User_XBGA6 Rank 2 - Community Beginner

    Thank you for sharing critical information from the document. I will liaise with my Admin to get this Support Identifier so that I can have full access.

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @User_XBGA6 ,

    In addition to what has been suggested by @Mallikarjuna Kuppauru-Oracle , I would also check that the physical queries generated by the analysis and the agent are exactly the same.

    Moreover.. Since OBIEE 11g is really old and no longer supported, I highly recommend to migrate to the latest version of OAS, or OAC.

  • User_XBGA6
    User_XBGA6 Rank 2 - Community Beginner

    Thank you for your additional feedback @Federico Venturin. I'm not sure if I understand you correctly but I built this analysis from a subject area, added a date prompt to the dashboard alongside the analysis then tried to schedule it. I strongly believe the query to be the same. I'm 2 months into using OBIEE in a new role that I recently started. I previously worked with different BI tools so forgive me if I don't come across accurately. And yes, I already found discussions on moving to OAS/OAC so I am hoping that we do migrate soon. Cheers!

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @User_XBGA6 ,

    There is nothing to forgive! In OBIEE things could be more complex than they actually look, and I'm paranoid by default :)

    If you scheduled the dashboard page then the physical queries are expected to be the same (the agent will apply the default selections made in dashboard prompts). If you scheduled the analysis, then the agent allows you to manually select values for each is prompted filter (which could be different from the default selections in dashboard prompts).

    You should also take into consideration which user is running the dashboard page and the agent. If they are executed by different users and row-level security is in place, then they can potentially get a different result set.

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ User_XBGA6

    Any update on this Thread. If you think we have answered your quesiton, you may accept the answer so that other community user can refer the same.

    Regards

    Arjun

  • User_XBGA6
    User_XBGA6 Rank 2 - Community Beginner
    edited December 2023

    Hi @Mallikarjuna Kuppauru-Oracle. My IT Admin couldn't get me the Support Identifier. I, however, used the other option of changing the <DefaultRowsDisplayedInDelivery> parameter in instanceconfig.xml controls which still didn't work for us. I appreciate your valuable help, nevertheless. I just wish that I had access to the document you shared. We resolved to have the report sent out to group emails manually by exporting the report weekly in the meantime.

    Thank you.

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    I see you are using 11.1.1.* ( maybe 11.1.1.9)

    • Please check the session log of the analysis execution through the Agent and see how many records have been fetched. You can check if there is a RUN AS used in the General configuration of the agent.
    • If the same user runs the same session, we assume that the records retrieved is 3000?
    • Check if there are any configuration set to 250 for obips and in the Enterprise Manager Console -> BI Home application -> Capacity Management .