The OLAP Procedure

UNDEFINE Statement

Deletes from a SAS metadata repository one or more global calculated members or named sets. To delete multiple calculated members or named sets in a single UNDEFINE statement, use commas to separate instances of MEMBER | SET 'member-or-set-name'.

Syntax

UNDEFINE MEMBER | SET 'member-or-set-name' ;

Details

Required Arguments

MEMBER | SET: indicates whether you are deleting a global calculated member or a named set.

'member-or-set-name': specifies the name of the member or set that is to be deleted from the metadata repository. Cube names and dimension names are required for each member-or-set-name. Square brackets ([ ]) are optional inside the quotation marks of member-or-set-name, as shown in the preceding example.

Example

The following example shows how a single UNDEFINE statement can be used to delete from a metadata repository two calculated members and one named set.

proc olapl;
metasvr olpa_schema='Services Schema'
   repository='services'
   host='misdept.us.mar.com'
   port=9999
   userid=jjones
   pw='my password'
   ;
undefine member '[carsCube].[Measures].[avg]',
   member '[sales].[Measures].[stat1]',
   set '[campaign].[myset]'
   ;
run;