Asset Management Software

Asset Management Software Analysis
Asset Management Software

Asset management software data entered into the CMMS program database should be available for analysis and reporting. OEE, OLAP and Excel all offer powerful options for configuring and displaying this data in a meaningful way. The system used for this training provides flexible ways to export the data to multiple file formats such as MS Excel, MS Word, Acrobat, Rich Text, XML and several other file formats. By itself this is useful especially in the case of an Excel export as once the data is inserted into Excel the many powerful analysis and reporting features of Excel may be used to further analyze the CMMS data set. Leveraging Excel further by providing Excel with an OLAP data cube or OEE data set greatly increases the analysis capability of this asset management software system.

 

General reporting and analysis is described on a separate page. The methods described there are for the most parts SQL queries and reporting to Crystal Reports. The videos on this page train on using OEE (Overall Equipment Effectiveness, OLAP (Online Analytical Processing also known as data cubes) and exporting to Excel.

  1. OEE (overall equipment effectiveness).
  2. OLAP (online analytical processing) data cubes.
  3. Direct Excel export.
  4. OLE automation Excel export.

If further explanation is required contact CMMS University to schedule a personalized online demonstration of the software's analysis and reporting capabilities.

CMMS software data entered into the CMMS program database should be available for analysis and reporting. OEE, OLAP and Excel all offer powerful options for configuring and displaying this data in a meaningful way. The system used for this training provides flexible ways to export the data to multiple file formats such as MS Excel, MS Word, Acrobat, Rich Text, XML and several other file formats. By itself this is useful especially in the case of an Excel export as once the data is inserted into Excel the many powerful analysis and reporting features of Excel may be used to further analyze the CMMS data set. Leveraging Excel further by providing Excel with an OLAP data cube or OEE data set greatly increases the analysis capability of this software.

 

General reporting and analysis is described on a separate page. The methods described there are for the most parts SQL queries and reporting to Crystal Reports. The videos on this page train on using OEE (Overall Equipment Effectiveness, OLAP (Online Analytical Processing also known as data cubes) and exporting to Excel.

  1. OEE (overall equipment effectiveness).
  2. OLAP (online analytical processing) data cubes.
  3. Direct Excel export.
  4. OLE automation Excel export.

If further explanation is required contact CMMS University to schedule a personalized online demonstration of the software's analysis and reporting capabilities.

OEE (Overall Equipment Effectiveness)

  • What is OEE?.
  • How can OEE improve a maintenance operation.
  • Overall Equipment Effectiveness reporting.
  • OEE options and settings.

Exporting CMMS Software Data

  • Crystal Reports CMMS data export options.
  • Excel raw data export.
  • Excel OLE automation export.
  • Export file formats.
  • Raw grid print.

Analyzing CMMS Data with OLAP

  • What is OLAP?
  • How can OLAP help my equipment maintenance operation?
  • Two dimensional CMMS data sets.
  • Three dimensional CMMS data views.
  • Filtering for CMMS analysis and reporting.
  • Charting OLAP data.
  • Exporting Online Analytical Processing data.