Hyperion Essbase (MOSC)

MOSC Banner

MDX-Query execution performance in Smartview-Excel

edited Jun 26, 2015 10:01AM in Hyperion Essbase (MOSC) 3 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center