Contents MDDB Report Viewer Methods Previous Next

_CHECK_HIER_MEMBER_ Method

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

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.

Syntax

 CALL SEND(OBJID,'_CHECK_HIER_MEMBER_',metabase-id,error-flag,
                hierarchy-var,member-var,message);
Where... Is Type... And Contains...
metabase-id N the ID number of the metabase
error-flag N an error flag, where 0 = no error, and 1 = error
hierarchy-var C the hierarchy variable
member-var C the member variable
message C the error message that is to be displayed.

Example

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


Contents MDDB Report Viewer Methods Previous Next