Drill through more than 7500 rows.

Pablo Luis Rodriguez Longhi

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?


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

Björn Reuber

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
------------------------------
-------------------------------------------

Pablo Luis Rodriguez Longhi

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
------------------------------
-------------------------------------------