Drill Anywhere | Get behind your numbers!
Home About us Products How to buy Partners Contact us
Products
Drill Anywhere
Overview
Example Scenarios

Technical Requirements
See Recorded Demos
Drill Down Queries
Drill Down Templates
Drill Down Tools
Supported Databases
Testimonials
Drill Analyzer

Overview


Excel-based drill-down to any ERP module from Excel Reports

Drill Anywhere© is an exciting extension to any report writer (such as FRx, XL Reporter, Crystal Reports and Reporting Services) that can export reports to Excel. It puts information at your finger tips from within and beyond your ERP system! Anyone who regularly reads and reviews reports in Excel will save time and effort by now being able to retrieve the “story behind the numbers”, regardless of where the data resides.

From any report (generated into Excel), you can now use Drill Anywhere to drill down to transaction detail data in your ERP system or in any other ODBC-compliant database on your network. Users will no longer have to call the accounting department to ask why a balance is different than they expect. With a mouse-click, they will be able to retrieve the actual transactions which made up the summary balance (e.g. from the GL) they are viewing in the report and then continue drilling into the related sub-ledger detail! And most importantly, they do not have to be licensed users of the source system, which will help to keep the expensive “seats” or users of the ERP system to a minimum.

Drill Anywhere can save a company hundreds of hours per year spent requesting and researching data in reports. Finally an easy-to-use tool that provides end-users with the power to easily and instantly find the data that is important to them.

Benefits

The popular Excel format is used as the drill-down environment
Drill down to for example GL detail and then drill again to related sub-ledger data
Access data from any database on your network by creating your own drill-down queries
Avoid unnecessary ERP (or other software licenses) for users that only need to drill-down from distributed reports
Save hundreds of hours and thousands of dollars per year with automatic drill-down
Works with Excel-based reports generated by a report writer as well as any other Excel spreadsheets you have

Features

Quick and easy Excel Add-in installation
Optional prompts for instant ad-hoc data filtering
Provides drill-down to any ODBC-compliant database (e.g. SQL Server, Oracle, and DB2)
Unlimited number of drill down queries per report (user can choose query from a menu)
Active Directory Security
Drill-down query parameters can be passed from Excel reports and from user input
Queries and settings stored in a central MS SQL database
Many configuration options to control returned transactions, test queries and more
 
To download the Drill Anywhere for FRx, please click here
To download the Drill Anywhere for XL Reporter, please click here
A Closer Look:
© Copyright 2007 Drill Anywhere. All Rights Reserved.