Monarch|Report Mining Server

by Datawatch

Monarch|RMS is a web-based report mining solution that makes any traditional COLD or existing document management system as accessible as a data warehouse. Based on industry leading Monarch enterprise report mining technology, Monarch|RMS (Report Mining Server) turns reports stored in any document management system or simple file sharing solution into real, actionable data with just the click of the mouse.

Whether you are using an archiving solution from IBM, Mobius, Hyland, Quest or others or you have a system developed inhouse, Monarch|RMS can work for you. Whether to export to Excel for manipulation, summarize hundreds of megabytes of data into ten lines of totals or mine the data using dynamic OLAP-type tools, Monarch|RMS provides the tools and results needed to improve corporate data utilization.

Monarch|RMS provides trusted and timely mining and transformation of report data for easy analysis right in your browser or favorite productivity tool.

The Monarch|RMS report mining solution offers:

• Dynamic report mining from any existing report archive - one click access to report data-based spreadsheet and summaries
• Native Excel support - instant transformation of report data into native Excel spreadsheets right through your browser
• Real world analytics - support for Excel pivot tables and other complex spreadsheets as well as multi-dimensional analysis

Choose the functionality you need now and add more later
Monarch|RMS is a modular enterprise application built to meet a wide range of reporting and business intelligence needs. Every Monarch|RMS system starts with the ES Spreadsheet base module. All other modules are optional and can be added one at a time or in groups to enable new capabilities ranging from online analytics, Microsoft Excel support and forms-based viewing of report data.

RMS Spreadsheet, the base module on which Monarch|RMS is built, uses powerful Monarch server technology to dynamically transform reports stored in any existing document management system into browser-based or Microsoft Excel spreadsheets, tables, summaries and charts. With RMS Spreadsheet, Monarch|RMS transforms your enterprise reporting environment into a real-world data mart, enabling users to work with the data locked in the reports online, with no limitations.

RMS Spreadsheet allows users to leverage the power of Microsoft Excel right through their browser. By just pointing and clicking, Monarch|RMS users can extract all report data, or a summarized view of the report data, into a live Microsoft Excel file downloaded automatically from the Web. Even better, RMS Spreadsheet fully supports Excel templates. Users can choose to load data into an archived Excel template, predefined with pivot tables, charts, multi-sheet workbooks, macros and more, to bring data to life, fast! RMS Spreadsheet also comes with the RMS DBJoin component, which can combine data from reports with additional data from a separate source, such as an ODBC database, Excel or Access file, etc., and present the combined data in one view, without programming.

Simply put, RMS Spreadsheet working with your report archive or management solution is the easiest way to integrate data from your core enterprise systems with Microsoft Office, without data warehousing and without custom programming!

RMS Spreadsheet features at a glance:

• Works with your existing report archiving system
• User-initiated report data transformation in web or Excel spreadsheets
• Browser-based tables viewing based on Monarch model technology
• User-initiated sorts and filters for targeted data analysis
• Powerful data summaries deliver multiple views of report data
• Dynamic browser-based charting of summary data
• Live linking of report data to other corporate data using RMS DBJoin
• User-initiated, server-based table and summary data exporting to Excel
• Delivery of Excel output directly to local Excel through browser
• Full support of Excel templates to leverage advanced MS Excel capabilities
• Automatic Excel cell formatting and 65,000 row support

RMS Cube is an optional analysis module that extends Monarch|RMS' business intelligence capabilities into the multidimensional, dynamic analysis world. RMS Cube transforms data selected from reports into a multidimensional data cube on the server, downloading it to the user's web browser. RMS Cube provides the user with drag-and-drop analysis including summaries, graphs, filters and sorts, to view data from any angle, at any level of detail. Users have plenty of power to work with, in a user-friendly interface: drill down to the original data anytime; save any view for future use, export graphs or data to PDF, Word or Excel, and more. RMS Cube brings high-end data analysis to anyone in the enterprise that needs it!

RMS Cube features at a glance:

• Java-based, drag-and-drop report-based multidimensional analysis
• Browser-based applet that automatically loads in the user's browser
• Analysis of report data based on user queries and results
• Support for saved user and administrative views of report data
• PDF, Excel and Word exporting of all data and graph views

RMS Style transforms any report or other text output stored in your existing document archive into online XML forms. Virtually every industry needs to provide certain text-based reports within a form for viewing. Monarch|RMS Style provides this capability, including simple invoices, complex financial statements, healthcare claims and more. Users can easily search, view and print XML form-based content in their web browser.

RMS Style features at a glance:

• Automatic transformation of text output into XML forms, for online viewing
• Includes flexible XML forms designer
• Powerful printing capabilities