| |
MDDB Report Viewer Variables
The MDDB Report Viewer uses macro variables that are set by users and passed into the
viewer when the application executes. Table 1 lists and describes the macro variables.
The MDDB Report Viewer also uses "global" variables that you can set in the RESET.SAS file that is used by your
application server. Table 2 lists and describes these variables.
| Variable Name |
Description |
Details |
|---|
| MDDB |
Selected MDDB |
Selected MDDB (for example, SASHELP.PRDMDDB) |
| METABASE |
Selected metabase |
Selected metabase (for example, SASHELP.MBEIS) |
| D |
Down |
Hierarchies and Category Variables |
| AC |
Across |
Hierarchies and Category Variables |
| A |
Analysis Variable |
Analysis Variable |
| S |
Statistic |
Statistic |
| SV |
Filter Variables |
Category Variables to filter by |
| SL |
Filter Variable Values |
Values to filter by (for example, SL=COUNTRY:CANADA) |
| EX |
Expand Values |
for example, EX=COUNTRY=CANADA |
| V |
Down dimension drilldown values |
for example, V=YEAR=1995 |
| VA |
Across dimension drilldown values |
for example, VA=PRODTYPE=FURNITURE |
| ST |
Display Table |
1=yes, 2=no |
| DT |
Default Title |
Max length=200 |
| DP |
Show drillpath in title |
1=yes, 2=no |
| DC |
Show down totals |
1=yes |
| ACB |
Show across totals |
1=yes |
| GSC |
Graph Source |
1=3D Clickable Graph, 2=Standard GIF Graph(SAS/GRAPH) |
| GL |
Graph Location |
1=bottom, 2=top, 3=left, 4=right |
| GRT |
Graph Type |
BLOCK, HBAR, PIE, PLOT, VBAR |
| GW |
Graph Width |
default=600, max length=4 |
| GH |
Graph Height |
default=450, max length=4 |
| SSL |
Filter list box location |
1=right, 2=left, 3=top, 4=bottom |
| SW |
Filter list box width |
default=15 |
| SH |
Filter list box height |
default=3 |
| VIEW |
View Report button |
value=View Report |
| GD |
Graph Down variable |
Category variable for graphing |
| GA |
Graph Across variable |
Across variable for filtering graph values |
| GG |
Graph Group variable |
Graph group-by variable, second innermost down variable |
| GSG |
Graph Subgroup variable |
Graph subgroup-by variable, third innermost down variable |
| SD |
Down variable |
Same as D, needed for Filter FORM |
| SAC |
Across variable |
Same as AC, needed for Filter FORM |
| CLASS |
WEBEIS class name |
For subclassing, default is SASHELP.WEBEIS.WEBEIS.CLASS |
| CSS |
Stylesheet URL |
Applies to variable selection and report pages. |
| CSST |
Toolbar Stylesheet URL |
Applies to toolbar frame. If not specified then uses CSS value. |
| Variable Name |
Description |
Details |
|---|
| VMDOFF |
Turn VERIFYMD checking off |
Any non-blank character turns it off, default is on. |
| _GRFONT |
Standard GIF Graph font |
SWISSB is the default, use SAS font names. |
| _MRVHELP |
URL of help file |
The default is the Hints and Tips page - http://support.sas.com/rnd/web/intrnet/mddbapp/hinttips.html |
| _MRTBLOC |
Toolbar location |
1=top, 2=bottom, 3=left, 4=right, 5=none, default is top |
| _MRVSEP |
Download to spreadsheet delimiter |
A comma is the default |
| _MRVTBSC |
Toolbar frame scrolling |
NO or blank indicates no scrolling, YES adds scrollbar to frame |
| _MRVANAL |
Display analysis variables in list box on report |
Non-blank value=don't display list boxes in report |
| _MRVSTAT |
Display statistics in list box on report |
Non-blank value=don't display list boxes in report |
| _MRVTBSZ |
Toolbar size in pixels |
Character string of form (horiz, vert), default is (50, 125) |
|
