Monarch forV9 New Features

Enhanced support for Microsoft Excel® is
only the beginning of what's in EZ-Pickin's V9 !

EZ-Pickin'sV9 includes more powerful analytic capabilities than ever before! And, for the first time, you'll have the ability to easily collaborate with your EZ-Pickin's colleagues. An order of magnitude faster than previous versions, EZ-Pickin's V9 lets you get more done in a shorter amount of time.

Even better, you can upgrade to work smarter now without worrying about later -EZ-Pickin'sV9 works with Microsoft Vista and Excel 2007.

Explore the wide range of new and improved features of EZ-Pickin'sV9 and EZ-Pickin's Pro V9. Call (630) 986-0800 to upgrade TODAY. View the different features at each version in the EZ-Pickin's Comparison Table.

New to EZ-Pickin's v9 Professional

• Database Importing: The EZ-Pickin's Pro V9 OLE DB engine imports data up to 20% faster than before. Plus, it now supports the SQL Server 2005 Native Client, for maximized performance with SQL Server 2005 databases.
• Link to External Models: This new feature helps guarantee that the use of EZ-Pickin's models, calculations, filters, etc. are consistent across all EZ-Pickin's users in your organization! Using EZ-Pickin's Pro V9, you can now import or link any model object-such as individual templates, data fields, filters, Calculated Fields, sorts, summaries, User-Defined Functions and more-from models residing on your network or SharePoint repository.
• Enhanced PDF mining: EZ-Pickin's has been optimized for more PDF generators, plus, EZ-Pickin's can now mine AES-encrypted PDFs (EZ-Pickin's will automatically prompt you for the password).
• Import OpenXML Spreadsheets
• Sharepoint Collaboration: Import Excel files or file-based databases from SharePoint repositories as a data source. Also, share your User-Defined functions with other EZ-Pickin's users-via the network or SharePoint-to ensure consistency across the organization.
• More powerful Database Filtering: Define highly precise data filter expressions to target only the data you need, with 22 EZ-Pickin's functions now available for your use! If you frequently use the External Lookups or database import capabilities of EZ-Pickin's Pro, this feature is for you.
• Other Features:
  • Import Multiple Delimited Text Files
  • Import Excel Files with No Header Row
  • Ability to force Data Types to Character
  • Replace Nulls on Import of Database Files

New to both EZ-Pickin's Standard and EZ-Pickin's Pro

Excel exporting

Export Office 2007 OpenXML Spreadsheets (xlsx), and take full advantage of the new functionality and dramatically increased spreadsheet capacity of Excel 2007!

• Up to 5X Faster Exporting Engine: Exporting engine for Excel runs up to 5X faster than previous versions!
• Export Microsoft ® Office 2007 OpenXML Spreadsheets (xlsx).
• Export Summary Subtotals and Grand Totals to Excel as Formulas: Hassle-free Exporting of Summary Subtotals and Grand Totals to Excel Spreadsheets as Formulas. Export subtotal/grand total data as formulas instead of values. Quickly and easily make revisions in Excel.
• Export Summaries with the Outlining Feature for Excel, for easy drill-up and drill-down of your Excel spreadsheet data, just as you can in EZ-Pickin’s.

Windows Vista™ Ready

Incredible Analytical Power

• Create User-Defined Functions: The powerful built-in functions of EZ-Pickin’s combined with your expertise allow you to create functions that appear just like EZ-Pickin’sfunctions when building calculated fields and filters.
• Create EZ-Pickin’sSummary Views with New Data Layout Options : Once you customize your EZ-Pickin’sSummary, you can save your settings as a Design Preference in XML format. Summary settings can be reused for creating new summariesor reformatting existing summaries. Design Preferences can be shared over the network or via a SharePoint repository!
• Eight-fold Capacity Increase for Long Formulas

Collaboration with Microsoft SharePoint ® Support

For the first time, you can share every aspect of your work with others in your organization—via the network or SharePoint. With EZ-Pickin’sV9, collaboration is a breeze! Open and save models and projects from SharePoint repositories, and export directly to SharePoint.

Unlimited Report Mining

• Define up to 22 templates in a single EZ-Pickin’sModel (an increase from 10)!
• Define up to 256 lines for your detail template (an increase from 64) —
• New NOT Traps: Previous versions of EZ-Pickin’s trapped data based on what appears in the report. The new NOT trap feature allows you to trap report lines based on whether certain data does not appear!
• Enhanced PDF Mining Including AES-encrypted PDFs: Publish incoming text reports into PDF reports, complete with the EZ-Pickin’s navigation tree as PDF bookmarks! Adobe Acrobat® is not required for this new PDF report publishing capability. Plus, published PDF reports can be password-protected with either 12 8-bit RC4 or U.S. Government-approved AES encryption.

Summary and Table Window

• Insert new header rows into EZ-Pickin’s Summaries and combine them to create all new summary display options that meet your unique reporting and analytical requirements!
• Easy Model Editing: Open a EZ-Pickin’s model without opening a report or other data source to speed edits to model templates. Plus, test the validity of new filters and Calculated Fields without data using the Test Expression feature!
• Calendar Control for Inserting Dates: Easily enter desired dates into filters, Calculated Fields, etc.

Additional new features

• Increased Capacity for Creating Calculated Fields or data filters The EZ-Pickin’sV9 Expression Editor now accepts formulas up to 32 ,767 characters long (up from 4,096)—an 8-fold increase!
• Improved Duplicate Value Filtering: Isolate rows of data in your EZ-Pickin’s Table with no duplicate values, one duplicate value or multiple duplicate values.
• Hide keys or measure fields in your EZ-Pickin’s Summary —so you can use them in sorts and when creating specific summary calculations but don’t want to see them in the final analysis.
• Enhanced Summary Matching Options: I nclude very specific EZ-Pickin’s data in your EZ-Pickin’s Summary using the full range of matching operators (such as >, <, >=, etc.). Previous versions of EZ-Pickin’s only allowed you to match measures using “At least” or “At most” logic.
• Increased Data Limits for EZ-Pickin’s Summaries: Unlimited length for subtotal and grand total labels, and unlimited item fields in a EZ-Pickin’s Summary.
• More Flexible Footer Templates: The struggle to mine data buried within the footer of a report is over! Trap data using any footer line (previously you could only trap on the first line of footer data)!
• Export Data from an EZ-Pickin’s Table to an Excel Spreadsheet with AutoFilter Predefined, ready for immediate filtering in Excel.

<< Back to EZ-Pickin's Features Main Page