Home
BIXL
Inquiry

Create and Model Business Scenarios

PowerOLAP Models

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).

PowerOLAP enables users to manipulate the model 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.

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.

 

Powerful Functions :

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. Speed, flexibility and performance—finally, one simple solution for organization-wide decision support needs.

 

 

Stand Alone Client or Server:

PowerOLAP is available as a standalone product; it is also the client application to the PowerOLAP S3 - MDB Server within a PowerOLAP Suite.

The PowerOLAP Suite includes OLAP Exchange which is a bi-directional inferface to your relational data, it can be used to send data back from the multidimensional to the relational database—with the capability to implement detailed user security privileges. And because OLAP Exchange is dynamic, changes originating in either database can be reported instantaneously to the other database system.

For more information, please contact us or visit the PowerOLAP website to download a PowerOLAPlite demo.

 

Visit the PowerOLAP Website by clicking on a Logo below

iBusiness is an Implemention Partner of Paris Technologies Inc. we build solutions using PowerOLAP and BIXL
We take your information seriously.

 

 

Home | PowerOLAP | Inquiry - Contact Us