The OLAP Procedure

UNDEFINE Statement

The UNDEFINE statement deletes from a SAS metadata repository one or more global calculated members or named sets.

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

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'.

For additional information on calculated members and named sets, see DEFINE Statement.

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;

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.

Top of Page