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 our two sample OLAP demos constructed using Microsoft SQL Server, Microsoft Analysis Services, and Microsoft Office Web Components (OWC). 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 pivot table  has its own, separate set of Help screens available at the touch of a button.  It's all very intuitive.

Your desktop: You may need to download version 10 of the Microsoft Office Web Components and/or certain Microsoft pivot table service files and data access components, and to print the pivot table you will need the Microsoft OWC Helper.  Microsoft makes these available for download.  If you need help with this, call Michael Krumenaker of Palisades Research (908-953-8081) or email him at mkrumenaker@palisadesresearch.com. Note: If you have Office XP or Office 2003, you probably have OWC10  already, but it may or may not have been installed.





Page What to do
This page Each cube includes five standard dimensions, described below (see "Pivot Table").  Click the button for the OLAP cube you want to try based on the following additional dimensions:
  • Number of Renewals - Use Type
  • Multicar Discount - Adult/Youth - Use Type
Pivot Table

Choose Dimensions and Measures

On the right side of the screen, you will see a list of available dimensions and measure.  If you don't see it, click the icon immediately to the right of the help icon (the question mark) on the toolbar of the pivot table.

In addition to the dimensions listed above, each pivot table contains the following dimensions:

  • Peril (type of coverage)
  • Quarter
  • Company
  • State
  • Channel (means of acquisition)

Each pivot table has the following measures:

  • Capped losses (per state regulations)
  • Claims closed without payment
  • Cumulative Amount Paid
  • Earned Exposure
  • Earned Premium
  • Incurred Loss
  • Loss Ratio (incurred loss / earned premium)
  • RIF Count
  • PIF Count
  • Total number of claims
  • Written premium

There are two ways to select dimensions and measures:

  1. Drag and drop dimension names to the column and row heading positions (where it says "Drop Column Fields Here", "Drop Row Fields Here", "Drop Filter Fields Here", and the measurements area, under the columns area), or

  2. Click each dimension and measure and use the "Add to" button and position drop-down box to the right of that button for each one.

To de-select a dimension or measure, just drag its heading off the pivot table.

Drill Down

You can select more than one dimension rows, and more than one for columns.  This way, this is a form of "drill down."  Suppose you select Peril and Use Type as the row dimensions.  You could look at a particular Peril and see the breakdown among various Use Types, and the amount of each measurement for these combinations.  Again, just use the drop down boxes to "drill" through the particular Peril.

Another type of drill down is not illustrated in our demo, but is available.  We can drill through years to quarters within each year to months within each each quarter.  Or from State to County.  And so on.


You can look at your selected measures and the effect of your selected dimensions through filters.  For instance, suppose you want to view the effect of use type and peril on incurred loss and earned premium for one state or just a few state.  Make State a filter field, and use the drop down button next to "State" to select states.

You can also filter particular dimensions.  For any dimension you have added to your rows or columns, use the drop down button next to the dimension name to select particular values of that dimension.


Choose landscape or portrait by selecting the radio button next to the icon that looks like a page oriented as landscape or portrait.  Then press the PRINT PREVIEW or PRINT button.

If you get a message that Print or Print Preview is not supported for "PivotList_ PrintVersion", you need to download and install owchelper from Microsoft.  You can unzip the owchelper "exe" file in any directory you choose and double-click the html page it includes.  The html page probably won't work, but you will have activated owchelper and can thereafter use our Print or Print Preview.


We haven't included this in the demo, but you can save the combination of dimensions and measures on the server and recall them, instead of making the same choices every time you call us the pivot table.