This CMMS solution is the only computerized maintenance management system that includes an OLAP query builder tool. OLAP is an acronym for online analytical processing). OLAP provides powerful analysis for your CMMS solution data by simple drag and drop. Additionally the OLAP query builder is building a chart in the background automatically as you drop data fields into the OLAP component. This is ridiculously simple to use.
This query builder enables the user to build queries on every screen in the CMMS solution. The query builder is full featured providing color flags for out of range data, multiple stacked fields in each analysis scenario and all of the common statistical functions you would expect in a CMMS solution. If that's still not enough analysis power then simply convert the entire data set into an Excel spreadsheet with two (2) button click.
CMMS Solution to Data Analysis
A common comment we get is: "...our company has a CMMS that we have entered data into, however much of the data we cannot get out for reporting purposes when we need it..." MaintSmart addresses this with the query builder OLAP component. All data on all screens may be used in the query builder. All data is always available for reporting and analysis. All data in this computerized maintenance management system software is available for exporting to Excel. All data in this CMMS software is available to chart. Each query builder scenario that is created by drag and drop (this takes seconds) may also be saved as an ".olapx" file and reused.High and low range values may be flagged by color making it easy to identify them in the resulting data grid. While the data is being dropped a chart is built automatically reflecting this new data set. Multiple chart formats are available.
No other CMMS solution provides this useful capability at any price!
Query Builder Options
The query builder provides simple drag and drop queries. Although these are simple to create they do generate very sophisticated data sets if needed. The data is grouped and subtotaled across rows and columns. Each row or column may have multiple data field stacked on each other. Statistical functions are available for each row or column as follows:
- Standard Deviation
- Population Variance
- Population Standard Deviation
Choose the subtotal statistical function needed for each of the stacked rows and columns. This component is completely flexible to whatever you need in data reporting and analysis.
OLAP Charting and Reporting
The OLAP query builder also has built-in filtering. All dropped data fields may be filters with several built-in filter options and a custom option as follows:
- >, >=, <, <=
- equals, not equal
- begins with
- ends with
There are several data formatting options that enable the maintenance manager to create the exact report needed in the proper format. High and low values may be colored to stand out. Clicking on a value (sum for example) drills down and displays the source data in a pop-up screen.
Export formats include Excel and Adobe Acrobat with or without a chart. Multiple chart types are also available. Use this OLAP query builder to generate simple or very comprehensive reports from the MaintSmart computerized maintenance management system.
CMMS Solution with OLAP Query Builder
Down Time Analysis Example with Query Builder
CMMS Solution for Accountability of Inventory Used Data
The query builder is particularly well-suited for analysis of equipment down time, work orders, preventive maintenance and inventory usage data. For the purposes of spares usage the OLAP query builder is very usdful in how it groups parts used by technician, equipment, part or other available field.
Query Builder for Equipment Failure Analysis
Equipment failure analysis (down time) provide a great place to use the query-builder tool. Quickly isolate the down time issue with either the query builder or use one or more of the other down time analysis tools first then dig deeper into the analysis by linking the results to the OLAP component. If the maintenance manager requires further analysis then the data from the query builder may be exported immediately to Excel for even more analysis. Experience rapid improvement in your equipment maintenance with these powerful analysis tools.