SAS/IntrNet 1.2: MDDB Report Viewer

Setting Up the MDDB Report Viewer

The MDDB Report Viewer consists of three HTML pages in which users can enter information to generate reports and graphs from an MDDB. Some features of the MDDB Report Viewer pages may appear slightly different on different Web browsers. If you will use more than one browser to access the MDDB Report Viewer, you should consider these differences when setting up and customizing the tool.

You can use any of three methods to set up the MDDB Report Viewer.

Method 1
Copy the sample webeis.htm (Windows) or webeis.html (UNIX) page for the MDDB Report Viewer. The sample page is included in the SAS/IntrNet Application Broker installation package and may be found in the sasweb/webeis directory located under your Web server root document directory. Modify the webeis.htm(l) file to specify your site's metabases, services, background colors, and so on. You can specify a subclass of the WEBEIS class to customize viewer behavior. See Method 3, Step 2 for a description of the class parameter.
Method 2
Use the dynamic entry into the application by entering a URL similar to the following in your Web browser:
```
 http://web-server-name/broker-URI?_program=sashelp.webeis.rptseld.scl
      &_service=myservice&metabase=sashelp.mbeis&bgtype=color&bg=red
      &class=sashelp.override.myweb.class
```
where

broker-URI, bgtype, bg, and class are as described in Step 2, below. With this method, no HTML pages are created and stored.
Method 3
Run the SAS AF command (described below) to create HTML pages for your metabases.

Follow the steps below to run the SAS AF command to set up the MDDB Report Viewer for users at your site:

Start a SAS session.
To create the MDDB Report Viewer HTML file, enter the following command in the Program Editor window and submit the command to SAS for processing:
```
af c=sashelp.webeis.rptsel.scl metabase=my-metabase
    pathname='HTML-file' <CGI='broker-URI'>
    <title='1996 Sales Report'> <bgtype='color'> <bg=blue>
    <class='sashelp.override.myweb.class'>
```
where

metabase

is the name of the SAS/EIS metabase in which the MDDB has been registered. A metabase value is required. SAS recommends that you use the same or similar filenames for the metabase and pathname options so that you can easily determine the metabase with which a particular instance of the MDDB Report Viewer is associated.

pathname

is the path and filename of the MDDB Report Viewer HTML file that is created by the AF command. The directory should normally be located under the Web server document root or in another directory served by the Web server. A pathname value is required. SAS recommends that you use the same or similar filenames for the metabase and pathname options so that you can easily determine the metabase with which a particular instance of the MDDB Report Viewer is associated.

CGI

is the optional URI for the Application Broker component of Application Dispatcher (for example, /cgi-bin/broker or scripts/broker.exe). If you do not specify a value for this option, you must supply a value in the HTML file after it is created.

title

is the title that will appear at the top of the report. A title value is optional. If you do not specify a title, the title "Multidimensional Reports" is used.

bgtype

is the type of background that will appear in the application reports. Specify bgtype='color' to control the color of the background or bgtype='image' to control the background pattern displayed in the application reports. Use this option with the bg option, described below. A bgtype value is optional.
If you specify bgtype='color', the bg option expects one of the named colors or a hex value for one of the colors that is supported by your browser. If you specify bgtype='image', the bg option expects the URL of a background image file. You can specify only GIF and JPG image files for the background. If you specify bgtype and omit bg, or if you do not use either option, the background will be the default color, silver.

Note: When you control the background color of the MDDB Report Viewer HTML pages, you might also want to control the background color of graphs that are displayed on the HTML pages. To do this, you can use a transparent GIF image, which is an image with a transparent background in which the HTML background color is visible. In effect, you create a graph in a clear "frame" so that the background color of the HTML page displays through the frame. A device driver to create the transparent GIF is not supplied with SAS/GRAPH software; however, you can use a simple SAS program to create the transparent image.

bg

specifies the color or image to display in the background. A bg value is optional. If you specified bgtype='color', then specify a color value for bg. If you specified bgtype='image', then specify an image value for bg. You can specify a color name or a hex value for the color value. You can specify a URL for the image file value. See the documentation for your browser for valid color values. If you specify bg and omit bgtype, or if you do not use either option, the background will be the default color, silver.
Note: If you specify an invalid color value, your browser will map the specification to a valid value.

class

is the name of a subclass of the WEBEIS class. A class value is optional. Add this parameter if the user has overridden any WEBEIS methods to change the viewer behavior. You can specify either a 3-level or a 4-level name. For example, sashelp.override.myweb and sashelp.override.myweb.class are both valid.
In an editor, open the HTML file you created and supply your own values in the HTML code that is preceded by a comment. These values include:
broker-URI

in the tag <FORM ACTION="broker-URI">, you must supply a value if you did not specify the CGI= option in the AF command to create the HTML pages.

service-name,service-label
in the HTML lines
```
<BR>Select service: <SELECT NAME="_service">
<OPTION VALUE="service-name" SELECTED>service-label
```
specify the list of services available at your site. Provide an <OPTION> tag for each of your services. For more information about services, see _SERVICE.
debug selection list

in the HTML line Debugging level: <SELECT NAME="_debug">, you can optionally modify the list of debug options for your site.
Start the Application Server and point your browser to the HTML file generated in Step 2, above.

You can specify the metabase, pathname, CGI, title, bgtype, bg, and class options in any order. You will need to run this application for each metabase that contains MDDBs that users will access to run their reports.

SAS/IntrNet 1.2: MDDB Report Viewer