Controlling about communication between PivotTable and Analysis Services.

[Ixabre]

Hi friends, We've got a Cube build on Analisys Service SQL SERVER 2005
and a Pivot Table that is on a .Net Client. Our trouble is that we want
to control when Pivot Table communicates with Analisys Services,
avoiding to the user to wait a long time. We have look through
BeforeQuery Event, but we don´t know how cancel the process, is there
a way?. Our target is that user put his filters on Pivot Table and,
when he wants, press button to update and the pivot table go to server
to bring our information.

Thanks in advance.

David

 

[Alvin Bruney [MVP]]

In that case, you will simply need to map an event to the click, open an MDX
connection and fire the query. There is no need to cancel anything. You may
need to use the datasource control in OWC to make this possible.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


Hi friends, We've got a Cube build on Analisys Service SQL SERVER 2005
and a Pivot Table that is on a .Net Client. Our trouble is that we want
to control when Pivot Table communicates with Analisys Services,
avoiding to the user to wait a long time. We have look through
BeforeQuery Event, but we don´t know how cancel the process, is there
a way?. Our target is that user put his filters on Pivot Table and,
when he wants, press button to update and the pivot table go to server
to bring our information.

Thanks in advance.

David

 

[Ixabre]

Hi Alvin, in first place thank you for you kind answering, we're
driving crazy with this problem because we haven't found much
information about it. Could you give us a little code example about
your solution?, We're using OWC PivotTable CommandText property for
fire MDX sentence, is there another way to do the same?, Forgot cancel
the communication. After the first query MDX, where I show to user the
initial data, How can I disconnect Pivot Table from Analysys Service in
order to not go to server everytime i add a filter, or everytime I
expand x level?.

Thanks in advance and sorry for sore you..

Ixabre

Alvin Bruney [MVP] ha escrito: