I am using Office Web Components PivotTable interface to connect SSAS 2005 Cube with OLEDB Provider 9.0 over HTTP. I set the CommandText attribute of PivotTable to run a MDX query and display the result.
During the execution of the report, I saw lots of HTTP traffic between OWC client and msmdpump.dll that consist of requests of type
DISCOVER_PROPERTIES and MDSCHEMA_MEMBERS. The requests continue even after the report is displayed.
I tried changing connectionString value according to the link below. It did not work.
The DISCOVER events that you see are actually requests for data from the OWC PivotTable.
For example, as you navigate a dimensional hierarchy and drill down to a lower level, the client needs to get data for the members of the hierarchy that are under the currently selected member. That action results in the OWC client issuing a DISCOVER request
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.