PowerOLAP® Quick Start Introduction

Some of the features such as OLAP Exchange®, and HTTP web connectivity are activated for use only when appropriate License is used. After activating the software, check Edit/Options/Licensing to view the functionality on your system.

The PowerOLAP® Quick Start Manual is designed to introduce you to the fundamentals of PowerOLAP® application by using step-by-step procedures to create a PowerOLAP model. We recommend that new OLAP users become familiar with the Introduction to PowerOLAP® section of the user manual as a prerequisite to this manual. The Introduction section also contains information about the enhancements in PowerOLAP® software such as new features and their benefits.

By working through this Quick Start Manual you will learn about the elemental functions of the PowerOLAP® application: how to create databases, Dimensions, Cubes and Slices; how to import data from a text file into a Cube; and how to create an Excel worksheet from a Slice view. This manual shows how to construct a model by working entirely with the product’s “modeler.” Note that—especially if you are an Administrator or power user—you will not build Cubes (business models) only by the steps described here. Instead, many PowerOLAP Cube features (Meta Data) will be built using the OLAP Exchange® component; and, the actual figures you work with (Fact Data) will likely come from another source. However, you will undoubtedly need to understand the concepts and follow the steps covered in these pages because they convey how to use, customize and advance your own models. These skills, in turn, will enable you to vastly increase the potential business uses and benefits of the product at your firm.

The PowerOLAP® User Manual, in contrast to this manual, introduces PowerOLAP® application fundamentals by first allowing you to view and manipulate data within a pre-built model, then goes on to demonstrate how to perform and apply higher-level functions. That manual explains more comprehensively the end-user features and functions of the PowerOLAP® application. Therefore, please refer to the PowerOLAP® User Manual for more detailed information on features discussed in this manual. Also, see the additional User Manuals such as the OLAP Exchange®Synchronization Server, or PowerOLAP MDB Server for their respective features and functions, and how they are applied to create superior business solutions.