Dear all,
I have the following challenge in Application Studio (V11):
A report is retrieving projects depending on some filters set (status, customer number, description etc). Works well, but if the report is executed with all filters set to top level element, it will retrieve all projects and result in about 8.000 lines by 15 columns. The lines are created by an olap-list with various filters.
In AppStudio fat client the report is anyway quite fast, as the windows client only calculates the visible area. However, when running this report in WebServices or Dashboards it takes a while (about 3 minutes) until the report is displayed, which is probably because the web-instance has to calculate and render the whole report before the browser (new Edge or Chrome) can display it. No surprise: When looking at the task manager the w3wp-process consumes 1 GB+ of memory. Also the excel export is no longer working well and neither the row/column fixing does when the report becomes so big.
What I would like to have is a kind of paging mechanism, so that only e.g. 100 lines are displayed in the web reports, and the user can page through the whole list like in Google search.
Does anybody has any idea or experience if this is possible? May be using custom MDX?
Thanks for any tip and have a nice and sunny weekend,
Ralf
