Excel with PowerOLAP®

This is what Excel is supposed to do.

PowerOLAP® provides extraordinary empowerment, using the tool you use most often for planning, analysis and reporting needs—the familiar Excel spreadsheet.

Organize data the way you want within PowerOLAP—then, with one mouse click, "slice to Excel".

You’ve just created a spreadsheet with improved functionality, including dynamic access to underlying data sources. This puts an end to clerking proliferating spreadsheets throughout your organization—and the beginning of exceptional spreadsheet productivity at the desktop.

Working in Excel is second nature to most analysts—so learning enhanced PowerOLAP functions is accomplished in no time.

With the touch of a button your spreadsheet becomes a front-end browser to the multidimensional data contained in PowerOLAP, as well as to the relational systems that "feed" it.

Access data from different perspectives, for different "dimension" members (any time period, region, version, etc.), even from different models within the database, directly from the spreadsheets you create.

Benefits of PowerOLAP's native Excel interface:

Spreadsheets retain all their capabilities

Excel continues to be your principal reporting tool. Except now these reports will update automatically as the underlying data or structure changes.

Connect directly to all important data sources

Microsoft SQL, Pervasive, Progress, Oracle, Sybase, or legacy systems that are the databases for Accounting, MRPII, Customer Service, Sales Force Automation, Point of Sale, Customer Relationship Management, HR/Payroll or other systems—all dynamically connected to your spreadsheet. This eliminates the need for multiple, more-difficult-to-use reporting systems.

Stop re-entering data from various reports

PowerOLAP pulls the data you want directly from the sources of your written reports. No more clerking spreadsheets by analysts, managers and executives.

Combine endless spreadsheets into one

PowerOLAP’s multidimensional structure and direct data connections makes linked, multi-sheet spreadsheets and pivot tables a thing of the past.

Share instantly throughout the enterprise

Spreadsheets created with PowerOLAP maintain their dynamic connection to source data and can be shared over your network or via the Internet. This maintains one version for all. Dynamic write-back capabilities allow you to enter data in a spreadsheet and save them to various models So you can enter updated figures or test "what if" scenarios, create budgets and forecasts all within Excel and without changing the underlying database.