Restoring a Database
Transaction Log
Remove Existing Version
Installation of the PowerOLAP Version 8 Client
PowerOLAP Scheduler
Installation of the PowerOLAP Client
PowerOLAP MDB Server Installation
PowerOLAP Version 8 MDB Server Installation
Installation of the PowerOLAP Version 8 Client
OLAPFactSecurityStatus
Register and Activate the PowerOLAP Server
Assigning Fact Data Security Privileges
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Creating a Cube
Building & Updating Cubes that Support Incremental Updating
Creating a Cube via OLAP Exchange
Update Linked Cube
Entering Data in a Slice
Incremental Update vs. Update from Source
Process Cube for Fact or Meta Data Update
Create and define IDS task to Pull Fact Data from a Remote Cube
Incremental Update vs. Update from Source
Building & Updating Cubes that Support Incremental Updating
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Building & Updating Cubes that Support Incremental Updating
How to Update the Fact Data of Local Cube from Remote Cube
Incremental Update vs. Update from Source
Save Database/Save and Backup Database/Update from Synchronize
Triggers and their use for Incremental Updating
PowerOLAP Cube Formula Grammar
lower
upper
Calculation Engines
User Considerations
Dependencies
User Considerations
Dependencies
Dependencies
Dependencies
Dependencies
User Considerations
User Considerations
Dependencies
Create the User Domain Account in the Active Directory
Configuring PowerOLAP Server Service to Logon as User Account
Quick Start Introduction
Entering Data in a Slice
Creation of Ragged and Multiple Hierarchies
The Dimension Hierarchy Toolbar
About PowerOLAP Services
General Tab
Creating a Cube
Creating Cube Formulas
Creating a PowerOLAP Database
Define Aliases
Summary of Quick Start Exercises
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Process Cube for Fact or Meta Data Update
Transfer Cube
Transaction Log
OLAPUserGroup
OLAPGroup
OLAPGroupCount
OLAPCanAddDimensionAndCubes
OLAPCubeSecurity
Fact Data Security Ranges
OLAPUserGroupCount
OLAPSliceSecurity
OLAPUserInGroup
OLAPUserGroup
OLAPGroup
OLAPUserGroupCount
current
number
member
levelcount
membercount
OLAPNavigate
level
OLAPFormula
AND
iserror
currentindex
OR
memberindex
lookup
OLAPQuery
AGGREGATESUM
Importing and Exporting
WEIGHT
CHILD
Calculation Engines
Creating a Slice View
Creating a Cube
Create a Time Dimension
Constraints
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
Selecting a Page Member to View in Excel
Additional Considerations for Data Preparation
Create/Save a Dimension Subset
Excel Integration
Select Page MembersUsing Edit Slice
OLAPFactSecurityMember
OLAPAliasToMember
OLAPFactSecurityRuleName
ABS
OLAPFactSecurityRangeMembers
Save Slice
Member Types/ Hierarchy Dialog box
Remove Existing Version
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
Make Changes On-line and then Synchronize
Select Row or Column Members Using Edit Slice
OLAPDimension
OLAPAliasGroupCount
OLAPMember
OLAPMemberIndex
OLAPReadWrite
Member Properties
parent
OLAPFactSecurityStatus
OLAPChild
PowerOLAP Service Control Program
PROPERTY
OLAPAliasGroup
alias
Selecting Page Members
OLAPPivot
literal
OLAPDimMaxLevel
Benefits Summary
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
Using Slices to Navigate Cubes
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
aliastomember
Creating the Measures Dimension
OLAPUser
Create and define IDS task to Push Fact Data from a Local Cube
Set the Frequency of the Scheduled Job/Task
Window, Tiled or Cascading Slices
Granting Dimensions Meta Security Rights
OLAPMemberFirst
IDS
The Edit Slice Dialog Box
OLAPGroupCount
OLAPCube
OLAPCubeCount
Transaction Log
Accessing the Database by a User with Read-Only Rights
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Create and define IDS task to Pull Fact Data from a Remote Cube
OLAPCurrentUser
OLAPAlias
How to Update the Fact Data of Local Cube from Remote Cube
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Rearranging Dimensions within a Slice
Dynamic Multidimensional Graphs
OLAPFactSecurityMemberCount
Assigning Fact Data Security Privileges
Slice Commands
WEIGHT
OLAPChildCount
OLAPMemberType
OLAPRoot
Applying Database Security
Fact Data Security Ranges
Summary of Quick Start Exercises
OLAPWeight
OLAPPropertyGroupCount
Changing Data Views from within Excel
Arranging Slice Dimensions
Quick Start Introduction
OLAPFactSecurityPrivileges
child
Triggers and their use for Incremental Updating
ROOT
Use SQL Views
Synchronization Server database in SQL Server
Cube Properties
Active Directory Authentication
Set 3GB Startup Switch in Windows
Databases Supported for Use with OLAP Exchange