DROP MEMBER Statement
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
