DROP MEMBER Statement

Analysis Services Programming

Analysis Services Programming

DROP MEMBER Statement

This statement deletes a calculated member that has been defined for the session.

BNF

<drop-member-statement> ::= DROP MEMBER <cube-name>.<fully-qualified-member-name>

Example

The following example drops a named set created by the first example in CREATE MEMBER Statement:

DROP MEMBER [Warehouse].[Measures].[warehouseprofit]