MDDB Report Viewer 9.2

_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)

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);

Top of Page