Creating a Slice View
New Slice Menu & OLAPNavigate
Model Cubes
Entering Data in a Slice
Rearranging Dimensions within a Slice
Slice Commands
OLAPReadWrite
Creating an Excel Worksheet
OLAPReadWrite
Cube Properties
OLAPPivot
Creating an Excel Worksheet
Select Page MembersUsing Edit Slice
Creating a Slice View
New Slice Menu & OLAPNavigate
Dynamic Multidimensional Graphs
The Edit Slice Dialog Box
Select Page MembersUsing Edit Slice
Stack or Nest Dimensions
Select Row or Column Members Using Edit Slice
Selecting Page Members
OLAPPivot
Rearranging Dimensions within a Slice
Arranging Slice Dimensions
Fact Data Import Commands
Select Page MembersUsing Edit Slice
Entering Data from within Excel
OLAPReadWrite
Selecting Page Members
Cube Properties
OLAPPivot
Selecting a Page Member to View in Excel
Slice Commands
Changing Data Views from within Excel
New Slice Menu & OLAPNavigate
Summary of Quick Start Exercises
Database Reference Formulas
Arranging Slice Dimensions
The Edit Slice Dialog Box
Cube Properties
Changing Data Views from within Excel
Selecting Page Members
Selecting a Page Member to View in Excel
SCAN
find
month
day
minute
hour
Transfer Cube
User Considerations
OLAPRootCount
OLAPUserInGroup
Meta Data Import Commands
OLAPFactSecurityMember
OLAPCubeDimCount
WEEKDAY
OLAPAliasToMember
current
ischildof
aggregatesum
asread
char
OLAPTable
OLAPWriteAliasToCube
OLAPFactSecurityRuleCount
number
levelcount
log
member
oledbreadwrite
now
OLAPFactSecurityRuleName
len
asin
OLAPSubsetCount
OLAPFactSecurityRangeMembers
pmt
OLAPFactSecurityRule
SIN
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
SIGN
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
date
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
parent
SQRT
mid
SUBSTITUTE
membercount
OLAPFactSecurityStatus
OLAPChild
OLAPSubsetMemberCount
PROPERTY
REPLACE
RIGHT
SCAN
OLAPAliasGroup
cubedimcount
IF
acos
alias
OLAPReadWrite
OLAPWrite
OLAPPivot
ROOTCOUNT
literal
month
OLAPDimMaxLevel
dbread
exact
childcount
code
cos
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
PowerOLAP Cube Formula Grammar
PPMT
SECOND
lower
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
level
fv
aliastomember
OLAPUser
REPT
RAND
OLAPCubeSecurity
iserror
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
IDS
The Edit Slice Dialog Box
Creating an Excel Worksheet
oledbread
OLAPGroupCount
OLAPCube
OLAPCubeCount
find
atan
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating a Local Database from the Synchronization Server
The OLAPPivot Function
PROPER
ln
OLAPCurrentUser
TAN
OLAPAlias
currentindex
day
Additional Information
Change Hierarchy
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIME
TIMESTRING
TODAY
dbreadwrite
upper
OLAPMemberCount
Assigning Fact Data Security Privileges
Secure Database
Excel Paste Functions
Importing and Exporting
parentcount
ROUND
lookup
memberindex
minute
TRIM
WEIGHT
OLAPChildCount
cubereadwrite
OLAPMemberType
OLAPRoot
Fact Data Import Commands
missing
YEAR
int
exp
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
PV
min
ismissing
OLAPSliceSecurity
mod
OLAPFactSecurityPrivileges
hour
ipmt
child
ROOT
max
left
asreadwrite
OLAPRenameProperty
OLAPRenameMember
OLAPRenameAlias
OLAPNavigate
OLAPFormula
OLAPWriteMemberToCube
MDX
OLAPQuery
OLAPIsFormula
OLAPNavigateRW
char
code
OLAPRead
OLAPReadWrite
OLAPTable
Excel Paste Functions
ischildof
parent
PowerOLAP Cube Formula Grammar
Aggregate Weights
Define Hierarchy
Create Dimension Hierarchy
OLAPIsChildOf
OLAPIsParentOf
WEIGHT
OLAPWeight
PowerOLAP Cube Formula Grammar
parentcount
PowerOLAP Service Control Program
MDX
Enable Diagnostic Logging
Use Partial Field Member Name
Create a Time Dimension
Define Order
Use Partial Field Member Name
Create a Time Dimension
Creating the Measures Dimension
Use Partial Field Member Name
Administrator Topics
Creating a Local Database from the Synchronization Server
Partial Server Use for Database Creation from a Synchronization Server
Administrator Topics
Partial Server Use for Database Creation from a Synchronization Server
Administrator Topics
Partial Server Use for Database Creation from a Synchronization Server
OLAPCubeDimCount
OLAPDimensionSecurity
OLAPCubeDimension
OLAPCubeSecurity
How to Grant Database Privileges
Defining Users and Groups
Creating a Task (Internet Data Services)
Creating a Cube
Configuring PowerOLAP Server Service to Logon as User Account
Create the User Domain Account in the Active Directory
Accessing the Database by a User with Read-Only Rights
Create and define IDS task to Pull Fact Data from a Remote Cube
Register and Activate the PowerOLAP Version 8 Server
Advanced PowerOLAP Worksheet Functions
Secure Database
Register and Activate the PowerOLAP Client
Security Export/Import Feature
Enabling a Database for Security
Changes by Student in Read Write Group
Create and define IDS task to Push Fact Data from a Local Cube
OLAPCurrentUser
Add Users and Groups
Administrator Changes
Creating a PowerOLAP Database
Accessing a Secured Database
How to Create a Local Cube from a Remote Cube using IDS
Create a New Synchronization Server
Active Directory Authentication
Paste and Drill-Through Functions
PowerOLAP's Add-In Menuand Toolbar
Paste and Drill-Through Functions
Advanced PowerOLAP Worksheet Functions
PMT
PPMT
fv
PV
ipmt
PMT
PPMT
mid
lower
PROPER
upper
PPMT
ipmt
Extended Drill-Through
Mark Member as Persistent
Working with OLAP Exchange as Client in a Server Scenario
Additional Considerations for Data Preparation
Paste and Drill-Through Functions
Defining Users and Groups
Calculation Engines
Stack or Nest Dimensions
The Dimension Hierarchy Toolbar
Formula Syntax and Terminology
Dependencies
OLAPSave
PowerOLAP Scheduler
Assigning Meta Data Security Privileges
OLAPReadWrite
Process Cube for Fact or Meta Data Update
SUMMARY: The Dimension Hierarchy Toolbar
IF
Exercises
Caching
Cross-Cube Formula
Transfer Cube
OLAPDatabase/OLAPOpen
Additional Information
Internal Cube Formula
OLAPMemberCount
lookup
Creating Cube Formulas
Restoring a Database
Make Changes Offline and then Synchronize [Remote Capabilities]
Incremental Update vs. Update from Source
Accessing a Secured Database
Quick Start Introduction
Saving Your Work (.olt file)
Triggers and their use for Incremental Updating
Executing Cube Tasks in Excel
Dependencies
Enable Caching
PowerOLAP Service Control Program
Transaction Log
MDX
Set 3GB Startup Switch in Windows
Executing PowerOLAP Scheduler Job in Excel
OLAPNavigateRW
Cube Properties
Create a Time Dimension
Importing and Exporting
Incremental Update vs. Update from Source
OLAPWrite
level
OLAPIsChildOf
OLAPIsParentOf
OLAPFactSecurityPrivileges
parent
aliastomember
parentcount
child
level
OLAPIsChildOf
OLAPIsParentOf
current
memberindex
Define Order
Ramifications of Modify Relational Dimension
Persistent Members
Persistent Members
The Dimension Hierarchy Toolbar
Process Cube for Fact or Meta Data Update
SUMMARY: The Dimension Hierarchy Toolbar
Ramifications of Modify Relational Dimension
Mark Member as Persistent
Dependencies
Introduction to Formula Basic, Cube Formulas, Dependencies &
PowerOLAP Cube Formula Grammar
Define Order
Calculation Depth
Introduction to PowerOLAP's Persistent Calculations
User Considerations
Dependencies
Persistent Calculations - Design Mode Option
MDX
Dependencies
Introduction to Formula Basic, Cube Formulas, Dependencies &
PowerOLAP Cube Formula Grammar
Calculation Depth
User Considerations
Introduction to PowerOLAP's Persistent Calculations
Dependencies
Persistent Calculations - Design Mode Option
Introduction to PowerOLAP's Persistent Calculations
Persistent Calculations - Design Mode Option
Persistent Members
Process Cube for Fact or Meta Data Update
MDX
OLAPPivot
Zero Suppression
Database Reference Formulas
Advanced PowerOLAP Worksheet Functions
Rearranging Dimensions within a Slice
Arranging Slice Dimensions
PowerOLAP Client Installation
PowerOLAP MDB Server Installation
Set 3GB Startup Switch in Windows
SECOND
TIME
minute
hour
pmt
PowerOLAP Cube Formula Grammar
PPMT
fv
PV
fv
PV
Dynamic Multidimensional Graphs
Graph's Shortcut menu options
OLAPAliasGroupCount
OLAPPropertyGroupCount
Process Cube for Fact or Meta Data Update
Working with ODBC (Open Database Connectivity)
IDS Performance Considerations
current
asread
levelcount
member
oledbreadwrite
cuberead
Introduction to Formula Basic, Cube Formulas, Dependencies &
membercount
Creating a Cube
literal
dbread
Building & Updating Cubes that Support Incremental Updating
level
Create and define IDS task to Push Fact Data from a Local Cube
Constraints
REPT
RAND
oledbread
Create and define IDS task to Pull Fact Data from a Remote Cube
The OLAPPivot Function
currentindex
dbreadwrite
Importing and Exporting
memberindex
cubereadwrite
Creating Cube Formulas
Restoring a Database
Make Changes Offline and then Synchronize [Remote Capabilities]
Incremental Update vs. Update from Source
Database Reference Formulas
Calculation Depth
Importing Data from a File
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Working with Cubes
Triggers and their use for Incremental Updating
About Fact Data in Cubes
asreadwrite
SCAN
find
SCAN
find
OLAPUserInGroup
OLAPRootCount
OLAPFactSecurityMember
OLAPOpen
Administrator Topics
OLAPCubeDimCount
Working with ODBC (Open Database Connectivity)
Additional Considerations for Data Preparation
Paste and Drill-Through Functions
Create/Save a Dimension Subset
Select Page MembersUsing Edit Slice
Excel Integration
ISCHILDOF
WEEKDAY
OLAPAliasToMember
CURRENT
ASREAD
CHAR
Installing PowerOLAP MDB Server
OLAPWriteAliasToCube
OLAPFactSecurityRuleName
OLAPTable
Entering Data from within Excel
OLAPFactSecurityRuleCount
Create a New Linked Cube
Creating a Slice
Use Partial Field Member Name
Calculation Engines
Security Export/Import Feature
Persistent Members
NUMBER
NOW
MEMBER
LOG
LEVELCOUNT
LEN
OLEDBREADWRITE
CUBEREAD
ABS
ASIN
Enabling a Database for Security
OLAPSubsetCount
OLAPFactSecurityRule
OLAPFactSecurityRangeMembers
Creating Dimensions
Creating a Slice View
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Create a New Synchronization Server
Formula Syntax and Terminology
Member Types/ Hierarchy Dialog box
New Slice Menu & OLAPNavigate
Designer Slices can be Fully Formatted and Printed
OLAPDimensionSecurity
OLAPCubeDimension
PMT
SIN
Remove Existing Version
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
OLAPIsSecureDatabase
Make Changes On-line and then Synchronize
Creating a Task (Internet Data Services)
OLAPMember
Dependencies
OLAPTable
Select Row or Column Members Using Edit Slice
OLAPDimension
SIGN
DATE
OLAPMemberIndex
OLAPSave
OLAPPivot
OLAPRead
Register and Activate the PowerOLAP Version 8 Client
OLAPFactSecurityStatus
PowerOLAP Scheduler
Introduction to Formula Basic, Cube Formulas, Dependencies &
OLAPReadWrite
Member Properties
MEMBERCOUNT
MID
OLAPChild
PARENT
SUBSTITUTE
SQRT
PowerOLAP Service Control Program
OLAPSubsetMemberCount
Format Tab
Aggregate Weights
Process Cube for Fact or Meta Data Update
Creating a Cube
Formula Basics
Setting New Slice Options
RIGHT
REPLACE
OLAPAliasGroup
PROPERTY
SCAN
ALIAS
ACOS
CUBEDIMCOUNT
OLAPWrite
OLAPDimMaxLevel
OLAPReadWrite
Saving Changes to a Database
Installing Additional PowerOLAP Client Components
IDS – HTTP Interface and REST
Seeing Results in PowerOLAP (.olp file)
Cube Properties
Modify Relational Dimension
Add Members to 2nd, 3rd, etc Dimension
OLAPPivot
MONTH
ROOTCOUNT
COS
CODE
CHILDCOUNT
LITERAL
EXACT
DBREAD
Closing a Database
OLAPMemberLevel
OLAPParent
OLAPMemberProperty
Installation of the PowerOLAP Version 8 Client
OLAPGroup
Creating a Cube from the MDB Server Control Program
Building & Updating Cubes that Support Incremental Updating
Benefits Summary
PowerOLAP Cube Formula Grammar
PowerOLAP's Add-In Menuand Toolbar
Using Slices to Navigate Cubes
Aggregate Weights
FV
LOWER
LEVEL
OLAPDimCount
SECOND
OLAPCanAddDimensionAndCubes
PPMT
ALIASTOMEMBER
OLAPUser
Create and define IDS task to Push Fact Data from a Local Cube
Define Links—Snowflake Schema
Creating the Measures Dimension
Caching
Cross-Cube Formula
Entering Data through an Excel Worksheet
Transfer Cube
Slice View Formatting
REPT
ISERROR
OLAPCubeSecurity
RAND
CUBEDIM
OLAPMemberFirst
OLAPGroupCount
Synchronizing Changes Via Synchronization Server
Change Aliases
OLAPCube
Creating Cube Formulas
Add New Member to Display Results
Creating an Excel Worksheet
The Edit Slice Dialog Box
OLEDBREAD
OLAPCubeCount
FIND
ATAN
Define Hierarchy
OLAPSubsetMember
OLAPSubset
OLAPPropertyGroup
Creating an Excel Worksheet
Create and define IDS task to Pull Fact Data from a Remote Cube
When and why should you use IDS?
Creating a Local Database from the Synchronization Server
Requirements and Recommendations
Configure ODBC Data Source
The OLAPPivot Function
Saving / Launching PowerOLAP Databases from within Excel
LN
OLAPCurrentUser
Update Linked Cube
OLAPAlias
PROPER
TAN
DAY
CURRENTINDEX
OLAPFactSecurityMemberCount
OLAPIsParentOf
General Tab
Register and Activate the PowerOLAP Version 8 Server
OLAPIsChildOf
How to Update the Fact Data of Local Cube from Remote Cube
Additional Information
Introduction to PowerOLAP SCHEDULER
Define Drill Through
Change Hierarchy
Internal Cube Formula
Entering Data in a Slice
Rearranging Dimensions within a Slice
Dynamic Multidimensional Graphs
Advanced PowerOLAP Worksheet Functions
Excel Functions List
TIMESTRING
TODAY
TIME
UPPER
DBREADWRITE
Selecting a Page Member to View in Excel
Entering Data in a Slice
Assigning Fact Data Security Privileges
Slice Commands
Importing and Exporting
MINUTE
MEMBERINDEX
ROUND
LOOKUP
OLAPChildCount
PARENTCOUNT
WEIGHT
TRIM
OLAPMemberCount
CUBEREADWRITE
Adding a Server from within PowerOLAP
OLAPRoot
OLAPMemberType
Creating a PowerOLAP Database
Creating Cube Formulas
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Server Mode - PowerOLAP as Server to Analysis Services Cubes
Add/Delete Members in Measures Dimension
Define Rollups / Drill-Through with Rollups
Incremental Update vs. Update from Source
Applying Database Security
Fact Data Import Commands
MISSING
INT
YEAR
EXP
Summary of Quick Start Exercises
Accessing a Secured Database
OLAPWeight
OLAPUserGroupCount
OLAPUserCount
OLAPPropertyGroupCount
Extended Drill-Through
Calculation Depth
Changing Data Views from within Excel
Database Reference Formulas
MIN
ISMISSING
PV
OLAP AliasGroupCount
OLAPSliceSecurity
OLAPFactSecurityPrivileges
Quick Start Introduction
Importing Data from a File
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Conditional Retrieval
Introduction to PowerOLAP's Persistent Calculations
MOD
IPMT
HOUR
CHILD
How to Create a Local Cube from a Remote Cube using IDS
Concepts and Benefits
Creating a Cube via OLAP Exchange
Creating the 2nd Dimension
Triggers and their use for Incremental Updating
Mark Member as Persistent
About Meta Data
About Fact Data in Cubes
MAX
ROOT
LEFT
ASREADWRITE
IDS Performance Considerations
Meta Data Import Commands
Introduction to the PowerOLAP MDB Server
Stack or Nest Dimensions
The Dimension Hierarchy Toolbar
Creation of Ragged and Multiple Hierarchies
Cube Formula Functions
Other Task Types
Configuring PowerOLAP Server Service to Logon as User Account
Working with OLAP Exchange on the MDB Server
About PowerOLAP Services
Configuring the MDB Server for OLAP Exchange
Create the User Domain Account in the Active Directory
Delete a Subset
Model Cubes
Transaction Log
PowerOLAP MDB Server Installation
Add to or Remove Members from a Subset
Grid features Drill-Down on Members and Data within the Slice
PowerOLAP Scheduling Service
Concepts and Benefits / Requirements
Creating a Cube
Creating a New JOB
Secure Database
Define Aliases
Minimum Hardware Recommendations
Make Changes Offline and then Synchronize [Remote Capabilities]
Ramifications of Modify Relational Dimension
Rename a Subset
Executing Cube Tasks in Excel
Installation of PowerOLAPCOM
OLAPRenameProperty
Execute Cube Task and PowerOLAP Scheduler Job from Excel
Dependencies
OLAPRenameMember
Enable Caching
Synchronization Server database in SQL Server
OLAPRenameAlias
Cube Properties
OLAPNavigate
OLAPFormula
IDS - Internet Explorer Caching Setting
Execute a Scheduler Job
Active Directory Authentication
OLAPWriteMemberToCube
MDX
PowerOLAP Server Installation for Non-Admin Users
OLAPQuery
Save Dependencies to File
Set 3GB Startup Switch in Windows
OLAPIsFormula
Executing PowerOLAP Scheduler Job in Excel
Requirements and Recommendations
OLAPNavigateRW
Location of the Client Installer
PowerOLAP Client Installation for Non-Admin Users
Entering Data from within Excel
OLAPReadWrite
DBREADWRITE
Creating a PowerOLAP Database
Summary of Quick Start Exercises
Creating an Excel Worksheet
Advanced PowerOLAP Worksheet Functions
Register and Activate the PowerOLAP Version 8 Client
DBREAD
Create and define IDS task to Push Fact Data from a Local Cube
Create and define IDS task to Pull Fact Data from a Remote Cube
DBREADWRITE
Change Aliases
Change Hierarchy
Requirements and Recommendations
How to Create a Local Cube from a Remote Cube using IDS
Excel Integration
PowerOLAP's Add-In Menuand Toolbar
PowerOLAP Version 8 MDB Server Installation
Seeing Results in PowerOLAP (.olp file)
Installation of the PowerOLAP Version 8 Client
Caching
Hardware Requirements
Importing Data from a File
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Make Changes On-line and then Synchronize
Entering Data in a Slice
PowerOLAP Client Installation for Non-Admin Users
Make Changes On-line and then Synchronize
Entering Data in a Slice
Formula Basics
Additional Information
Introduction to the PowerOLAP MDB Server
Client Mode - PowerOLAP as Client to Analysis Services Cubes
PowerOLAP Scheduler
Installing Additional PowerOLAP Client Components
Installation of the PowerOLAP Client
IDS
Adding a Server from within PowerOLAP
Minimum Hardware Recommendations
Accessing a Secured Database
Installation of PowerOLAPCOM
PowerOLAP Server Installation for Non-Admin Users
PowerOLAP Client Installation for Non-Admin Users
Create a New Linked Cube
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Process Cube for Fact or Meta Data Update
About PowerOLAP Services
Model Cubes
Advanced PowerOLAP Worksheet Functions
Creating a Cube
Database Reference Formulas
Quick Start Introduction
Working with ODBC (Open Database Connectivity)
Entering Data from within Excel
Calculation Engines
log
cuberead
ABS
asin
Formula Syntax and Terminology
SIN
Cube Formula Functions
SQRT
Creating a Cube
acos
Seeing Results in PowerOLAP (.olp file)
cos
Building & Updating Cubes that Support Incremental Updating
PowerOLAP Cube Formula Grammar
atan
Update Linked Cube
ln
TAN
cubereadwrite
Incremental Update vs. Update from Source
int
exp
min
Creating the 2nd Dimension
Triggers and their use for Incremental Updating
max
Executing Cube Tasks in Excel
Cube Properties
MDX
Cube Formula Functions
Formula Syntax and Terminology
PowerOLAP Cube Formula Grammar
Formula Syntax and Terminology
Cube Formula Functions
Create a New Synchronization Server
Creating a Task (Internet Data Services)
Model Cubes
Saving / Launching PowerOLAP Databases from within Excel
Creating a PowerOLAP Database
Paste and Drill-Through Functions
Entering Data from within Excel
Create a New Linked Cube
Creating a Slice
Security Export/Import Feature
levelcount
cuberead
OLAPSave
PowerOLAP Scheduler
OLAPReadWrite
membercount
Creating a Cube
OLAPReadWrite
dbread
Using Slices to Navigate Cubes
Create and define IDS task to Push Fact Data from a Local Cube
Entering Data through an Excel Worksheet
OLAPDatabase/OLAPOpen
Synchronizing Changes Via Synchronization Server
Creating an Excel Worksheet
Creating an Excel Worksheet
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating a Local Database from the Synchronization Server
General Tab
Introduction to PowerOLAP SCHEDULER
Advanced PowerOLAP Worksheet Functions
Excel Functions List
dbreadwrite
Entering Data in a Slice
Secure Database
Importing and Exporting
cubereadwrite
Creating Cube Formulas
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Applying Database Security
Summary of Quick Start Exercises
Changing Data Views from within Excel
Database Reference Formulas
Defining an ODBC Data Source between PowerOLAP and a SQL Server
How to Create a Local Cube from a Remote Cube using IDS
About Fact Data in Cubes
About Meta Data
Executing Cube Tasks in Excel
OLAPRenameProperty
Execute Cube Task and PowerOLAP Scheduler Job from Excel
OLAPRenameMember
OLAPRenameAlias
OLAPNavigate
Active Directory Authentication
OLAPQuery
Executing PowerOLAP Scheduler Job in Excel
OLAPNavigateRW
Concepts and Benefits
OLAPSave
OLAPDatabase/OLAPOpen
Create a New Linked Cube
PowerOLAP Cube Formula Grammar
Caching
Transfer Cube
Create and define IDS task to Pull Fact Data from a Remote Cube
Introduction to PowerOLAP's Persistent Calculations
Cross-Cube Formula
MDX
Cube Formula Functions
Advanced PowerOLAP Worksheet Functions
Excel Functions List
Entering Data from within Excel
OLAPSave
OLAPDatabase/OLAPOpen
TIMESTRING
Server Mode - PowerOLAP as Server to Analysis Services Cubes
Concepts and Benefits / Requirements
Summary of Quick Start Exercises
Create a New Synchronization Server
Make Changes On-line and then Synchronize
Installing PowerOLAP MDB Server
Introduction to the PowerOLAP MDB Server
Remove Existing Version
Working with OLAP Exchange on the MDB Server
Installation of the PowerOLAP Client
Requirements and Recommendations
Transaction Log
PowerOLAP MDB Server Installation
Minimum Hardware Recommendations
Make Changes Offline and then Synchronize [Remote Capabilities]
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Concepts and Benefits
Introduction to the PowerOLAP MDB Server
Installing PowerOLAP MDB Server
Create a New Synchronization Server
Remove Existing Version
PowerOLAP Version 8 MDB Server Installation
Transaction Log
Make Changes Offline and then Synchronize [Remote Capabilities]
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Concepts and Benefits
Make Changes On-line and then Synchronize
Working with OLAP Exchange on the MDB Server
PowerOLAP Client Installation
Requirements and Recommendations
New Slice Menu & OLAPNavigate
PowerOLAP's Add-In Menuand Toolbar
Delete a Subset
Saving / Launching PowerOLAP Databases from within Excel
Add to or Remove Members from a Subset
Extended Drill-Through
Database Reference Formulas
Rename a Subset
Executing Cube Tasks in Excel
Executing PowerOLAP Scheduler Job in Excel
PowerOLAP Client Installation for Non-Admin Users
IDS Performance Considerations
Dependencies
Quick Start Introduction
Introduction to PowerOLAP's Persistent Calculations
About Meta Data
Dependencies
Create a New Synchronization Server
Fact Data Import Commands
Client Mode - PowerOLAP as Client to Analysis Services Cubes
New Slice Menu & OLAPNavigate
IDS
Summary of Quick Start Exercises
Mark Member as Persistent
Execute Cube Task and PowerOLAP Scheduler Job from Excel
Saving / Launching PowerOLAP Databases from within Excel
Importing and Exporting
Concepts and Benefits / Requirements
Incremental Update vs. Update from Source
Creating a Cube via OLAP Exchange
PowerOLAP Scheduler
Other Task Types
Introduction to PowerOLAP SCHEDULER
PowerOLAP Scheduling Service
Creating a New JOB
Introduction to PowerOLAP SCHEDULER
PowerOLAP Scheduling Service
Introduction to the PowerOLAP MDB Server
Installing PowerOLAP MDB Server
Create a New Synchronization Server
Remove Existing Version
PowerOLAP Service Control Program
Configuring PowerOLAP Server Service to Logon as User Account
DBREAD
Creating a Local Database from the Synchronization Server
DBREADWRITE
Adding a Server from within PowerOLAP
How to Create a Local Cube from a Remote Cube using IDS
Creating a Cube from the MDB Server Control Program
Register and Activate the PowerOLAP Server
Configuring the MDB Server for OLAP Exchange
IDS
Create the User Domain Account in the Active Directory
PowerOLAP MDB Server Installation
Create and define IDS task to Pull Fact Data from a Remote Cube
Accessing a Secured Database
IDS - Internet Explorer Caching Setting
Active Directory Authentication
PowerOLAP Server Installation for Non-Admin Users
Requirements and Recommendations
Location of the Client Installer
PowerOLAP Client Installation for Non-Admin Users
Concepts and Benefits
Creating a Cube from the MDB Server Control Program
Register and Activate the PowerOLAP Version 8 Server
Remove Existing Version
PowerOLAP Service Control Program
Remove Existing Version
PowerOLAP Service Control Program
Configuring PowerOLAP Server Service to Logon as User Account
Register and Activate the PowerOLAP Server
Configuring PowerOLAP Server Service to Logon as User Account
Configuring the MDB Server for OLAP Exchange
Create the User Domain Account in the Active Directory
Configuring PowerOLAP Server Service to Logon as User Account
Configuring the MDB Server for OLAP Exchange
Create the User Domain Account in the Active Directory
Create a New Synchronization Server
Remove Existing Version
Make Changes On-line and then Synchronize
PowerOLAP Service Control Program
Make Changes Offline and then Synchronize [Remote Capabilities]
PowerOLAP Server Installation for Non-Admin Users
Create a New Linked Cube
Client Mode - PowerOLAP as Client to Analysis Services Cubes
About PowerOLAP Services
Update Linked Cube
Additional Information
Create a New Synchronization Server
Remove Existing Version
Make Changes On-line and then Synchronize
PowerOLAP Service Control Program
Make Changes Offline and then Synchronize [Remote Capabilities]
Register and Activate the PowerOLAP Server
PowerOLAP Server Installation for Non-Admin Users
Member Types/ Hierarchy Dialog box
Entering Data through an Excel Worksheet
Creating an Excel Worksheet
Grid features Drill-Down on Members and Data within the Slice
Changing Data Views from within Excel
Excel Integration
Paste and Drill-Through Functions
OLAPReadWrite
Creating an Excel Worksheet
General Tab
Make Changes Offline and then Synchronize [Remote Capabilities]
PowerOLAP's Add-In Menuand Toolbar
Extended Drill-Through
Advanced PowerOLAP Worksheet Functions
Stack or Nest Dimensions
Configure ODBC Data Source
Concepts and Benefits / Requirements
IDS
Creating an Excel Worksheet
Concepts and Benefits
Persistent Members
Triggers and their use for Incremental Updating
About Fact Data in Cubes
Introduction to the PowerOLAP MDB Server
Calculation Engines
Introduction to Formula Basic, Cube Formulas, Dependencies &
About PowerOLAP Services
Hardware Requirements
Introduction to PowerOLAP SCHEDULER
Concepts and Benefits / Requirements
Importing and Exporting
Applying Database Security
Quick Start Introduction
Working with ODBC (Open Database Connectivity)
Additional Considerations for Data Preparation
Hardware Requirements
Register and Activate the PowerOLAP Client
Introduction to the PowerOLAP MDB Server
Hardware Requirements
Make Changes Offline and then Synchronize [Remote Capabilities]
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Concepts and Benefits
Concepts and Benefits / Requirements
Importing and Exporting
Incremental Update vs. Update from Source
Creating a Cube via OLAP Exchange
Introduction to PowerOLAP SCHEDULER
PowerOLAP Scheduler
Other Task Types
Installing Additional PowerOLAP Client Components
PowerOLAP Scheduling Service
Creating a New JOB
Execute Cube Task and PowerOLAP Scheduler Job from Excel
Creating a Task
Execute a Scheduler Job
Importing and Exporting
Executing PowerOLAP Scheduler Job in Excel
PowerOLAP Cube Formula Grammar
PPMT
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Dependencies Grammar
User Considerations
Seeing Results in PowerOLAP (.olp file)
Fact Data Import Commands
Creating the 2nd Dimension
Creating a Cube
Allow Duplicates
Define Links—Snowflake Schema
Define Links—Star Schema
Preparing Relational Data for Use with OLAP Exchange
Define Links—Snowflake Schema
Define Links—Star Schema
Define AliasesCreate an Alias Group
Paste and Drill-Through Functions
Define PropertiesCreate a Properties Group
Define AliasesCreate an Alias Group
Define PropertiesCreate a Properties Group
Paste and Drill-Through Functions
Select Page MembersUsing Edit Slice
Entering Data from within Excel
Stack or Nest Dimensions
Creating a Slice View
Cube Properties
Zero Suppression
Creating Cube Formulas
Entering Data in a Slice
Rearranging Dimensions within a Slice
Slice Commands
Creating Cube Formulas
Changing Data Views from within Excel
Database Reference Formulas
Paste and Drill-Through Functions
Stack or Nest Dimensions
Zero Suppression
Creating Cube Formulas
Entering Data in a Slice
Database Reference Formulas
Paste and Drill-Through Functions
Create a New Synchronization Server
Creating a Dimension Hierarchy
SUMMARY: The Dimension Hierarchy Toolbar
OLAPPivot
Creating an Excel Worksheet
General Tab
Paste and Drill-Through Functions
SUMMARY: The Dimension Hierarchy Toolbar
Define Order
Define Links—Star Schema
Creating the Measures Dimension
Define Hierarchy
Conditional Retrieval
Creating the Measures Dimension
Define Links—Star Schema
Conditional Retrieval
Define Links—Star Schema
Conditional Retrieval
Calculation Engines
Assigning Meta Data Security Privileges
Entering Data in a Slice
Assigning Fact Data Security Privileges
Importing and Exporting
Calculation Depth
General Formatting and Printing
Designer Slices can be Fully Formatted and Printed
Dynamic Multidimensional Graphs
OLAPCubeSecurity
Secure Database
Assigning Database Privileges
Working with OLAP Exchange as Client in a Server Scenario
Defining Users and Groups
Security Export/Import Feature
Assigning Meta Data Security Privileges
Granting Cube Security Rights
Granting Dimensions Meta Security Rights
Installation of the PowerOLAP Client
Assigning Fact Data Security Privileges
Excel Paste Functions
Applying Database Security
Fact Data Security Ranges
OLAPSliceSecurity
OLAPFactSecurityPrivileges
Register and Activate the PowerOLAP Server
Active Directory Authentication
Importing and Exporting
Working with OLAP Exchange on the MDB Server
Add to or Remove Members from a Subset
Working with OLAP Exchange as Client in a Server Scenario
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Building & Updating Cubes that Support Incremental Updating
Define Order
Incremental Update vs. Update from Source
Extended Drill-Through
Ramifications of Modify Relational Dimension
Mark Member as Persistent
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Incremental Update vs. Update from Source
Entering Data in a Slice
Importing and Exporting
Excel Integration
Stack or Nest Dimensions
Define Properties
Create Additional Tables
Assigning Meta Data Security Privileges
Allow Duplicates
Add Members to 2nd, 3rd, etc Dimension
Seeing Results in PowerOLAP (.olp file)
OLAPPivot
Define Order
Creating the Measures Dimension
Define LinksStar Schema
Cross-Cube Formula
Define Hierarchy Creating Dimension Hierarchies
Entering Data in a Slice
Rearranging Dimensions within a Slice
Assigning Fact Data Security Privileges
Importing and Exporting
Define Aliases
MDX
Extended Drill-Through
Changing Data Views from within Excel
Database Reference Formulas
Conditional Retrieval
Creating the 2nd Dimension
Define Members
Add Members to 2nd, 3rd, etc Dimension
Define Order
Define LinksStar Schema
Define Members
Add Members to 2nd, 3rd, etc Dimension
Define Order
Conditional Retrieval
Entering Data in a Slice
Assigning Fact Data Security Privileges
Importing and Exporting
Create Additional Tables
OLAPReadWrite
Add Members to 2nd, 3rd, etc Dimension
Define Order
Creating the 3rd and Further Dimensions
Define Hierarchy
Entering Data in a Slice
MDX
Conditional Retrieval
Additional Considerations for Data Preparation
Create Additional Tables
Define LinksStar Schema
OLAPNavigate
Advanced PowerOLAP Worksheet Functions
Creating a PowerOLAP Database
OLAPQuery
Requirements and Recommendations
Importing Data from a File
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Create the SQL Server Login
Remove Existing Version
PowerOLAP Service Control Program
Creating a Cube from the MDB Server Control Program
Creating a PowerOLAP Database
PowerOLAP Cube Formula Grammar
PROPER
Property Groups
Member Properties
Cube Properties
Define Properties
Property Groups
Member Properties
PROPERTY
OLAPMemberProperty
OLAPPropertyGroup
Creating the 3rd and Further Dimensions
Change Hierarchy
Change Properties
Importing and Exporting
Define Properties—Create a Properties Group
OLAPPropertyGroupCount
About Meta Data
Meta Data Import Commands
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
PowerOLAP Cube Formula Grammar
Excel Paste Functions
OLAPRenameProperty
The Edit Slice Dialog Box
Meta Data Import Commands
Cube Formula Functions
Property Groups
Member Properties
Process Cube for Fact or Meta Data Update
SUMMARY: The Dimension Hierarchy Toolbar
PROPERTY
Cube Properties
PowerOLAP Cube Formula Grammar
OLAPPropertyGroup
Change Hierarchy
Change Properties
Define Aliases
Define Properties—Create a Properties Group
OLAPPropertyGroupCount
Define Properties
The Dimension Hierarchy Toolbar
Process Cube (Rebuild Cube)
Access Privileges
OLAPMemberProperty
The Edit Slice Dialog Box
Creating the 3rd and Further Dimensions
Define Links
Excel Paste Functions
Importing and Exporting
Minimum Hardware Recommendations
Migrating OLP Databases with Cubes Built from OLAP Exchange,
About Meta Data
Create the SQL Server Login
OLAPRenameProperty
Cube Properties
Register and Activate the PowerOLAP Server
lookup
Set 3GB Startup Switch in Windows
PROPERTY
Process Cube for Fact or Meta Data Update
Change Hierarchy
Change Properties
OLAPPropertyGroup
OLAPRenameProperty
Property Groups
Member Properties
OLAPMemberProperty
OLAPPropertyGroup
Creating a Task (Internet Data Services)
Dependencies
OLAPReadWrite
Secure Database
Assigning Fact Data Security Privileges
Working with ODBC (Open Database Connectivity)
OLAPRootCount
OLAPUserInGroup
Working with OLAP Exchange as Client in a Server Scenario
Meta Data Import Commands
Select Page MembersUsing Edit Slice
OLAPFactSecurityMember
OLAPCubeDimCount
WEEKDAY
OLAPAliasToMember
char
Introduction to the PowerOLAP MDB Server
OLAPTable
OLAPWriteAliasToCube
Create a New Linked Cube
Use Partial Field Member Name
Defining Users and Groups
Security Export/Import Feature
OLAPFactSecurityRuleCount
OLAPFactSecurityRuleName
Portal Tab
OLAPSubsetCount
Creating a Slice View
OLAPFactSecurityRangeMembers
Formula Syntax and Terminology
Member Types/ Hierarchy Dialog box
OLAPFactSecurityRule
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
Use SQL Views
Assigning Meta Data Security Privileges
Introduction to Formula Basic, Cube Formulas, Dependencies &
OLAPFactSecurityStatus
OLAPChild
Creating a Cube
OLAPSubsetMemberCount
Allow Duplicates
SCAN
OLAPAliasGroup
Saving Changes to a Database
Changes by Student in Read Write Group
OLAPReadWrite
OLAPWrite
OLAPPivot
OLAPDimMaxLevel
exact
code
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
Building & Updating Cubes that Support Incremental Updating
PowerOLAP's Add-In Menuand Toolbar
lower
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
OLAPUser
Register and Activate the PowerOLAP Server
Caching
OLAPCubeSecurity
iserror
Granting Dimensions Meta Security Rights
OLAPDatabase/OLAPOpen
OLAPMemberFirst
OLAPGroupCount
OLAPCube
OLAPCubeCount
find
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Creating a Local Database from the Synchronization Server
Define Hierarchy
OLAPCurrentUser
OLAPAlias
Licensing Tab
Define Drill Through
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Dynamic Multidimensional Graphs
Create Dimension Hierarchy
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIME
Excel Functions List
upper
Add Users and Groups
OLAPMemberCount
Importing and Exporting
OLAPChildCount
OLAPMemberType
OLAPRoot
Incremental Update vs. Update from Source
Applying Database Security
Fact Data Import Commands
YEAR
Accessing a Secured Database
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
Database Reference Formulas
OLAPSliceSecurity
Hierarchy
OLAPFactSecurityPrivileges
Creating a Cube via OLAP Exchange
Concepts and Benefits
Mark Member as Persistent
OLAPRenameProperty
Dependencies
OLAPRenameMember
Enable Caching
OLAPRenameAlias
OLAPNavigate
OLAPFormula
Active Directory Authentication
OLAPWriteMemberToCube
OLAPQuery
OLAPIsFormula
OLAPNavigateRW
Assigning Fact Data Security Privileges
Database Reference Formulas
OLEDBREADWRITE
OLEDBREAD
oledbreadwrite
oledbread
Create and define IDS task to Pull Fact Data from a Remote Cube
When and why should you use IDS?
Conditional Retrieval
OLEDBREADWRITE
Conditional Retrieval
How to Create a Local Cube from a Remote Cube using IDS
Calculation Engines
Caching
Enable Caching
Create and define IDS task to Push Fact Data from a Local Cube
When and why should you use IDS?
Create and define IDS task to Pull Fact Data from a Remote Cube
pmt
PowerOLAP Cube Formula Grammar
PPMT
fv
PV
ipmt
PV
ipmt