October 2008 Monarch Report eNewsletter [Archive]

Mike Urbonas

October 29th, 2008, 04:28 PM

<TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr><tr><td colspan="2"><H1 align=center> <img src="http://www.monarchforums.com/images/Monarch_Report.gif" alt="The Monarch Report"></H1></td><tr> <TD width=540> October 2008 The Monarch Report informs users of our Monarch-powered solutions of the latest product news, tips, user stories, upcoming events and more. This newsletter is sent to our online subscribers and anyone who has purchased or expressed interest in Datawatch products. </TD> <TD style="PADDING-LEFT: 10px; VERTICAL-ALIGN: top" rowSpan=14>Read More About our Solutions... <A href="http://www.datawatch.com/_products/monarch_overview.php" target=_blank>Monarch</A> is the de facto standard in Report Mining, trusted by over 400,000 users to easily mine data from reports, PDFs and more into live, actionable data without programming and without IT help. <A href="http://www.datawatch.com/_products/monarch_data_pump.php" target=_blank>Monarch Data Pump</A> is a server-based enterprise reporting and data ETL solution, creating and delivering customized data across your organization, at a fraction of the cost and time of alternative solutions, with no new database programming. <A href="http://www.datawatch.com/_products/monarch_rms.php" target=_blank>Monarch|RMS</A> (Report Mining Server) turns any traditional COLD report archive or existing document management system into a powerful source for business intelligence. <A href="http://www.datawatch.com/_products/datawatch_es.php" target=_blank>Datawatch|ES</A> uniquely leverages existing reports as a source of web-enabled enterprise business intelligence, providing enterprise report management, online data analysis, MS Excel integration and more, at a fraction of the complexity and cost of other solutions.<A href="http://www.datawatch.com/_products/datawatch_bds.php" target=_blank>Datawatch|BDS</A> (Business Document Server) is a high speed, high volume document archive system, archiving text, images, intelligent data streams and unstructured content, complete with file compression. Unlike other document archive systems, Datawatch|BDS also offers advanced business benefits, including optional automatic email notification to end users of newly archived documents, as well as optional web-enabled transformation of reports and PDF files, into customized data using Monarch|RMS. <A href="http://www.datawatch.com/_products/datawatch_mailmanager.php" target=_blank>Datawatch|MailManager</A> is a highly scalable e-mail management solution that provides complete lifecycle, compliance, and storage management for Microsoft Exchange environments. Datawatch|MailManager captures internal, outgoing and incoming email correspondence, indexing it and managing its retention based on your corporate policies. In the case of audit or legal discovery, related e-mail can be instantly and accurately retrieved for rapid response.
</TD> </TR> <TR> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <img src="http://www.monarchforums.com/images/Monarch_V10_Pro_Standard.jpg" align=left><H3 style="COLOR: #f00">Monarch V10 is Here!</H3> Get Ready…Get Ten…GO! The wait is over! Monarch V10 is here, and results are truly incredible! You'll notice the breakthrough new power of Monarch V10 from the moment you build a new model template more easily than ever, discover exciting new analytical and styling capabilities, and experience the most powerful Excel exporting Monarch has ever offered.Read on for just some of the reasons the new Monarch V10 is a must-have business intelligence solution for everyone! 
<a href="#article1">Read More...</a> </TD> </TR>
<TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Thomson Grass Valley Business Group Turns to Monarch for ERP Business Intelligence Made Easy</H3> Information Made Easy Becomes Even Easier, More Powerful with Monarch V10 
Thomson is a leading provider of solutions for the creation, management, delivery and access of video for the communication, media and entertainment industries. The Southwick, Massachusetts-based Transmission product line within Thomson’s Grass Valley business unit has turned to Monarch to dramatically simplify its ERP data access and analysis, for information made easy. 
Donna Tougas, Manufacturing Support Engineer and Alyson Stone, Financial Analyst for Thomson, discussed a number of their most important Monarch projects, for ERP information made easy. They also spoke about the new Monarch V10 features they are especially looking forward to putting to use.
 
 <a href="#article2">Read More...</a> </TD> </TR> <TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Introducing MonarchTV on the Monarch Blog</H3>Catch Quick Snippet of New Monarch V10We are pleased to introduce a new feature on the Monarch blog, MonarchTV. From time to time we will offer brief video snippets of interest on Monarch, including the new report mining, Excel integration, report styling and analytical power Monarch V10 provides. 
Check out our first MonarchTV installment highlighting some of the most exciting new Monarch V10 summary features, including bursting data for effortless reporting, right now! <a href="http://www.monarchforums.com/blog.php?b=21" target=_blank>Keep reading - from our Monarch Blog...</a> </TD> </TR> <TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch V10 Gets Thumbs-Up from Microsoft's Doug Mahugh</H3>Guest Presenter from 2008 Datawatch User ConferenceDoug Mahugh, Microsoft Senior Product Manager, recently blogged in praise of Monarch V10 and its new ability to export mined data directly to Excel Pivot Tables without programming and without any manual work within Excel. Attendees of the 2008 Datawatch User Conference will remember Doug as a conference guest speaker, presenting along with Gareth Horton, Datawatch Product Manager, on the synergies between Microsoft and the family of Monarch-powered solutions. <a href="http://blogs.msdn.com/dmahugh/archive/2008/10/20/weeks-of-links-for-10-20-2008.aspx" target=_blank>Check out Doug's blog entry now.</a> </TD> </TR><TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR>
<TR> <TD> <H3 style="COLOR: #f00">New Monarch BI Server in the News</H3> Datawatch recently announced the release of Monarch BI Server, a web-based Business Intelligence (BI) solution built specifically to address the unique needs of small-to-medium sized businesses (SMBs) and department-level users. Since then, Monarch BI Server has picked up some well-deserved media coverage! <a href="#article3">Read More...</a> </TD> </TR><TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Data Pump, Monarch BI Server Webinar Series Coming Soon</H3> Keep an eye on your inbox and the Datawatch website for details on our new webinar series, beginning in November! <a href="#article4">Read More...</a> </TD> </TR><TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch|RMS: Ready-Made, Web-Based Business Intelligence for IBM Content Manager OnDemand Clients</H3> Datawatch is in Vegas this week at the 2008 IBM Information On Demand (IOD) conference. Datawatch will be informing attendees how their IBM Content Manager OnDemand (CMOD) report management solution can serve double duty as a web-enabled source of business intelligence with no new programming with Monarch|RMS (Report Mining Server). After a CMOD end user selects desired reports from the CMOD archive, a click of the mouse directs the user to the Monarch|RMS web interface, with the data from the report set already mined into data. The user can sort, filter, summarize and otherwise work interactively with the data, with no programming and no help from the IT department. Data can be exported to Excel, PDF and more anytime. <a href="http://www.datawatch.com/_products/monarch_rms.php" target=_blank>Visit our Monarch|RMS page for details.</a> <a href="http://www.datawatch.com/_solutions/demoForm.php" target=_blank>View our Monarch|RMS recorded demos.</a> 
</TD> </TR><TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Meet Joe Monarch - and Wow, is he Happy! But What Exactly is he Saying?</H3><img src="http://www.monarchforums.com/images/Joe_Monarch_V10.jpg" align=left> The front cover of <a href="http://www.datawatch.com/product_literature/Monarch_V10_brochure.pdf" _target=blank>our new Monarch V10 upgrade brochure</a> features a very happy new Monarch V10 user! Meet Joe Monarch, psyched-up Monarch V10 user! Joe is probably saying "YEAH!" after exporting his Monarch data to new Excel Pivot Tables, or dazzled his boss with powerful new Monarch summaries, set up Monarch V10 to report dates based on his company's unique fiscal periods in a snap and more. But what else is he saying? You tell us! Help us figure out what's on Joe Monarch by telling us what to put in the voice bubble on the Monarch blog! The most entertaining submission will win a fun prize. Please share your wit and wisdom, with us, and Joe Monarch, and <a href="http://www.monarchforums.com/blog.php?b=20" _target=blank>post on the Monarch blog right now!</a> </TD> </TR><TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Haiku Lives On</H3> Thanks to Joe Lovati, Network Analyst for Option One Mortgage Corporation, for our latest Monarch haiku: Greenbar data hurts Monarch Pro to the rescue Table view restored We'd like to read more Monarch hakius, particularly your haiku in praise of the new Monarch V10! Get your haiku on <a href="http://www.monarchforums.com/blog.php?b=12" target=_blank>and post now on the Monarch blog!</a> 
</td></tr>
<TR> <TD style="BACKGROUND-COLOR: #f00">  </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Training: Must-Have Training for Immediate Productivity and Business Benefits</H3>
 Amid a tough economy, organizations need to determine 'nice' expenditures from 'necessary' ones. The 'necessary' expenses are those that deliver an immediate return on investment…exactly like the Monarch training classes offered by Datawatch. Combine the new must-have power of Monarch V10 with the must-have learning and insight provided only from a Datawatch training class, and now you're talking return on investment you can measure in hours, not months! "This was the best seminar I have ever attended…I am a (Monarch) beginner, plus we had an IT Director in the same class, (yet our Monarch trainer) managed to challenge all of us…Monarch will save me a minimum of 10 hours per week, and as much as 20 hours per week! I am almost speechless, and can’t wait to get back to work!" -- Ed Dranchak, GFI Genfare <a href="http://www.datawatch.com/_services/training_overview.php" target=_blank>Visit our Monarch Training homepage</a> for full details and to find a Monarch class near you! 
<a href="#top">Return to top of page</a>
</TD> </TR> </TD></TR> </table>
<TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr><a name="article1"></a>
<TR> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch V10 is Here!</H3>
Get Ready…Get Ten…GO! The wait is over! Monarch V10 is here, and results are truly incredible! You'll notice the breakthrough new power of Monarch V10 from the moment you build a new model template more easily than ever, discover exciting new analytical and styling capabilities, and experience the most powerful Excel exporting Monarch has ever offered. Monarch V10 is all about dramatically improving your productivity, saving hours of your time, empowering you with more Excel-based capabilities than ever, and setting you up for success with effortless, programming-free reporting and business intelligence. Here are just some of the reasons the new Monarch V10 is a must-have business intelligence solution for everyone! 
Monarch V10 offers unprecedented Excel integration! A new world of high-end, Excel-driven business intelligence is at your command. <ul><li>Export your Monarch data as customized Excel Pivot Tables! No other solution provides Excel-based Business Intelligence as easily as Monarch V10.</li><li>Burst summary data as separate spreadsheets or workbooks! Distributing your Monarch summary data by department, location, etc. is now as easy as a click of the mouse.</li></ul> Monarch V10 offers effortless data analysis! Easily gain more insight into your Monarch data.<ul><li>Display multiple measures across a Monarch summary, sorted by key or by measure. Previous versions of Monarch allowed for only one measure to be displayed in a crosstab summary. Monarch V10 opens up a whole new world of Monarch analytics.</li><li>New point-and-click "Value-Based" filtering! Select a field to filter and Monarch V10 will list all existing values in your data. Select any number of values and/or enter desired values (wildcard values supported) and more! If your job depends on finding that proverbial "needle in a haystack" within your data, Monarch V10 is for you.</li><li>Export and publish your Monarch work with style, too! Export your Monarch summary data with up to 54 colors for exporting to Excel XLS format, and 64,000 colors when exporting to Excel 2007 XLSX format, with more new formatting options.</li></ul>Monarch V10 makes model building almost effortless! Building model templates is more intuitive than ever. <ul><li>Auto-define report trapping! Having trouble defining a trap? Let Monarch V10 help create the trap for you! Getting started on defining a trap is easier than ever with Monarch V10.</li><li>Color-coded model templates help expedite model building! Choose a custom background color for each template type, to easily see the data mined from each portion of your template.</li><li>Deal effectively with missing report data! If you have ever had to deal with a report with missing append or footer data, this feature is for you! Monarch V10 lets you conditionally suppress append or footer data to ensure complete data integrity.</li></ul>Monarch Pro V10 offers brand new and improved data sources! 
<ul><li>Open PDFs 2x faster than Monarch V9! If you work with huge PDF reports, you'll love Monarch Pro V10.</li><li>Import reports in the new Microsoft XPS format! Monarch Pro V10 can now import XPS files in a similar way to PDF import. Any report or business document accessible using Windows can now be exported to the new Microsoft XPS document format for mining with Monarch V10 Pro.</li><li>More new import formats! Monarch Pro V10 can import data from Excel 2007 XLSM files (Excel macro-enabled workbook) and Access 2007 ACCDB files.</li> NEXT STEPS: 
<a href="http://www.datawatch.com/_products/monarch_overview.php" target=_blank>Visit the Monarch V10 homepage.</a> 
<a href="http://www.datawatch.com/product_literature/Monarch_V10_brochure.pdf" target=_blank>Read our Monarch V10 brochure.</a> 
<a href="http://www.datawatch.com/_solutions/demoForm.php" target=_blank>Register to view the What's New in Monarch V10 recorded demo.</a> 
<a href="http://www.datawatch.com/_buy/buy_main.php" target=_blank>Purchase</a> or <a href="http://www.datawatch.com/product_literature/OrderForm_monarchv10_FINAL.pdf" target=_blank>Upgrade</a> to Monarch V10 now! 
 
<a href="#top">Return to top of page</a>
</TD> </TR> </TD></TR> </table>
<TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr><a name="article2"></a>
<TR> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Thomson Grass Valley Business Group Turns to Monarch for ERP Business Intelligence Made Easy</H3> Information Made Easy Becomes Even Easier, More Powerful with Monarch V10 Thomson is a leading provider of solutions for the creation, management, delivery and access of video for the communication, media and entertainment industries. Thomson’s clients include studios, broadcasters, content distributors (telco, satellite and cable operators) and an increasing range of professional users of video. Thomson delivers superior value to its customers through a combination of industry-leading technologies and services, enabling Thomson to offer differentiated and innovative solutions based on its broad portfolio of intellectual property. The Southwick, Massachusetts-based Transmission product line within Thomson’s Grass Valley business unit has turned to Monarch to dramatically simplify its ERP data access and analysis, for information made easy. "We have been using Monarch for about three years," says Donna Tougas, Grass Valley transmission manufacturing support engineer, "and now it's hard to imagine how we ever got by without it. It's so easy to access and analyze our ERP data with Monarch and export it anytime to Excel, all without programming." Donna Tougas and Alyson Stone, a financial analyst for the Grass Valley Business Unit in Southwick, discussed a few of their most important Monarch projects, for ERP information made easy. "We need easy access to a lot of customized manufacturing and inventory data for effective management," says Tougas. "The data we need typically exists across several existing canned reports. We use Monarch Pro to mine the data from multiple reports, export it to Excel or Access files, and then combine the data together in a single Monarch Pro view, with no programming and no need for a live connection to the ERP database." As an example, the transmission product line sends their PC board (PCB) assembly work to an outside contract manufacturer. They use Monarch Pro to mine data from their Bill of Materials (BOM) report to get each part number, part description, required quantity, etc. The transmission product line also needs to provide the outsourced manufacturer the vendor information for each part, so they know who to buy from, who to contact and other critical information. The BOM data and vendor data reside in totally separate modules. Monarch Pro makes it easy and programming free to combine the data mined from the BOMs with data mined from the vendor master reports. The end result is an Excel file with all BOM part details along with vendor name, contact details, vendor part numbers and more for each part. The transmission product line then sends this Excel file to their outsourced manufacturer who then has what they need to take it from there. Previously the transmission product line manually typed the vendor information into a spreadsheet, a waste of time that we no longer have to deal with thanks to Monarch." "Monarch Pro is helping us analyze parts in our inventory based on usage over the past three years," Donna explains. "We need to make informed decisions as to whether to retain inventory, allocate it to customer service department for use in repairs, or scrap it. The analysis to facilitate the transmission product line inventory decision making requires inventory valuation data, inventory aging, historical usage data, part master data and more. Monarch Pro sidesteps what would be a complex data query task by simply mining and combining data from a series of five reports. The data produced by Monarch Pro lets the transmission product line concentrate on those parts that have made the biggest positive or negative impact on the company. The Grass Valley Transmission product line is looking forward to expanding the company's reporting and analytical reach using the new Monarch V10. "One very exciting new Monarch V10 feature for us is the ability to burst our Monarch summary data," Donna says. "When exporting a Monarch V10 summary to Excel, you can specify you want to create individual Excel files into one folder (or individual worksheets within one workbook) with each change in the key value appearing in the first column of your summary. This is a huge step forward for expediting the creation of Excel-based reporting while ensuring each manager receives just his or her data. We expect this new Monarch V10 feature alone will be a huge time-saver for us and enable faster informed management decisions." "Monarch V10 also lets you define your organization's unique fiscal calendar," adds Alyson. "Our company uses a 4-4-5 quarter; that is, each of the three months of a fiscal quarter is defined as 4, 4 and 5 weeks, respectively. We can now define these fiscal calendar rules in Monarch V10, enabling us to easily analyze our data based on fiscal periods, using 14 new calculated field functions, as well as easily summarize our data based on fiscal periods. Any organization with fiscal calendars that differ from standard calendars will find time-based analysis with Monarch V10 much easier to create." "Monarch just keeps getting better and better," Donna concludes. "Any manufacturing organization seeking powerful business intelligence at a fraction of the complexity of other solutions should definitely check out Monarch V10." <a href="http://www.datawatch.com/case_studies/case_studies.php" target=_blank>Read more Monarch case studies.</a>
 
<a href="#top">Return to top of page</a>
</TD> </TR> </TD></TR> </table>
<TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr>
<a name="article3"></a>
<TR> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">New Monarch BI Server in the News</H3>
Datawatch recently announced the release of Monarch BI Server, a web-based Business Intelligence (BI) solution built specifically to address the unique needs of small-to-medium sized businesses (SMBs) and department-level users. 
Since then, Monarch BI Server has picked up some well-deserved media coverage! Unlike traditional BI solutions that seek to replace the reports already produced by your enterprise systems (such as ERP, legacy/mainframe systems, industry-specific solutions for healthcare, banking, etc.); Monarch BI Server leverages report output as a new, web-enabled source of live, actionable data. Monarch BI Server begins by building a centralized, password-protected report archive. Reports are easily accessed anytime using a web browser. Monarch BI Server then automatically mines and customizes data from these stored reports as a live web-based data. Unlike traditional BI solutions, Monarch BI Server integrates customized enterprise data with Excel without programming and without the need to connect to live databases. With just one click of the mouse, you can export desired data to Excel and aggregate data to produce BI-rich summary views of the data, with subtotals, grand totals and other calculations. Marianne Kolbasuk McGee, writing for InformationWeek, recently praised Monarch BI Server as "helping some smaller organizations squeeze insight out of data in existing reports and other electronic documents -- without a data warehouse." <a href="http://www.informationweek.com/news/business_intelligence/analytics/showArticle.jhtml?articleID=210002805">Read the entire article.</a> And Karen D. Schwarz of eWeek noted "Monarch BI Server is designed to be easy to use and maintain" and is designed to "solve daily operational issues quickly without using data marts, data access query tools or custom reports." <a href="http://www.midmarket.eweek.com/c/a/News/Datawatch-introduces-new-approach-to-BI/">Read the entire article.</a> <a href="http://www.datawatch.com/downloads/BROCH_Monarch_BI_Server.pdf">View the Monarch BI Server brochure.</a> <a href="#top">Return to top of page</a><TABLE style="FONT: 12px arial; BACKGROUND-COLOR: #fff" width=880 align=center border=0> </tr>
<a name="article4"></a>
<TR> <TD style="BACKGROUND-COLOR: #f00"> </TD> </TR> <TR> <TD> <H3 style="COLOR: #f00">Monarch Data Pump, Monarch BI Server Webinar Series Coming Soon</H3>Keep an eye on your inbox and the Datawatch website for details on our new webinar series, beginning in November! We will begin with a series of new webinars focusing on Monarch Data Pump, providing enterprise information delivery and data ETL (Extraction, Transformation and Loading) without programming: Monarch Data Pump: Programming-Free ETL This webinar will discuss the need among small and mid-market organizations for data ETL (Extraction, Transformation and Loading) tools that are easy to use and significantly less expensive than alternate solutions. You will discover how Monarch Data Pump serves as an ETL solution to populate data marts and warehouses stored in SQL Server, Oracle, etc. Dramatically less expensive and easier to maintain the alternative solutions, you will discover Monarch Data Pump will exceed your expectations, but not your budget! Monarch Data Pump and Microsoft SharePoint: A Powerful Combination for Enterprise Reporting and BI Monarch Data Pump's enterprise information delivery capabilities include the ability to export Excel and other files created by Monarch Data Pump into Microsoft SharePoint repositories. Even better, Monarch Data Pump's features are designed to make data integration with Microsoft Office SharePoint Server (MOSS 2007) a snap. This webinar will feature Monarch Data Pump in action, automatically transforming an existing ERP report into customized, SharePoint-based business intelligence, complete with web-enabled Excel files and SharePoint KPIs! Future webinars will also focus on Monarch BI Server and the business benefits awaiting healthcare organizations and more! To be automatically notified when the webinar series dates and times are finalized, please drop us an email at: newsletter [at] datawatch.com. 
<a href="#top">Return to top of page</a></TD> </TR> </TD></TR> </table>