This CMMS charting solution is the only computerized maintenance management system that includes an OLAP report 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 report 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 report builder enables the user to build queries and subsequent reports on every screen in the program. The report 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 charting 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 Charting Solution for 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 report builder OLAP component. Use maintenance data from any screen to create a chart or graph. Equipment maintenance data is always available for reporting and analysis. All of the data in this computerized maintenance management system software is available for exporting to Excel.
Charting and analysis is available in all screens in the entire CMMS software program. Additionally each report 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 charting solution provides this useful capability at any price!
Report Builder Options and Tools
The report builder provides simple drag and drop queries resulting in detailed charts. 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.
Charting and Reporting Using the OLAP Component
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 Charting Solution with OLAP Report Builder
Down Time Analysis Example with Report Builder
CMMS Charting Solution for Accountability of Inventory Used Data
The report 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 report builder is very useful in how it groups parts used by technician, equipment, part or other available field.
CMMS Report Builder for Equipment Failure Analysis
Equipment failure analysis (down time) provide a great place to use the report builder tool. Quickly isolate the down time issue with either the report 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. Export this data set directly to Excel for additional analysis. Experience rapid improvement in your equipment maintenance with these powerful analysis tools.