It's official...the new Monarch V9 has officially been released as of today! [img]smile.gif[/img]
What is it?[/b] Monarch V9 is the newest version of Monarch, with plenty of new features designed to appeal to frequent users of Excel. Monarch users typically export their Monarch data to Excel, so we made it a point to include compelling new Excel functionality, among other new features.
What does Monarch V9 offer Excel users?[/b] Monarch V9 uses its own native Excel export engine instead of relying on drivers provided by Microsoft. This means Monarch V9 is 5X faster when exporting to Excel; Monarch V9 can export to the new Open XML (Excel 2007) XLSX format; and Monarch Pro V9 can import XLSX files.
Additionally, we have many Excel-friendly features designed to help reduce, if not eliminate manual "Post-Monarch" work in Excel. For example, Monarch summary exports to Excel now include subtotals and grand totals as Excel formulas, not static values as in previous versions. You can also choose to export summary data with the Excel Outlining feature enabled (for drill-up and drill-down within Excel). Plus, exception coloring in your Monarch summary will be exported as native Excel conditional formatting as well. In the Monarch table, you can export data with the Excel AutoFilter automatically activated.
Cool! What else?[/b] Monarch V9 offers new analytical and data presentation capabilities. For example, you can create you rown User-Defined Functions; formulas that appear as part of the list of standard Monarch functions. These User-Defined Functions can be shared with other Monarch users in the form of Linked Objects (any element of a Monarch model can be made available for other Monarch users to use; a great solution for multi-user Monarch sites to manage and control Monarch use, ensuring everyone is applying the same correct model templates, calculations, filters, etc.
When you create forumulas in Monarch V9, you have a lot more space to do so: up to 32,767 characters (up from 4,096!)
In another new collaboration capability, Monarch V9 also lets you import and export files, models, model objects, etc. via MS SharePoint.
Also, the Monarch V9 summary view offers many new presentation options. You can choose to hide certain columns needed to sort your data properly, for example, but you do not want to display certain columns. (Columns hidden in your Monarch summary will also be exported as hidden within Excel also). You can also display summary data differently using "header lines" for brand new options to present and export Monarch summary data. Here too, we focused on how Monarch V9 will help reduce, if not eliminate manual "Post-Monarch" work in Excel.
As for new report mining capabilities, Monarch V9 now offers up to 22[/b] templates in a single Monarch model, and you can define a detail template with up to 256[/b] lines - great for mining data from page-long business documents like statements and invoices. Also Monarch V9 offers a new NOT trap, which will trap data based on whether certain characters, numbers, blanks, wildcards, etc. do "not" appear in that position.
Any new database importing features in Monarch Pro V9?[/b] Yes! We added a new, faster OLE DB data importing engine, up to 20% faster than previous versions of Monarch Pro. You can also pre-filter imported database data with 22 Monarch text string, numeric and date functions now available to use! Finally, if you work with delimited text files, you can now open multiple instances of those data files at the same time in Monarch Pro V9.
Of course, this is just an overview of some of the new features and power of Monarch V9!
[url="http://www.datawatch.com/datawatch/news.asp?display=detail&id=128"]Read our official press release.[/url]
[url="http://www.datawatch.com/download/optional.asp?file=monarch_v9_Int_final.pdf"]Check out our Monarch V9 upgrade brochure.[/url]
[url="http://monarch.datawatch.com/monarchv9-demo-form.asp"]Watch our What's New in Monarch V9 flash demo (online registration required).[/url]
[url="http://blogs.msdn.com/brian_jones/archive/2007/02/27/datawatch-builds-reports-using-spreadsheetml.aspx"]Read Microsoft's Brian Jones (OpenXML Program Manager) blog on the V9 release.[/url]
[url="http://blogs.msdn.com/dmahugh/archive/2007/02/27/monarch-a-product-for-breaking-into-your-own-data.aspx"]Read Microsoft's Doug Mahugh (Lead Open XML Technical Evangelist) blog on the V9 release.[/url]
[size="1"][ February 28, 2007, 06:38 AM: Message edited by: Gareth Horton ][/size]