Reporting & Analysis

In PowerOLAP or Excel you can enter "what if" figures that will help you chart the near- and longer-term course of your business. You can write changes and save them to a new model, entirely separate from current and historical data (thereby maintaining data integrity), but still combine them for reporting as needed.

With a few simple mouse clicks— dragging and dropping "region" to the Rows list box, and selecting/drilling down on Variable Costs only -you can create an entirely different view. Within PowerOLAP—you can create new views by stacking "dimensions", by selecting key elements, or by "drilling down", for quick analysis of differing parameters

PowerOLAP slice showing 1st Quarter Totals for Variable & Fixed Costs (detailed)

There are virtually limitless parametric views you can create from underlying data—within PowerOLAP, or even within a dynamically connected spreadsheet. Then, in Excel, you have the full range of functions available for creating standard or ad hoc reports featuring graphs, pie charts, etc.

This slice shows the breakdown of Variable Costs by Geographic region

So, what if, in Next Year’s Budget:

· Shipping increases by 10%

· Order Processing Staff increases by 10%

· Variable Benefits increase by 10%

· But we are able to cut Warehousing costs 25%

"What will the impact be on Before Tax Profits in our North America offices (Canada and U.S.)?"

In Version2 of Next Year's Budget, "what if" changes in Variable Costs are reflected automatically in Before Tax Profits—and these changes aggregate throughout the entire budget, for Total Product and Total Region