_DISPLAY_ACROSS_CELLS_ Method

Displays the values for the across dimension

Syntax

CALL SEND(OBJID,'_DISPLAY_ACROSS_CELLS_',column-list,actions-list, view-report-flag,
analysis-variable,statistic-variable, across-variable,url,argument-string,argument-string2,
initial-url,background-type,background-value,title, webeis-class,dlflag,service);

Required Arguments

column-list
the column list from the EMDDB_M class.
Type:Numeric
actions-list
the actions sublist for drill down.
Type:Numeric
view-report-flag
the flag for the View Report button.
Type:Numeric
analysis-variable
the analysis variable to graph.
Type:Character
statistic
the statistic to graph.
Type:Character
across-variable
the analysis variable for graphing.
Type:Character
url
the Application Broker component of the URL.
Type:Character
argument-string
the argument string for the next query.
Type:Character
argument-string2
the argument string for the next query.
Type:Character
initial-url
the URL of the initial HTML page. (This parameter is obsolete. It is included in the METHOD statement so that overrides are not broken.)
Type:Character
background-type
the optional background type (IMAGE or COLOR).
Type:Character
background-value
the optional background value.
Type:Character
title
the HTML page title.
Type:Character
webeis-class
the WEBEIS class name.
Type:Character
dlflag
a flag that indicates whether to download the table to a spreadsheet, where 0=output HTML tags with data values, and 1=output data values with spreadsheet delimiters.
Type:Numeric
service
the service name.
Type:Character

Details

This method
  • calls the _SET_ACTIVE_VALUE_ method of the EMDDB_M class
  • calls the _SET_ACTION_STATUS_ method of the EMDDB_M class
  • outputs the class values for the across dimension with <A> tags for drill down, if drill down is valid.

Example

emddbmid= instance(loadclass('SASHELP.WEBEIS.EMDDB_M.CLASS');
collist= makelist();
call send(emddbmid,'_GET_CLASS_COMBINATIONS_','COL',collist);
actionsl= makelist();
rc= insertc(actionsl,'',-1,'CL_DRILL');
vrflag= 1;
grphvar= 'Actual Sales';
grphstat= 'Sum';
grphacr= 'Month';
url= 'cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.MDDBRPTS.SCL&_SERVICE=
   default&_debug=&0GRT=BLOCK';
args= '&MDDB=SASUSER.SALES&METABASE=SASUSER.NEWMB&D=COUNTRY&AC=
   =MONTH&A0=2&A1=ACTUAL&A2=PREDICT';
args2= '&S0=2&S1=SUM&S2=AVG';
bgtype= 'COLOR';
bg= 'YELLOW';
title= '1996 Sales Reports';
webcls= 'SASHELP.WEBEIS.WEBEIS.CLASS';
dlflag=0;
service='DEFAULT';
call send(webid,'_DISPLAY_ACROSS_CELLS_',collist,actionsl,vrflag,grphvar,
   grphstat,grphacr,url,args,args2,' ',bgtype,bg,title,webcls,dlflag,service);
The following output is produced:
<TR>
<TH CLASS="COLLAB" COLSPAN=1>Month</TH>
<TH CLASS="COLLAB" COLSPAN=4>Jan</TH>
<TH CLASS="COLLAB" COLSPAN=4>Feb</TH>
<TH CLASS="COLLAB" COLSPAN=4>Mar</TH>
<TH CLASS="COLLAB" COLSPAN=4>Apr</TH>
<TH CLASS="COLLAB" COLSPAN=4>May</TH>
<TH CLASS="COLLAB" COLSPAN=4>Jun</TH>
<TH CLASS="COLLAB" COLSPAN=4>Jul</TH>
<TH CLASS="COLLAB" COLSPAN=4>Aug</TH>
<TH CLASS="COLLAB" COLSPAN=4>Sep</TH>
<TH CLASS="COLLAB" COLSPAN=4>Oct</TH>
<TH CLASS="COLLAB" COLSPAN=4>Nov</TH>
<TH CLASS="COLLAB" COLSPAN=4>Dec</TH>
<TH CLASS="TCOLLAB" COLSPAN=4>TOTAL</TH>
</TR>