Increasing the Limit for Observations from Data Sources

SAS BI Dashboard supports up to 10,000 observations when it displays results in response to queries. If your users use data sources that exceed 10,000 observations, they are presented with an error message. You can increase the number of observations that are allowed in queries. This is done by adding the maxRowCount parameter to the appropriate .dsx file, and specifying a higher value for the number of observations that are allowed for data sources. Typically, the value that you specify should exceed the total number of observations that are returned by data sources at your site.

SAS BI Dashboard is designed to work with data that is ready for reports. When you use the maxRowCount to specify a higher limit for observations, SAS strongly recommends that you prepare your data sources before allowing users to access them from SAS BI Dashboard. For example, you might perform aggregations and calculations that help prepare the data for reports.

For more information about modifying a .dsx file and enabling the changes to effect, see Working with Data Source XML (.dsx) Files.

You can add the maxRowCount parameter and a value to the following .dsx files:

Here is an example from the infomap.dsx file where the maxRowCount parameter has been added with a value that specifies a maximum limit of 25,000 observations:

<DataSourceDef id="infomap"
providerClass="com.sas.bi.dashboard.provider.InfoMapProvider
maxRowCount="25000">