Query Limit in Financial Reports and Smart View
SummaryAnnouncement in balance query limit change and suggested configurations for Financial Reports and Smart View.
In the August 2016 patch bundle, there is now a limit on the number of cells you can query in Financial Reporting Studio reports, Smart View, and from General Ledger Account Monitor, Account Inspector and Inquire on Detail Balances pages.
We set the limit large enough so it should be able to return up to one million cells of information which should cover the vast majority of queries. If you are above the limit, you need to narrow your query.
For Smart View, you should no longer request changes to APS Max Rows/Columns settings as this is no longer applicable.