Performace problem with xmla

From: Jochen Fischer (jochen.fischer_at_prosieben.de)
Date: 04/26/04 

Date: 26 Apr 2004 07:15:14 -0700

Hi,
i have a problem with an MDX statement using SOAP/XMLA.

When i send the MDX Statement to the olap server (sql2k) over the mdx
sample tool i get an answer in seconds. When i send the statment with
the xml sample over SOAP it takes 10 minutes.

Runing the xml sample, the iis process on the olap server have a cpu
usage of 50% (2 processors). On the System Monitor i see a huge File
Read Bytes/sec. It seems the server scan the disk.

Runing the mdx statement with the mdx sample tool there are no scan on
the disk. The System Monitor shows very small File Read Bytes/sec.

I noticed that 3 Measures are causing the problem. My Cube have one
min, one max and one avg measure additionally to other measures. The
query without these 3 measures are very quick. With both tools.

I don't understand why analysis services make a scan when i use the
SAOP Connection.

Does anybody know how I can improve the performance?

Thank you for any help,
Jochen