Client / Stand-Alone Deployment

Speed, flexibility and performance--finally, one simple solution for organization-wide decision support needs.

The application that allows users to create and model complex business-financial scenarios within an optimized multidimensional environment--and still work through an Excel spreadsheet interface (local cubes or attached to MDB Server).

With PowerOLAP, users create sophisticated business models for the purpose of analyzing and reporting on data with remarkable speed, flexibility and performance. These models, or multidimensional Cubes, are based on the multiple Dimensions that define an organization, including, for example, Products, Regions, Time-Periods, Accounts, Measures of sales, Customers, Versions (e.g., Budget, Actual, Forecast). Dimensions are composed of members arranged within hierarchies-thus, within a Region dimension, the member United States might include the constituent geographic members East Coast, Texas and California. Cubes, Dimensions, their Members and Hierarchies, along with Formulas written to perform all manner of cube calculations, are known as metadata.

PowerOLAP enables users to manipulate metadata intuitively and efficiently, so that building or altering a model can be accomplished in a matter of minutes. Then, with drag-and-drop, double-click speed, users can create virtually any cross-dimensional view, or Slice, of a cube, to access figures (fact data) showing, for example, Total Products, sold to Retailers, in the 4th Quarter, in California, according This Year Budget.

PowerOLAP employs the Excel spreadsheet as a front end, so any slice can be viewed through Excel and subsequently published through its report-writing features. Likewise, users can enter data through the familiar spreadsheet interface--to test "what if" analytical scenarios or, if they have requisite security privileges, to "write back" changes to a final model version. Note that all data is stored within PowerOLAP, not Excel--even so, spreadsheets created via PowerOLAP maintain a dynamic connection to source cubes, retaining their standard Excel formula, formatting and graphical capabilities.

PowerOLAP also provides powerful functions beyond those provided by Excel, so users can write their own formulas that will send dependent figures to a range of cells or even to different cubes. This enables users to construct templates requiring the input of only several key variables, further enhancing their capabilities to create "what if" scenarios (e.g., What will next year's budget revenues for Product "A" look like if we increase its advertising by 10%?). Within seconds, all cells affected by a newly entered number are updated.


System Requirements>>

Windows 2000 and above or Windows NT workstation configured to meet Microsoft's requirements to run Excel.