Drill through more than 7500 rows.

Options
Pablo Luis Rodriguez Longhi
Pablo Luis Rodriguez Longhi Customer
First Anniversary Advocate First Comment Photogenic
edited July 2022 in Platform
Hi, 
I have a trouble with drill through.
When the user make a big selection, specially under "Total", I received an error message like "The query returned too many rows." this happened when the query result is more than 7500 rows. In this case the most value is 27000 rows for one month.
I use this kind of query to run a lot of detail information not handle by normal board behavior.
Someone knows how to solve this?
image

------------------------------
Pablo Luis Rodriguez Longhi
Professional IT Business Process Analyst
IVAX ARGENTINA S.A.
Argentina
------------------------------

Accepted Answer

  • Björn Reuber
    Björn Reuber Employee
    Community Captain First Answer First Anniversary 5 Up Votes
    edited July 2022 Answer ✓
    Options
    Hello

    The limit on the maximum number of records supported on the drill through invocation can be customized. There is a parameter in the AdulaParams.xml (B10) or BoardEngineParams.xml (B12) file in the installation folder of the BOARD Engine. The parameter is the following: <DrillThroughCutOff>100000</DrillThroughCutOff>. By default is set to 10000. Changing this parameter requires the restart of the BOARD Engine during a maintenance window.


    Regards
    Björn

    ------------------------------
    Björn Reuber
    Support Team Manager
    Board Deutschland GmbH
    Germany
    ------------------------------
    -------------------------------------------

Answers

  • Pablo Luis Rodriguez Longhi
    Pablo Luis Rodriguez Longhi Customer
    First Anniversary Advocate First Comment Photogenic
    edited July 2022
    Options
    I changed the parameter and now it works fine!!
    Thanks Björn !!

    ------------------------------
    Pablo Luis Rodriguez Longhi
    Professional IT Business Process Analyst
    IVAX ARGENTINA S.A.
    Argentina
    ------------------------------
    -------------------------------------------

Categories