Download Quick Start Manual

Table of contents Quick Start .....................................................................................................................1 Quick Start Introduction ......................................................................................................1 Creating a PowerOLAP Database ........................................................................................2 Creating Dimensions .............................................................................................................6 Adding Members to Dimensions...........................................................................................8 Creating a Dimension Hierarchy........................................................................................10 The Dimension Hierarchy Toolbar................................................................................................. 13 Aggregate Weights........................................................................................................................ 13 Creating a Cube ..................................................................................................................14 Creating a Slice View ..........................................................................................................16 Arranging Slice Dimensions .......................................................................................................... 19 Selecting Page Members................................................................................................................ 20 Changing the Grid Layout ............................................................................................................. 22 Entering Data in a Slice ......................................................................................................23 Setting General & Format Preferences ..............................................................................23 General Tab................................................................................................................................... 23 Format Tab.................................................................................................................................... 27 Licensing Tab................................................................................................................................ 29 Portal Tab ..................................................................................................................................... 29 Importing Data from a File.................................................................................................31 Creating Cube Formulas ....................................................................................................34 Creating an Excel Worksheet .............................................................................................39 Selecting a Page Member to View in Excel .................................................................................... 40 Entering Data from within Excel........................................................................................41 Defining Cube References...................................................................................................43 Closing a Database ..............................................................................................................47 Summary of Quick Start Exercises ....................................................................................48 About OLAP Exchange.......................................................................................................49 About PowerOLAP Services...............................................................................................56
PowerOLAP Quick Start Manual
i