Aakriti_5457
New Member
- Joined
- Jun 13, 2023
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I encountered following problem while performing a comparison activity of executing Excel Macro on OLAP cubes in KYVOS and SSAS, using Analysis Services Driver in Excel.
There is significant difference in Excel Macro report execution time between the KYVOS and SSAS cubes. Further investigation revealed that there are some gaps in the request flow from Excel when communicating with the KYVOS cube, which are not present when interacting with the SSAS cube using same report with Marco. I also examined the response size and number of requests, but it did not explain the observed time difference.
I am seeking guidance on which direction to explore in order to address this issue . I would appreciate any assistance or suggestions you can provide.
There is significant difference in Excel Macro report execution time between the KYVOS and SSAS cubes. Further investigation revealed that there are some gaps in the request flow from Excel when communicating with the KYVOS cube, which are not present when interacting with the SSAS cube using same report with Marco. I also examined the response size and number of requests, but it did not explain the observed time difference.
I am seeking guidance on which direction to explore in order to address this issue . I would appreciate any assistance or suggestions you can provide.