OLAP is a tremendously powerful component that provides analytical processing features similar to those found in Microsoft Excel Pivot Tables and Pivot Charts. Drag-and-drop views give you real-time information, insights, and results in seconds. Drag up to five column fields, five row fields and five value fields to generate a user-defined two or three dimensional data set of virtually any data in the MaintSmart database.

MaintSmart leverage the data queries you create in the MaintSmart Analysis screens by linking to these user defined data sets with the OLAP component. Additionally OLAP is available on most other screens including work order, down time, purchasing, inventory and preventive maintenance screens. Data from any of these screens may be arranged as needed by drag and drop in the OLAP screen. This data may then be totaled by row and column using one of several statistical functions. This data set is then charted automatically.

Clicking on a grid cell in the OLAP data grid causes the underlying data for that cell to be displayed in a separate grid. The OLAP data grid may be exported directly to Excel (just like all grids in MaintSmart) for further analysis.

Using OLAP with CMMS.