Skip to main content

DROP MEMBER Statement (MDX)

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

See Also

FeedbackOpens in a new tab