asked on December 15, 2021
Dear Team,
Experiencing delayed response on retrieving data for pivot report. On analyzing, from network tab, we saw multiple request going from FM. Around 10request calls raised per pivot report. We have 4 pivot report on a single angular component page, probably 40 requests are made internally from FM. Is there anyway to reduce call or make it asynchronus and increase performance of page?.
From pivot report setting to onReportComplete event, below list of calls are raised internally per pivotReport.
1. Handshaking
2. DiscoverDimensions
3. DiscoverHierarchies
4. DiscoverLevels
5. DiscoverMeasures
6. DiscoverKpis
7. DiscoverMembers
8. DiscoverMembers
9. DiscoverMembers
10. Execute
Let us know, how to reduce response time and increase page performance/responsiveness. This is very urgent as there is requirement for adding 2 more pivot report in the page to add the tally of 6 reports in a page
Note : Initial data is only few rows.
⋅ December 16, 2021
Hi Shahul,
Thank you for raising your support ticket.
Please note that this number of requests from the client-side is normal when connecting to your Analysis Services instance through the Flexmonster Accelerator.
In our previous communication, your colleagues mentioned that you're hosting your Analysis Services instance on Azure. If this is still the case, we'd like to reiterate that performance is often lower with AAS than with local Analysis Services instances because of the additional resources necessary to fetch the remote data.
That being said, we'd recommend selecting an Azure server in the closest region - this might help save time on the data transfer.
Another thing we can recommend is to increase the Accelerator cache size - this could improve the performance as well.
Please let us know if this helps.
Best regards,
Mykhailo
⋅ December 21, 2021
Hi Mykhailo,
We have given FM accelerator cache size of 1GB. So, there will be long delay for first call/initial data as it will be cached. Already Connected to nearest azure region in cloud. Still lagging is there. Let us know performance tuning solution.
⋅ December 22, 2021
Shahul,
Thank you for your response.
Since you've already configured the cache and ensured the nearest Azure Region is used, there is not much else we can suggest in terms of Azure. As I've mentioned in my previous response, Azure might be somewhat slow due to its specifics unrelated to Flexmonster – you might notice this even when connecting to AAS from MS Excel, for example.
While this might be a significant change in the infrastructure, we can also suggest using a self-hosted Microsoft Analysis Services instance instead of Azure. This approach would allow you to set up the Flexmonster Accelerator on the same machine where the Analysis Services instance is hosted, thus eliminating the remote data fetching delay.
Hope this helps!
Best regards,
Mykhailo
