MDDB Report Viewer 9.2

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 REQUEST INIT program that is used by your application server. Table 2 lists and describes these variables. For more information on the REQUEST INIT program, see PROC APPSRV, REQUEST Statement syntax.

Table 1. MDDB Report Viewer Macro Variables

Variable Name	Description	Details
MDDB	Selected MDDB	Selected MDDB (for example, SASHELP.PRDMDDB)
METABASE	Selected metabase	Selected metabase (for example, SASHELP.MBEIS)
SR	First row to display in the table
NR	Number of rows to display in the table
D	Down	Hierarchies and category variables. Do not create variable names that contain an embedded percent sign (`%`) if the percent sign precedes the following characters: `0` through `9`, `a` through `f`, and `A` through `F`. Names that contain these character combinations could be misinterpreted due to encoding and decoding issues. For example, a variable name of `Product%20Line` could be incorrectly interpreted as `Product Line` because `%20` is the encoding sequence for a blank space.
AC	Across	Hierarchies and category variables Do not create variable names that contain an embedded percent sign (`%`) if the percent sign precedes the following characters: `0` through `9`, `a` through `f`, and `A` through `F`. Names that contain these character combinations could be misinterpreted due to encoding and decoding issues. For example, a variable name of `Product%20Line` could be incorrectly interpreted as `Product Line` because `%20` is the encoding sequence for a blank space.
A	Analysis variable	Analysis variable. This macro variable is deprecated.
S	Statistic	Globally-applied statistic. This macro variable is deprecated.
A`m`	Analysis variable	Analysis variable, where `m` designates the particular variable.
A`m`S`n`	Statistic	Statistic that is applied only to the analysis variable specified by A`m`. `n` designates the particular statistic. For example, A1S1 and A1S2 designate statistics that are applied only to the A1 analysis variable.
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 drill-down values	For example, V=YEAR=1995
VA	Across dimension drill-down values	For example, VA=PRODTYPE=FURNITURE
ST	Display table	1=yes, 2=no
DT	Default title	Max length=200
DP	Show drill-path 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
BS	Graph bar shapes	STAR, HEXAGON, PRISM, CYLINDER
SPDSHT	Download to Spreadsheet flag
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	Style sheet URL	Applies to variable selection and report pages
CSST	Toolbar style sheet URL	Applies to toolbar frame; if not specified, uses CSS value
BG	Background color or image	Color name or hex value, or image URL
BGTYPE	Background type	COLOR, IMAGE

Table 2. MDDB Report Viewer Global Variables

Variable Name	Description	Details
VMDOFF	Turn VERIFYMD checking off	Any nonblank character turns it off; the default is on
_GRFONT		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, and 5=none; the 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 a scrollbar to frame
_MRVTBSZ	Toolbar size in pixels	A character string of the form (horiz, vert); the default is (50, 125)
_MRNODIMBOXES	Turns off the down and across list boxes and the View Report button on display	A nonblank value turns this off; the default is on
_MRNOFRAMES	Indicates whether to use HTML frames in the output	A nonblank value turns this off; the default is on
_MRNOVARCHECK	Turns off the down and across variable selection error checking	A nonblank value turns this off; the default is on
_MRBODYONLY	Nonblank	Outputs the HTML between the <BODY> and </BODY> tags on the Layout and the Report pages.
_MRVFRAMESET	Enables you to specify a custom <FRAMESET> tag on the Report page
_MRVNOPGOP	Nonblank	Turns off the paging feature
_MRVRNDX1	Value for the radio button that represents the first number of rows	The default is All
_MRVRNDX2	Value for the radio button that represents the second number of rows	The default is 25
_MRVRNDX3	Value for the radio button that represents the third number of rows	The default is 50
_MRVRNDX4	Value for the radio button that represents the fourth number of rows	The default is 100
_MRVNRLKS	The minimum number of paging lines to display beneath the report table	The default is 5
_MRNOSORT	Turns off the sorting feature	A nonblank value turns this off; the default is on
_MRTBLPRM	Sets report <TABLE> tag parameters	For example, "CELLPADDING=4 CELLSPACING=2 BORDER=3"

Top of Page