_CHECK_HIER_MEMBER_ Method

Checks to make sure that one dimension variable (member-var) is not a member of the hierarchy chosen for the other dimension variable (hierarchy-var)

Syntax

Details

Example

Syntax

CALL SEND(OBJID,'_CHECK_HIER_MEMBER_',metabase-id,error-flag, hierarchy-var,

member-var,message);

Required Arguments

metabase-id: the ID number of the metabase.

Type:Numeric

error-flag: an error flag, where 0=no error, and 1=error.

Type:Numeric

hierarchy-var: the hierarchy variable.

Type:Character

member-var: the member variable.

Type:Character

message: the error message to display.

Type:Character

Details

This method ensures that the variables users select to create a report are valid. For example, specifying DOWN=COUNTRY, ACROSS=GEOGRAPHIC produces an error if country is a member of the geographic hierarchy.

Example

mbid=instance(loadclass('SASHELP.MB.METABASE.CLASS'));
downvar='Geographic';
acrosvar='COUNTRY';
call send(webid,'_CHECK_HIER_MEMBER_',mbid,varerr,downvar,acrosvar,msg);