DROP SET for non-session sets?

#1

Hi,

The documentation for Analysis Services states that the DROP SET statement
is used to delete named sets which have been defined for the session.

Is there a command which will delete a named set which has been defined as
part of the cube?

Thanks,

Peter

#2

You will need to use DSO. Named Sets are implemented as a Command in the Commands collection of the clsCube object. See Books Online for more info.

Regards
Jamie

"Peter Kenyon" wrote:

Quote:

Hi,

The documentation for Analysis Services states that the DROP SET statement
is used to delete named sets which have been defined for the session.

Is there a command which will delete a named set which has been defined as
part of the cube?

Thanks,

Peter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DROP SET for non-session sets?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

DROP SET for non-session sets? - 07-21-2004 , 08:34 PM

RE: DROP SET for non-session sets? - 07-22-2004 , 02:42 AM