C
Chris Magoun
Greetings,
I am trying to get my OWC10 or 11 pivot table to access data in an OLAP cube
via HTTP. Our system takes a series of user choices and stores them in an
XML document. This, and a second XML document containing the basic layout of
the desired report are sent to the client. A client-side OCX takes these XML
docs and manipulates the pivot table's object model to format the report as
per the user's wishes. It works great... and a standard query comes back
formatted in 10 seconds or so.
Until I switch to an HTTP connection. At this point, the query takes
something close to 3 hours. While I expected a drop in performance, I did
not expect THAT drop in performance. Can anyone give me some idea of what I
should look at to start troubleshooting this problem? The query in question
makes use of quite a few dimensions, and lots of custom groups. I am using
Execution Location = 3 to execute on the server. Any tips would be
appreciated. If you require more information from me, I would be happy to
provide it.
Chris Magoun
I am trying to get my OWC10 or 11 pivot table to access data in an OLAP cube
via HTTP. Our system takes a series of user choices and stores them in an
XML document. This, and a second XML document containing the basic layout of
the desired report are sent to the client. A client-side OCX takes these XML
docs and manipulates the pivot table's object model to format the report as
per the user's wishes. It works great... and a standard query comes back
formatted in 10 seconds or so.
Until I switch to an HTTP connection. At this point, the query takes
something close to 3 hours. While I expected a drop in performance, I did
not expect THAT drop in performance. Can anyone give me some idea of what I
should look at to start troubleshooting this problem? The query in question
makes use of quite a few dimensions, and lots of custom groups. I am using
Execution Location = 3 to execute on the server. Any tips would be
appreciated. If you require more information from me, I would be happy to
provide it.
Chris Magoun