DROP MEMBER Statement

DeepSee MDX Reference

[Home] [Back] [Next]

InterSystems: The power behind what matters

InterSystems DeepSee > DeepSee MDX Reference > MDX Statements and Clauses > DROP MEMBER Statement

Class Reference

Search:

Removes a calculated member defined earlier in the current session.

Syntax and Details

DROP MEMBER cube_name.calculated_member_expression

cube_name is the name of the cube to which you are adding this member.
calculated_member_expression is an expression that refers to a member. Typically, calculated_member_expression has the form MEASURES.new_measure_name.

When you use the MDX shell, a session is started; the session ends when you exit the shell. During this session, if you use the CREATE MEMBER statement, the member that you create is available until the session ends or until you use the DROP MEMBER statement.

Example

>>DROP MEMBER patients.MEASURES.avgscore
 
---------------------------------------------------------------------------
Elapsed time:       .011952s