Home Available Palisades Palisades Company SAS Principals Contact

:: For a free consultation or review, submit your project details here ::

Welcome to our on-line demonstrations of Web-enabled OLAP technology.

You're welcome to try any or all of the three industry MDDB demos (auto insurance, homeowners' insurance, and telecommunications) ­ they all work the same way. Stay as long as you like, and come back whenever you wish.

We suggest you print out the instructions below before leaving this page. In addition, the report table screen (described below) has its own, separate set of Help screens available at the touch of a button.

CLICK A LINK TO BEGIN AN OLAP DEMO:

AUTO INSURANCE

HOMEOWNERS INSURANCE

TELECOMMUNICATONS

INSTRUCTIONS FOR USING OLAP DEMOS:

Page What to do
This page Click the button for the MDDB you want to try (auto insurance, homeowners' insurance, or telecom). This takes you to the page titled SELECT AN OLAP CUBE.
SELECT AN OLAP CUBE
  • Select class variable combinations from the MDDB File drop-down box. Note the additional class variables which are always included.

  • Select a STYLE SHEET

  • Press CONTINUE
Choose dimensions and analysis variables

The user selects one or more class variables (dimensions) whose values will go across the table and down the table, respectively. For example:

  • If the user selects Quarter as the "across" dimension, then each column will represent a different quarter.
  • If the user selects Peril as the "down" dimension, each row will represent one type of coverage.

To make multiple selections in a single list box: Hold down the control key as you left-click on your selections.

  • First list box: Select a hierarchy or one or more individual class variables for the "down" dimensions.
  • Second list box: Select a hierarchy or one or more individual class variables for the "down" dimensions.
  • Third list box: Select one or more analysis variables. Each selected variable will appear in the left-most column of the fourth list box. Note: To remove an analysis variable from the fourth list box, select that item in both the third and fourth list boxes and hold down control and left click on that variable in the third list box.
  • Fourth list box:
  1. Click the first of the selected analysis variables. The available statistics are listed in the SELECTED column. Items initially in the AVAILABLE column are not currently calculated.

  2. Use the arrow keys to move items back and forth between AVAILABLE and SELECTED. Use the control key when selecting multiple items to move at the same time.

If you select more than one analysis variable, you can pick different statistics for each one.

  • OPTIONS: If you want to select any of the following options, press the OPTIONS button at the top of the page. The option categories are listed here, and described in the next section:
  • Filter one or more class variables to show the statistics related to only selected values

  • Filter box postion and size

  • Report title

  • Table: Totals, drillpath, number of rows

  • Graph

  • Graphs: If you want to see graphs, you must go to the option screen before viewing reports, or...
  • Click the View Report tab at the bottom of the list box area to see a report.
Report Screen

If you chose a hierarchy, the system displays the results for the first class variable in that hierarchy. The value of these variables will appear as links.

  • To drill down to the next level, click the value into which you want to drill.

For example: If you chose the hierarchy STATE > COMPANY > TIME to go across columns, and you want to drill down into California to see the Company level, click the CA link in the top row of the report. The next report will show the values of the analysis variables for each Company, but only for California.

  • To change any of the class variables (dimensions - down and/or across), make different selections in the Down and Across dimension boxes above the report.
  • DOWNLOAD TO EXCEL: You can download the entire table to an Excel worksheet by clicking the button with this title.
  • ROTATE: Rotate the entire table (switch rows and columns) by pressing the button with this title.
  • To change the analysis variables or the statistics reported, click the DIMENSIONS button and follow the instructions related to the third and fourth list boxes (see Choose dimensions and analysis variables, above).
  • To change options (e.g., to add a filter or to show or change the type of graph): click the OPTIONS button.
  • HELP: Press the HELP button (the right-most button above the table) to get on-screen help on using the MDDB viewer.
  • To select a value in the filter or change a selected value: Make a selection in the drop-down filter box. You can select more than one value (using the control key).
Options screen

Use this screen to set or change any of the following options:

  • FILTER OPTIONS:

­ To filter one or more class variables to show the statistics related to only selected values, select one or more variables in the drop-down box. You'll set values for the filter on the report page, after seeing the report pre-filter. ­ You can change the appearance of the filter box (listbox options, position, size).

  • REPORT OPTIONS:
  • Title: Add/change, in the report title text box.
  • Display Table: Table is displayed if this box is checked.
  • TABLE OPTIONS:
  • Totals: Report contains row and column totals, if the box is checked.
  • Drillpaths: Report shows drillpath above the table, if this box is checked.
  • Number of rows: Select, using the radio buttons.
  • GRAPH OPTIONS:
  • Choose 3-D clickable graph (a java applet) or regular 2-D graph.
  • Choose graph location from the drop-down box.
  • Choose a type of graph (or blank for none) from the drop-down box.
  • Choose bar shape from the drop-down box.
  • Choose width of graph in the width text box.
  • Choose height of graph in the height text box.
  • Click the View Report tab at the bottom of the options selection area to see a report, or...
  • To change the analysis variables or the statistics reported, click the DIMENSIONS button and follow the instructions related to the third and fourth list boxes (see Choose dimensions and analysis variables, above).