Limit (Warn) Users while Changing Pivot Table Layout

[erdal akbulut]

Hi,

I have an application which use OWC 10 and SQL Server Analysis Services
2000.
I have would like to give users to ability of changing layout but I also
want to warn them if they try to remove parent level from view. For example
I have a Product Dimension (Product Family, Product Group, Product Class,
................ Product No) The lowest level has 50000 members. Users can
drilldown to the lowest level and then remove parent levels which means they
can try to download 50000 Product Numbers and this will be a problem over
slow connections.

How can I handle to catch if user add/remove a specific level from Pivot
Table? or Is there any other method limiting maximum members for a
dimension send to the client in server side?

Thanks in advance

erdal

 

[erdal akbulut]

re-post to my original question. I think I can find something.

On PivotTable_BeforeQuery event I added some code which checks field using
..IsIncluded and decide wheter continue or to show a message to the user.