Skip to main content
Previous section   Next section

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
Copy code to clipboard

See Also

Previous section   Next section