Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext 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