MDX-Query execution performance in Smartview-Excel
Hello ,
_Info_________________________________________
Workspace-Version : 11.1.2.3.500.17
Oracle Hyperion Provider Services - 11.1.2.3.502.067
Oracle Hyperion Hyperion Auditing - 11.1.2.3.0
Oracle Hyperion Common Administration 11.1.2.3.0
Oracle Hyperion Common Security - 11.1.2.3.0
Oracle Hyperion Lifecycle Management - 11.1.2.3.0
Hyperion Common Install - 11.1.2.3.0.8719
Oracle HTTP Server - 11.1.1.7
Essbase Server - 11.1.2.3.0
____________________________________________
Our Problem is : MDX-Querys executed via Excel SmartView Add-in takes too long : >1h , where the same mdx-query executed in the EAS-Console
takes only about 3 minutes .
We want faster executing mdx-querys ,when Excel is the chosen client.
After the execution in EAS-Console (3min) the Request in Essbase is finished and the essbase-server idle.
So I installed MS Network Monitor on the machine where APS -Service resides, to monitor the traffic btw. APS-Service and Essbase during the