Licensing Tab
Importing and Exporting
Select Page MembersUsing Edit Slice
Member Aliases & Alias Groups
Member Types/ Hierarchy Dialog box
Dependencies
Configuring PowerOLAP Server Service to Logon as User Account
OLAPPivot
The Edit Slice Dialog Box
Configure ODBC Data Source
Selecting a Page Member to View in Excel
Formula Dialog Box Editor Options
Dependencies
Transfer Cube
Register and Activate the PowerOLAP Server
MDX
Set 3GB Startup Switch in Windows
Importing and Exporting
About Fact Data in Cubes
Importing and Exporting
About Fact Data in Cubes
Creation of Ragged and Multiple Hierarchies
Process Cube (Rebuild Cube)
Assigning Meta Data Security Privileges
Allow Duplicates
Save Blank Members as [Undefined]
General Tab
Define Aliases
Define Rollups / Drill-Through with Rollups
Define Links—Star Schema
Define Members
Working with OLAP Exchange as Client in a Server Scenario
Additional Considerations for Data Preparation
OLAPTable
Use Partial Field Member Name
Formula Syntax and Terminology
Dependencies Grammar Definition
OLAPTable
Error File Reporting
Use SQL Views
Create Additional Tables
OLAPReadWrite
Creating a Cube
Process Cube for Fact or Meta Data Update
Working with OLAP Exchange on the MDB Server
Modify Relational Dimension
Add Members to 2nd, 3rd, etc Dimension
Building & Updating Cubes that Support Incremental Updating
PowerOLAP Cube Formula Grammar
PowerOLAP's Add-In Menuand Toolbar
Creating the Measures Dimension
Define Order
Create a Time Dimension
Creating a Local Database from the Synchronization Server
Define Hierarchy
Define Drill Through
Change Hierarchy
Define Links
Excel Paste Functions
Incremental Update vs. Update from Source
Extended Drill-Through
Database Reference Formulas
Ramifications of Modify Relational Dimension
Conditional Retrieval
Creating a Cube via OLAP Exchange
Creating the 2nd Dimension
Triggers and their use for Incremental Updating
Databases Supported for Use with OLAP Exchange
Formula Dialog Box Editor Options
About Meta Data
Synchronization Server database in SQL Server
PowerOLAP Cube Formula Grammar
TAN
atan
TAN
Creating a Task (Internet Data Services)
PowerOLAP Scheduler
Create and define IDS task to Pull Fact Data from a Remote Cube
How to Create a Local Cube from a Remote Cube using IDS
Entering Data from within Excel
Introduction to the PowerOLAP MDB Server
Other Task Types
Process Cube for Fact or Meta Data Update
IF
OLAPGroup
Create and define IDS task to Push Fact Data from a Local Cube
Set the Frequency of the Scheduled Job/Task
Transfer Cube
Continue to Next Task on Error
OLAPGroupCount
Creating Notification
Introduction to PowerOLAP SCHEDULER
Creating a New JOB
Importing and Exporting
Database Reference Formulas
Executing Cube Tasks in Excel
Execute Cube Task and PowerOLAP Scheduler Job from Excel
Modify or Delete Existing Jobs
Creating a Task (Internet Data Services)
Creating a New JOB
PowerOLAP Service Control Program
Requirements and Recommendations
Formula Syntax and Terminology
Excel Functions List
Creating a Dimension Hierarchy
MOD
Select Page MembersUsing Edit Slice
Creating Dimensions
Triggers and their use for Incremental Updating
Window, Tiled or Cascading Slices
Entering Data in a Slice
OLAPFactSecurityMember
current
ischildof
OLAPTable
member
levelcount
OLAPDimension
OLAPPivot
membercount
alias
PROPERTY
Cube Properties
ROOTCOUNT
childcount
PowerOLAP Cube Formula Grammar
aliastomember
level
Create a Time Dimension
currentindex
TIME
memberindex
parentcount
ROOT
asreadwrite
Cube Properties
Create a Time Dimension
parent
OLAPDimMaxLevel
child
Cube Properties
Create a Time Dimension
PowerOLAP Cube Formula Grammar
TODAY
Create/Save a Dimension Subset
Excel Integration
Paste and Drill-Through Functions
Select Page MembersUsing Edit Slice
Member Aliases & Alias Groups
General Formatting and Printing
The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
Select Row or Column Members Using Edit Slice
Property Groups
Aggregate Weights
SUMMARY: The Dimension Hierarchy Toolbar
Saving Changes to a Database
Selecting Page Members
PowerOLAP's Add-In Menuand Toolbar
Aggregate Weights
Define Links
Changing the Grid Layout
The Edit Slice Dialog Box
Creating Cube Formulas
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Create Dimension Hierarchy
Slice Commands
Creating Cube Formulas
Creating a PowerOLAP Database
Alias Groups
Creating a Slice View
Creating Dimensions
Model Dimensions
Model Cubes
Creating a Cube
Model Dimensions
Model Cubes
Administrator Topics
Create a New Linked Cube
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Create a New Synchronization Server
Make Changes Offline and then Synchronize [Remote Capabilities]
Excel Integration
Benefits Summary
Concepts and Benefits / Requirements
Creating Cube Formulas
Creating a PowerOLAP Database
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Concepts and Benefits
Installing PowerOLAP MDB Server
Make Changes On-line and then Synchronize
Register and Activate the PowerOLAP Server
IDS - Internet Explorer Caching Setting
Configure ODBC Data Source
Update Linked Cube
Set 3GB Startup Switch in Windows
Transfer/Export/Clear Cube
Transfer Cube
IDS Performance Considerations
Seeing Results in PowerOLAP (.olp file)
Building & Updating Cubes that Support Incremental Updating
About PowerOLAP Services
IDS
Create and define IDS task to Pull Fact Data from a Remote Cube
Importing and Exporting
Working with Cubes
About Fact Data in Cubes
MDX
Concepts and Benefits
Transfer/Export/Clear Cube
About PowerOLAP Services
Transfer Cube
MDX
Transfer/Export/Clear Cube
Transfer Cube
Importing and Exporting
Make Changes On-line and then Synchronize
Creating a Cube
Building & Updating Cubes that Support Incremental Updating
Databases Supported for Use with OLAP Exchange
Triggers and their use for Incremental Updating
PowerOLAP Cube Formula Grammar
TRIM
OLAPUserInGroup
ischildof
OLAPIsSecureDatabase
OLAPSave
IF
OLAPCanAddDimensionAndCubes
AND
iserror
OLAPIsChildOf
OLAPIsParentOf
OR
OLAPIsFormula
ismissing
NOT
Importing and Exporting
Importing Data from a File
pmt
PPMT
fv
PV
ipmt
Paste and Drill-Through Functions
Member Aliases & Alias Groups
Security Export/Import Feature
PMT
Model Dimensions
Assigning Meta Data Security Privileges
OLAPPivot
Zero Suppression
FV
PPMT
Define Links—Snowflake Schema
Creating an Excel Worksheet
Entering Data in a Slice
Create Dimension Hierarchy
Creating a New JOB
Assigning Fact Data Security Privileges
Define Links—Star Schema
Changing Data Views from within Excel
PV
IPMT
Meta Data Import Commands
Create/Save a Dimension Subset
OLAPAliasToMember
asread
char
Entering Data from within Excel
Create a New Linked Cube
Use Partial Field Member Name
Create the SQL Server Login
Calculation Engines
General Formatting and Printing
oledbreadwrite
cuberead
OLAPSubsetCount
Creating a Slice View
Creating Dimensions
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
OLAPUserGroup
Creating a Task (Internet Data Services)
Other Task Types
OLAPReadWrite
OLAPChild
Creating a Cube
OLAPSubsetMemberCount
Save Blank Members as [Undefined]
Process Cube for Fact or Meta Data Update
OLAPAliasGroup
cubedimcount
dbread
OLAPParent
Building & Updating Cubes that Support Incremental Updating
Creating the Measures Dimension
OLAPUser
Define Order
Create a Time Dimension
Caching
Entering Data through an Excel Worksheet
Cross-Cube Formula
Transfer Cube
cubedim
Installation of the PowerOLAP Client
The Edit Slice Dialog Box
Creating Cube Formulas
Model Cubes
oledbread
OLAPCube
OLAPCubeCount
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Adding Members to Dimensions
Creating Notification
OLAPAlias
Additional Information
Advanced PowerOLAP Worksheet Functions
Dynamic Multidimensional Graphs
Internal Cube Formula
OLAPIsChildOf
OLAPIsParentOf
dbreadwrite
Add Users and Groups
Creating a Cube
Entering Data in a Slice
Excel Paste Functions
Importing and Exporting
TRIM
cubereadwrite
Creating Cube Formulas
Adding a Server from within PowerOLAP
OLAPMemberType
OLAPRoot
Creating a PowerOLAP Database
Make Changes Offline and then Synchronize [Remote Capabilities]
Define Rollups / Drill-Through with Rollups
Fact Data Import Commands
missing
OLAPUserCount
OLAPUserGroupCount
Database Reference Formulas
Calculation Depth
ismissing
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Arranging Slice Dimensions
Conditional Retrieval
User Considerations
Rename a Subset
About Fact Data in Cubes
asreadwrite
OLAPRenameProperty
OLAPWriteAliasToCube
OLAPRenameMember
OLAPRenameAlias
Active Directory Authentication
PowerOLAP Client Installation for Non-Admin Users
Zero Suppression
Changing Data Views from within Excel