OLAP Statistics and Reporting for Access

OLAP Statistics & Reporting for Microsoft Access enables you to Connect to a fact table (and their related tables, if available) from an Access database and select fields of interest, and then explore them in a multi-dimensional grid, pivot tables, filters, graph or chart view. With the capability of Complex calculations, trend Analysis and sophisticated data modeling, and reporting, it helps you to identify critical information on your not so obvious data. Highlights: Works with all version of Microsoft Access databases - 97/2000/2002/2003/2007 (*.mdb), 2007/20101 (*.accdb) Save OLAP cube schema (*.olapschema) and re-use it for subsequent operations to generate cube from the database. Support almost all data types in MS Access. Choose your own fields from the fact/transaction table and their related tables and set them as measures or dimensions for the OLAP cube. Supports the following functions for Measures - Count, Distinct Count, Max, Min, Average, Sum etc. Supports most of the common OLAP operations including slice and dice, drill down, roll up, and pivoting on the cube. Supports date/time fields to be summarized or Broken down to year, month, day, week, hours, minutes etc. Create your own composite hierarchy. Eg. Country > State > City Create your own calculated member involving computational relationship. Eg. Total Sales = (UnitPrice X Quantity) + Freight OLAP Grid and Chart with highly interactive, customizable and user friendly interface. Save the pivot details to file (*.olapreport) to make it easy for later retrieval and use without requiring to start from scratch. Support offline cube (to *.offlinecube in compressed or uncompressed format) for use in disconnected mode. Complete control over the export settings of the grid/chart reports.