Posted 3 August 2017, 4:01 pm ESTI am using the ASP.NET Pivot Viewer with an MDXDataSource and was wondering if it is possible to restrict the number of rows returned. Currently there is a warning that pops up when 1000 rows are returned and then it continues processing. Is it possible to stop processing after it hits 1000 rows and then return the results.
Restrict number of rows returned
Posted by: townie on 3 August 2017, 4:01 pm EST
Replied 3 August 2017, 4:01 pm ESTTownie,<br><br>ActiveAnalysis does not place a limit on the number of rows returned currently. The warning that pops up when 1000 rows are returned is because the default value of the <span id="pagetitle">WarningThreshold Property is set to 1000. </span><span id="pagetitle">This property places a limit on the number of display points</span><span id="pagetitle">, however you may modify the value of this property if you would like the pop up to be shown only after a specified number of rows have being processed.<br><br>You can get more information on this property here:<br>http://www.datadynamics.com/Help/ActiveAnalysis/GrapeCity.ActiveAnalysis.Windows.Forms~GrapeCity.ActiveAnalysis.Windows.Forms.PivotView~WarningThreshold.html<br></span><span id="pagetitle"><br>I would suggest you to go through the suggestions that are provided in this forum post on how you may keep your result values minimal.<br><br>Please let me know in case you would like me to enter a feature request case for limiting the number of rows returned.<br><br>Best Regards,<br>Abhishek</span><span id="pagetitle"><br></span>