Contents MDDB Report Viewer Methods Previous Next
 

_DISPLAY_VALUES_ Method

Outputs the numerical values to the report table. This method performs the following tasks:

  • Calls the _GET_DATA_ATTR_ method of the METABASE class to get the base table name for reachthru.

  • Calls the _GET_EXPANDABLE_CLASS_ method of the data model to get the expand variable.

  • Calls emddb_m _SET_ACTIVE_VALUE_.

  • Calls emddb_m _SET_ACTION_STATUS_ to validate drilldown.

  • Outputs the class value for the current row.

  • Outputs an <A> tag if drilldown is valid.

  • Outputs the expand link if the expand is valid.

  • Outputs the collapse link if the collapse is valid.

  • Calls emddb_m _GET_VALUES_ to get the numerical value of the current statistic/analysis pair.

  • Calls _GET_ANALYSIS_VAR_NAME_.

  • Calls metabase _GET_VAR_ATTR_ to get the variable attributes.

  • Calls _GET_RANGE_COLOR_ if a range is applied.

  • Calls emddb_m _GET_CLASS_FORMAT_.

  • Outputs the numerical value to a table cell.

  • Calls _OUTPUT_REACHTHRU_LINK_ if the reachthru to detail is valid.

  • Outputs the closing HTML table tag.

Syntax 

 CALL SEND(OBJID,'_DISPLAY_VALUES_',row-list,column-list,
          actions-list,metabase-id,viewreport-flag,_url,_argument-string,
          _argument-string2,initial-url,analysis-variable,statistic-variable,
          across-varible,background-type,background-value,title,webcls,dlflag);

Where... Is Type... And Contains...
row-list N Row list from _emddb_m
column-list N Column list from _emddb_m
actions-list N Actions sublist that determines drilldown
metabase-id N Metabase id number
viewreport-flag N View report button flag
_url C URL of the next query
_argument-string C Argument string for the next query
_argument-string2 C Argument string for the next query
initial-url C URL of the initial HTML page
analysis-variable C Analysis variable to be graphed
statistic-variable C Statistic to be graphed
across-variable N Analysis variable for graphing
background-type C Optional background type (IMAGE or COLOR)
background-value C Optional background value
title C The HTML page title
webcls C The WEBEIS class name
dlflag N A flag that indicates whether to download the table to a spreadsheet where 0 = output HTML tags with data values; 1 = output data values with spreadsheet delimiters

Example 

rowlist=makelist();                                                           
call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','ROW',rowlist);                
collist=makelist();                                                           
call send(emddbmid_,'_GET_CLASS_COMBINATIONS_','COL',collist); 
actionsl=makelist();                                                          
rc=insertc(actionsl,'',-1,'CL_DRILL');      
mbid=instance(loadclass('SASHELP.MB.METABASE'));
vrflag=1;
_url='/cgi-bin/broker?_PROGRAM=sashelp.webeis.mddbrpts.scl&_SERVICE=default
&_DEBUG=0&RPTTYPE=2&GRTYPE=BLOCK';
_args='&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&DOWN=Geographic&ACROSS
=Product+Line&A=ACTUAL';
_args2='&S=SUM';
grphvar='';
grphstat='';
grphacr='PRODTYPE';
bgtype='color';
bg='yellow';
title='';
webcls='SASHELP.WEBEIS.WEBEIS';
dlflag=0;
call send(_self_,'_DISPLAY_VALUES_',rowlist,collist,actionsl,mbid,vrflag,
          _url,_args,_args2,mddblink,grphvar,grphstat,grphacr,
          bgtype,bg,title,webcls,dlflag);
The following output is produced: 
<TR><TH CLASS="rowlab"  NOWRAP ROWSPAN=1 COLSPAN=1>
<A HREF="" onClick="this.href=clsurl('V11=COUNTRY=CANADA&V10=1
&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">CANADA</A>
</TH>
<TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS
&D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=CANADA&DC=1&ACB=1&ST=1&GL=1&GSC=1
&SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic
&PAC=Product%2BLine&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="tdcell"  BGCOLOR=#008000><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank">     $97,864</A></TD>
<TD CLASS="tdcell"  BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank">    $149,126</A></TD>
<TD CLASS="tcolcell"  BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DCANADA')" TARGET="_blank">    $246,990</A></TD>
<TR><TH CLASS="rowlab"  NOWRAP ROWSPAN=1 COLSPAN=1>
<A HREF="" onClick="this.href=clsurl
('V11=COUNTRY=GERMANY&V10=1&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">GERMANY</A>
</TH>
<TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS
&D=Geographic&AC=Product%20Line&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=GERMANY&DC=1&ACB=1&ST=1&GL=1&GSC=1
&SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine
&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="tdcell"  BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank">    $101,194</A></TD>
<TD CLASS="tdcell"  BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank">    $144,804</A></TD>
<TD CLASS="tcolcell"  BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DGERMANY')" TARGET="_blank">    $245,998</A></TD>
<TR><TH CLASS="rowlab"  NOWRAP ROWSPAN=1 COLSPAN=1>
<A HREF="" onClick="this.href=clsurl('V11=COUNTRY=U.S.A.&V10=1
&_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL')" TARGET="_top">U.S.A.</A>
</TH>
<TH CLASS="rowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE
&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&D=Geographic&AC=Product%20Line
&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=U.S.A.&DC=1&ACB=1&ST=1&GL=1&GSC=1&SSL=1
&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine
&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="tdcell"  BGCOLOR=#008000><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DU.S.A.&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank">     $91,567</A></TD>
<TD CLASS="tdcell"  BGCOLOR=#00FFFF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DU.S.A.&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank">    $145,782</A></TD>
<TD CLASS="tcolcell"  BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl
('_WHERE=COUNTRY%3DU.S.A.')" TARGET="_blank">    $237,349</A></TD>
<TR><TH CLASS="trowlab"  ROWSPAN=1 COLSPAN=1>TOTAL</TH>
<TH CLASS="trowlab" COLSPAN=1 ROWSPAN=1>
<A HREF="/cgi-bin/broker?_PROGRAM=SASHELP.WEBEIS.OPFRAME.SCL&_SERVICE=default
&_DEBUG=0&GRT=NONE
&MDDB=SASHELP.PRDMDDB&METABASE=SASHELP.MBEIS&D=Geographic
&AC=Product%20Line&A=ACTUAL&S=SUM
&EX=1&EX=COUNTRY=TOTAL&DC=1&ACB=1&ST=1&GL=1&GSC=1
&SSL=1&SH=3&SW=15&GH=450&GW=600&DP=1&PD=Geographic&PAC=Product%2BLine
&BGTYPE=color&BG=%23FFFFE7" TARGET="_top">
<IMG SRC="/myimages/images/expand.gif" BORDER=0 ALT="Expand"></A></TH>
<TD CLASS="trowcell"  BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl
('_WHERE=&_WHERE=PRODTYPE%3DFURNITURE')" TARGET="_blank">    $290,625</A></TD>
<TD CLASS="trowcell"  BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl
('_WHERE=&_WHERE=PRODTYPE%3DOFFICE')" TARGET="_blank">    $439,712</A></TD>
<TD CLASS="trowcell"  BGCOLOR=#0000FF><A HREF="" onClick="this.href=rturl
('_WHERE=')" TARGET="_blank">    $730,337</A></TD>
</TR></TABLE><BR><BR>

Contents MDDB Report Viewer Methods Previous Next