Restricting no of rows to be fetched in mashup - app.visualization.create('table',
Need help to find standard methods of restricting no of rows in app.visualization.create('table', its causing 100% memory and CPU utilization for one of the customer when fact table rows are > 30 M.
One way is to use calculation condition to limit rows for visualization, its not desirable to force user to limit the data and export also causing the same issue when app.createTable is used along with table.exportData. We want to define a limit, could be any hardcoed no lets say 500K for viewing and export.
Any kind of help is much appreciated. Thanks in advance.
Hi erik.wetterberg Thanks for your reply. We tried specifying qInitialDataFetch. It looks like the hypercube response has only specified number of rows, but we see subsequent GetHyperCubeData calls, which fetches all the rows and columns irrespective of qInitialDataFetch. Any thoughts/suggestions on this is highly appreciated? Below are few snapshots.