Process Cube for Fact or Meta Data Update
Synchronizing Changes Via Synchronization Server
Importing and Exporting
Incremental Update vs. Update from Source
Paste and Drill-Through Functions
OLAPFactSecurityMember
current
ischildof
Create a New Linked Cube
Defining Users and Groups
Security Export/Import Feature
OLAPFactSecurityRuleCount
Calculation Engines
levelcount
member
oledbreadwrite
OLAPFactSecurityRuleName
Create a New Synchronization Server
OLAPFactSecurityRangeMembers
Member Types/ Hierarchy Dialog box
OLAPFactSecurityRule
Make Changes On-line and then Synchronize
Dependencies
OLAPTable
SIGN
Error File Reporting
Process Cube (Rebuild Cube)
Assigning Meta Data Security Privileges
OLAPReadWrite
parent
membercount
OLAPFactSecurityStatus
Creating a Cube
Allow Duplicates
PROPERTY
cubedimcount
alias
Changes by Student in Read Write Group
Granting Cube Security Rights
Cube Properties
Seeing Results in PowerOLAP (.olp file)
OLAPPivot
ROOTCOUNT
literal
childcount
Access Privileges
level
aliastomember
Creating the Measures Dimension
Create and define IDS task to Push Fact Data from a Local Cube
Define Order
Create a Time Dimension
Caching
Cross-Cube Formula
Transfer Cube
iserror
cubedim
IDS
Model Cubes
Update Linked Cube
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating a Local Database from the Synchronization Server
Define Hierarchy
Configure ODBC Data Source
The OLAPPivot Function
currentindex
How to Update the Fact Data of Local Cube from Remote Cube
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Internal Cube Formula
Create Dimension Hierarchy
OLAPFactSecurityMemberCount
Excel Functions List
dbreadwrite
Change Properties
Assigning Fact Data Security Privileges
Secure Database
parentcount
lookup
memberindex
WEIGHT
Restoring a Database
Add/Delete Members in Measures Dimension
Make Changes Offline and then Synchronize [Remote Capabilities]
Define Rollups / Drill-Through with Rollups
Applying Database Security
Fact Data Security Ranges
Fact Data Import Commands
Extended Drill-Through
Assigning Database Privileges
Database Reference Formulas
ismissing
Importing Data from a File
Quick Start Introduction
Conditional Retrieval
Introduction to PowerOLAP's Persistent Calculations
Working with Cubes
OLAPFactSecurityPrivileges
child
Creating a Cube via OLAP Exchange
Creating the 2nd Dimension
Triggers and their use for Incremental Updating
About Fact Data in Cubes
About Meta Data
ROOT
asreadwrite
Executing Cube Tasks in Excel
Dependencies
Synchronization Server database in SQL Server
Cube Properties
OLAPNavigate
Transaction Log
Active Directory Authentication
MDX
OLAPQuery
Executing PowerOLAP Scheduler Job in Excel
Concepts and Benefits
Paste and Drill-Through Functions
Create a New Linked Cube
Security Export/Import Feature
Defining Users and Groups
Create a New Synchronization Server
Member Types/ Hierarchy Dialog box
Make Changes On-line and then Synchronize
OLAPTable
Error File Reporting
Process Cube (Rebuild Cube)
Assigning Meta Data Security Privileges
OLAPReadWrite
Process Cube for Fact or Meta Data Update
Creating a Cube
IDS – HTTP Interface and REST
Seeing Results in PowerOLAP (.olp file)
Cube Properties
OLAPPivot
Create and define IDS task to Push Fact Data from a Local Cube
Creating the Measures Dimension
Model Cubes
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating a Local Database from the Synchronization Server
The OLAPPivot Function
Saving / Launching PowerOLAP Databases from within Excel
Update Linked Cube
How to Update the Fact Data of Local Cube from Remote Cube
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Define Hierarchy— Creating Dimension Hierarchies
Secure Database
Assigning Fact Data Security Privileges
Importing and Exporting
Restoring a Database
Make Changes Offline and then Synchronize [Remote Capabilities]
Incremental Update vs. Update from Source
Applying Database Security
Fact Data Import Commands
Assigning Database Privileges
Database Reference Formulas
Quick Start Introduction
Importing Data from a File
Conditional Retrieval
Working with Cubes
Creating the 2nd Dimension
Triggers and their use for Incremental Updating
About Meta Data
About Fact Data in Cubes
current
ischildof
levelcount
member
SIGN
parent
membercount
PROPERTY
cubedimcount
alias
Granting Cube Security Rights
ROOTCOUNT
literal
childcount
Access Privileges
level
aliastomember
Caching
Transfer Cube
iserror
cubedim
currentindex
parentcount
lookup
memberindex
WEIGHT
Fact Data Security Ranges
ismissing
Introduction to PowerOLAP's Persistent Calculations
child
ROOT
Executing Cube Tasks in Excel
Synchronization Server database in SQL Server
Cube Properties
OLAPNavigate
Transaction Log
Active Directory Authentication
MDX
OLAPQuery
Executing PowerOLAP Scheduler Job in Excel
OLAPTable
OLAPReadWrite
OLAPPivot
Creating a Cube
Triggers and their use for Incremental Updating
Assigning Fact Data Security Privileges
Applying Database Security
Entering Data in a Slice
Make Changes Offline and then Synchronize [Remote Capabilities]
Assigning Fact Data Security Privileges
Model Cubes
Entering Data in a Slice
Process Cube for Fact or Meta Data Update
Secure Database
Importing and Exporting
Fact Data Import Commands
current
currentindex
Assigning Fact Data Security Privileges
Applying Database Security
Defining Users and Groups
Assigning Database Privileges
Assigning Fact Data Security Privileges
Applying Database Security
Assigning Fact Data Security Privileges
Security Export/Import Feature
Assigning Meta Data Security Privileges
Granting Cube Security Rights
Access Privileges
Caching
Model Cubes
Fact Data Security Ranges
Active Directory Authentication
Assigning Fact Data Security Privileges
Assigning Meta Data Security Privileges
Assigning Fact Data Security Privileges
Granting Cube Security Rights
Caching
Granting Cube Security Rights
Caching
Assigning Fact Data Security Privileges
Granting Cube Security Rights
Changes by Student in Read Write Group
Caching
OLAPFactSecurityMember
OLAPFactSecurityRuleCount
OLAPFactSecurityRuleName
OLAPFactSecurityRangeMembers
OLAPFactSecurityRule
OLAPFactSecurityStatus
OLAPFactSecurityMemberCount
Assigning Fact Data Security Privileges
OLAPFactSecurityPrivileges
Granting Cube Security Rights
Caching
Assigning Fact Data Security Privileges
OLAPFactSecurityMember
OLAPFactSecurityRuleCount
OLAPFactSecurityRuleName
OLAPFactSecurityRangeMembers
OLAPFactSecurityRule
OLAPFactSecurityStatus
OLAPFactSecurityMemberCount
OLAPFactSecurityPrivileges
OLAPFactSecurityMember
OLAPFactSecurityMemberCount
Creating Notification
Use Partial Field Member Name
MDX
OLAPUserInGroup
ISCHILDOF
OLAPSave
IF
ISERROR
AND
OLAPIsParentOf
OLAPIsChildOf
OR
LOOKUP
ISMISSING
NOT
exact
PowerOLAP Cube Formula Grammar
OLAPCanAddDimensionAndCubes
Internal Cube Formula
OLAPIsFormula
IF
AND
OR
NOT
IF
Internal Cube Formula
IF
PowerOLAP Cube Formula Grammar
Define Members
Define Aliases—Create an Alias Group
Cube Properties
Creating the Measures Dimension
Create a Time Dimension
Define Order
Define Members
Define Drill Through
Define Hierarchy— Creating Dimension Hierarchies
Define Properties—Create a Properties Group
Extended Drill-Through
Conditional Retrieval
About Meta Data
Define Members
Define Aliases
Creating the Measures Dimension
Define Members
Define Properties
Change Properties
Conditional Retrieval
Define Order
Change Aliases
Change Hierarchy
Conditional Retrieval
Define Links
Change Properties
Define Members
Define Aliases
Meta Data Import Commands
Member Aliases & Alias Groups
WEEKDAY
char
Use Partial Field Member Name
Property Groups
Create Additional Tables
Save Blank Members as [Undefined]
Allow Duplicates
Process Cube for Fact or Meta Data Update
Cube Properties
Add Members to 2nd, 3rd, etc Dimension
code
Benefits Summary
Building & Updating Cubes that Support Incremental Updating
Creating the Measures Dimension
Define Links
Define Order
Create a Time Dimension
Define Members
Change Aliases
Define Properties
Transaction Log
Define Hierarchy
Define Hierarchy
Define Drill Through
Change Hierarchy
Advanced PowerOLAP Worksheet Functions
TIMESTRING
Concepts and Benefits / Requirements
Change Properties
Slice Commands
Define Aliases
Define Rollups / Drill-Through with Rollups
YEAR
Extended Drill-Through
Alias Groups
Conditional Retrieval
Creating a Cube via OLAP Exchange
Triggers and their use for Incremental Updating
About Meta Data
PowerOLAP Service Control Program
General Tab
Member Types/ Hierarchy Dialog box
Dependencies
Saving Changes to a Database
Closing a Database
Model Cubes
Restoring a Database
Security Export/Import Feature
Creating a Local Database from the Synchronization Server
Creating a PowerOLAP Database
Create a New Synchronization Server
OLAPSave
OLAPDatabase/OLAPOpen
Importing and Exporting
Fact Data Import Commands
OLAPNavigate
MDX
OLAPQuery
Error File Reporting
Allow Duplicates
Seeing Results in PowerOLAP (.olp file)
Define Links
Seeing Results in PowerOLAP (.olp file)
Exercises
Creating a Local Database from the Synchronization Server
Saving / Launching PowerOLAP Databases from within Excel
Entering Data in a Slice
Importing and Exporting
Adding a Server from within PowerOLAP
Creating a PowerOLAP Database
Accessing a Secured Database
Importing Data from a File
Meta Data Import Commands
char
To add a database to the Server:
Security Export/Import Feature
Create a New Synchronization Server
Creating a Task (Internet Data Services)
OLAPSave
PowerOLAP Scheduler
Other Task Types
Error File Reporting
Allow Duplicates
Saving Changes to a Database
Installing Additional PowerOLAP Client Components
Modify Relational Dimension
OLAPPivot
Closing a Database
Define Links
OLAPDatabase/OLAPOpen
Installation of the PowerOLAP Client
Model Cubes
Transaction Log
Define Hierarchy
PowerOLAP MDB Server Installation
General Tab
Advanced PowerOLAP Worksheet Functions
Internal Cube Formula
Excel Paste Functions
Add/Delete Members in Measures Dimension
Fact Data Import Commands
Summary of Quick Start Exercises
Database Reference Formulas
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Graph's Shortcut menu options
Saving Your Work (.olt file)
General Formatting and Printing
Grid Shortcut Menu Options
Synchronization Server database in SQL Server
Cube Properties
Cube Properties
OLAPNavigate
Creating a Cube from the MDB Server Control Program
Save Cache to File
IDS - Internet Explorer Caching Setting
Persistent Calculations - Design Mode Option
The Edit Slice Dialog Box
Dynamic Multidimensional Graphs
Creating Cube Formulas
Restoring a Database
MDX
PowerOLAP Server Installation for Non-Admin Users
OLAPQuery
Save Dependencies to File
Set 3GB Startup Switch in Windows
Executing PowerOLAP Scheduler Job in Excel
Requirements and Recommendations
Quick Start Introduction
OLAPNavigateRW
How to Create a Local Cube from a Remote Cube using IDS
Location of the Client Installer
PowerOLAP Client Installation for Non-Admin Users
About Fact Data in Cubes
Cube Properties
Save Cache to File
Saving / Launching PowerOLAP Databases from within Excel
Entering Data in a Slice
Changing Data Views from within Excel
Cube Formula Functions
OLAPSave
Creating a Cube
REPT
OLAPDatabase/OLAPOpen
Entering Data in a Slice
Dynamic Multidimensional Graphs
Excel Functions List
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Member Types/ Hierarchy Dialog box
Internal Cube Formula
Assigning Fact Data Security Privileges
The Edit Slice Dialog Box
Importing and Exporting
Additional Considerations for Data Preparation
OLAPFactSecurityMember
OLAPWriteAliasToCube
Creating a Slice View
pmt
OLAPMemberToAlias
OLAPMemberNext
OLAPRead
OLAPPivot
OLAPMemberIndex
Working with OLAP Exchange on the MDB Server
OLAPReadWrite
OLAPWrite
OLAPMemberProperty
OLAPMemberLevel
fv
Creating a Local Database from the Synchronization Server
OLAPFactSecurityMemberCount
missing
PV
Hierarchy
ipmt
OLAPWriteMemberToCube
ABS
Slice Commands
OLAPFormula
pmt
PPMT
fv
PV
ipmt
Granting Cube Security Rights
Cross-Cube Formula
ABS
Granting Slices Meta Security Rights
Granting Cube Security Rights
Cross-Cube Formula
Cube Formula Functions
PowerOLAP Cube Formula Grammar
FIND
SCAN
find
SCAN
find
Installing PowerOLAP MDB Server
Create a New Linked Cube
Use Partial Field Member Name
PowerOLAP Version 8 MDB Server Installation
Add Members to 2nd, 3rd, etc Dimension
Installation of the PowerOLAP Version 8 Client
Create and define IDS task to Push Fact Data from a Local Cube
Set the Frequency of the Scheduled Job/Task
Define Order
Change Aliases
Define Hierarchy
Configure ODBC Data Source
Define Drill Through
Change Hierarchy
Entering Data in a Slice
Define Hierarchy— Creating Dimension Hierarchies
Add/Delete Members in Measures Dimension
Define Rollups / Drill-Through with Rollups
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Conditional Retrieval
How to Create a Local Cube from a Remote Cube using IDS
Zero Suppression
Transfer Cube
Internal Cube Formula
Importing and Exporting
Calculation Depth
Installation of PowerOLAPCOM
OLAPFormula
Create and define IDS task to Pull Fact Data from a Remote Cube
Modify or Delete Existing Jobs
OLAPIsFormula
PowerOLAP Client Installation for Non-Admin Users
Transfer Cube
Configure ODBC Data Source
Importing and Exporting
Register and Activate the PowerOLAP Version 8 Client
Register and Activate the PowerOLAP Version 8 Server
Define Hierarchy
Register and Activate the PowerOLAP Client
Meta Data Import Commands
OLAPCubeDimCount
Creating a Slice
Create a New Linked Cube
OLAPRenameProperty
Defining Users and Groups
Calculation Engines
OLAPTable
number
Creating a Slice View
Create a New Synchronization Server
Member Types/ Hierarchy Dialog box
New Slice Menu & OLAPNavigate
OLAPDimensionSecurity
OLAPCubeDimension
Remove Existing Version
OLAPRenameMember
Enable Caching
Make Changes On-line and then Synchronize
OLAPTable
Select Row or Column Members Using Edit Slice
Model Dimensions
date
Process Cube (Rebuild Cube)
Assigning Meta Data Security Privileges
OLAPReadWrite
OLAPPivot
mid
Save Blank Members as [Undefined]
Process Cube for Fact or Meta Data Update
Working with OLAP Exchange on the MDB Server
Granting Slices Meta Security Rights
Formula Basics
SCAN
cubedimcount
PowerOLAP Client Installation
Add Members to 2nd, 3rd, etc Dimension
OLAPRenameAlias
OLAPNavigate
OLAPPivot
code
exact
Building & Updating Cubes that Support Incremental Updating
Closing a Database
Creating a Task
Define Order
Create a Time Dimension
Creating the Measures Dimension
Create and define IDS task to Push Fact Data from a Local Cube
OLAPFormula
Cross-Cube Formula
Caching
OLAPCubeSecurity
cubedim
iserror
Changing the Grid Layout
Creating Cube Formulas
Add New Member to Display Results
Model Cubes
OLAPMemberFirst
find
Configure ODBC Data Source
Creating an Excel Worksheet
Transaction Log
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
Change Hierarchy
Define LinksSnowflake Schema
Additional Information
Rearranging Dimensions within a Slice
Internal Cube Formula
Dynamic Multidimensional Graphs
Excel Functions List
Excel Paste Functions
Secure Database
Importing and Exporting
Slice Commands
lookup
Define Rollups / Drill-Through with Rollups
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Creating Cube Formulas
Creating a PowerOLAP Database
Restoring a Database
MDX
OLAPQuery
Make Changes Offline and then Synchronize [Remote Capabilities]
Fact Data Import Commands
Summary of Quick Start Exercises
Extended Drill-Through
Accessing a Secured Database
Changing Data Views from within Excel
Database Reference Formulas
Calculation Depth
Conditional Retrieval
Define Member Options
Quick Start Introduction
Arranging Slice Dimensions
Defining an ODBC Data Source between PowerOLAP and a SQL Server
OLAPNavigateRW
Creating the 2nd Dimension
Creating a Cube via OLAP Exchange
How to Create a Local Cube from a Remote Cube using IDS
PowerOLAP Client Installation for Non-Admin Users
About Meta Data
left
Configure ODBC Data Source
Internal Cube Formula
Assigning Meta Data Security Privileges
Define Order
OLAPNavigate
OLAPQuery
OLAPNavigate
OLAPQuery
Granting Slices Meta Security Rights
Granting Cube Security Rights
Granting Dimensions Meta Security Rights
Add Users and Groups
Granting Rights to Add Dimensions and Cubes
Security Export/Import Feature
Creating Dimensions
Creating a Slice View
Create a New Synchronization Server
Save Slice
Creating a Task (Internet Data Services)
Other Task Types
Assigning Meta Data Security Privileges
Formula Basics
Setting New Slice Options
Selecting Page Members
OLAPPivot
PowerOLAP Cube Formula Grammar
Caching
The Edit Slice Dialog Box
Creating a PowerOLAP Database
Creating Cube Formulas
Define Rollups / Drill-Through with Rollups
Creating the 2nd Dimension
Formula Basics
Creating Cube Formulas
Designer Slices can be Fully Formatted and Printed
Slice View Formatting
Format Tab
Setting New Slice Options
asread
oledbreadwrite
oledbread
asreadwrite
Create a New Linked Cube
Additional Information
asread
oledbreadwrite
oledbread
OLAPFactSecurityRangeMembers
PROPERTY
childcount
Cross-Cube Formula
WEIGHT
parentcount
Mark Member as Persistent
Importing and Exporting
Define Members
char
OLAPTable
ABS
OLAPFactSecurityRule
SIN
Make Changes On-line and then Synchronize
OLAPTable
date
OLAPPivot
Error File Reporting
Formula Basics
month
exact
code
PowerOLAP Cube Formula Grammar
SECOND
lower
Dependencies Grammar
day
upper
minute
hour
Triggers and their use for Incremental Updating
MDX
Grid Shortcut Menu Options
General Formatting and Printing
New Slice Menu & OLAPNavigate
Designer Slices can be Fully Formatted and Printed
Format Tab
Slice View Formatting
PowerOLAP Cube Formula Grammar
TIMESTRING
Format Tab
Slice View Formatting
number
OLAPFactSecurityRule
Make Changes On-line and then Synchronize
Calculation Engines
Dependencies
Introduction to Formula Basic, Cube Formulas, Dependencies &
Granting Cube Security Rights
PowerOLAP Cube Formula Grammar
About PowerOLAP Services
Caching
Creating Cube Formulas
Model Cubes
Creating a Local Database from the Synchronization Server
Internal Cube Formula
Creating a Cube
Assigning Fact Data Security Privileges
Importing and Exporting
Creating Cube Formulas
Calculation Depth
Assigning Database Privileges
About Fact Data in Cubes
OLAPRootCount
OLAPUserInGroup
IDS Performance Considerations
Meta Data Import Commands
Create/Save a Dimension Subset
Excel Integration
Paste and Drill-Through Functions
OLAPFactSecurityMember
OLAPCubeDimCount
WEEKDAY
OLAPAliasToMember
current
ischildof
aggregatesum
asread
char
OLAPTable
OLAPWriteAliasToCube
OLAPFactSecurityRuleCount
number
levelcount
log
member
oledbreadwrite
now
OLAPFactSecurityRuleName
cuberead
ABS
len
asin
OLAPSubsetCount
OLAPFactSecurityRangeMembers
Formula Syntax and Terminology
pmt
OLAPFactSecurityRule
SIN
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
OLAPTable
Model Dimensions
SIGN
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
date
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
OLAPReadWrite
Member Properties
parent
SQRT
mid
SUBSTITUTE
membercount
OLAPFactSecurityStatus
OLAPChild
OLAPSubsetMemberCount
Formula Basics
PROPERTY
REPLACE
RIGHT
SCAN
OLAPAliasGroup
cubedimcount
IF
acos
alias
OLAPReadWrite
OLAPWrite
OLAPPivot
ROOTCOUNT
literal
month
OLAPDimMaxLevel
dbread
exact
childcount
code
cos
Access Privileges
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
PPMT
SECOND
lower
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
level
fv
aliastomember
OLAPUser
Dependencies Grammar
Entering Data through an Excel Worksheet
Cross-Cube Formula
Transfer Cube
REPT
RAND
OLAPCubeSecurity
iserror
AND
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
Add New Member to Display Results
oledbread
OLAPGroupCount
OLAPCube
OLAPCubeCount
find
atan
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Create and define IDS task to Pull Fact Data from a Remote Cube
PROPER
ln
OLAPCurrentUser
TAN
OLAPAlias
currentindex
day
General Tab
Additional Information
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
OR
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIME
TIMESTRING
TODAY
Excel Functions List
dbreadwrite
upper
OLAPMemberCount
parentcount
ROUND
lookup
memberindex
minute
TRIM
WEIGHT
OLAPChildCount
cubereadwrite
OLAPMemberType
OLAPRoot
missing
YEAR
int
exp
Summary of Quick Start Exercises
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
User Considerations
Changing Data Views from within Excel
Database Reference Formulas
PV
min
ismissing
OLAPSliceSecurity
Introduction to PowerOLAP's Persistent Calculations
User Considerations
mod
NOT
OLAPFactSecurityPrivileges
hour
ipmt
child
Formula Dialog Box Editor Options
ROOT
max
left
asreadwrite
OLAPRenameProperty
Dependencies
OLAPRenameMember
Enable Caching
Setting New Slice Options
OLAPRenameAlias
OLAPNavigate
OLAPFormula
Persistent Calculations - Design Mode Option
OLAPWriteMemberToCube
MDX
OLAPQuery
Save Dependencies to File
OLAPIsFormula
OLAPNavigateRW
Excel Functions List
Excel Integration
OLAPTable
OLAPReadWrite
Advanced PowerOLAP Worksheet Functions
Introduction to Formula Basic, Cube Formulas, Dependencies &
Formula Basics
Calculation Engines
Introduction to Formula Basic, Cube Formulas, Dependencies &
Creating Cube Formulas
Calculation Depth
Introduction to PowerOLAP's Persistent Calculations
Formula Dialog Box Editor Options
Internal Cube Formula
Persistent Calculations - Design Mode Option
OLAP Services
Creating Cube Formulas
Persistent Calculations - Design Mode Option
Calculation Engines
literal
Introduction to PowerOLAP's Persistent Calculations
PowerOLAP Cube Formula Grammar
RAND
Database Reference Formulas
Formula Syntax and Terminology
Internal Cube Formula
Meta Data Import Commands
Granting Cube Security Rights
Cross-Cube Formula
Creating Cube Formulas
Internal Cube Formula
Calculation Engines
Creating Cube Formulas
Creating Cube Formulas
Introduction to PowerOLAP's Persistent Calculations
Internal Cube Formula
Calculation Engines
Dependencies
Formula Basics
Cross-Cube Formula
Creating Cube Formulas
Internal Cube Formula
Assigning Fact Data Security Privileges
Creating Cube Formulas
Calculation Depth
RAND
Formula Dialog Box Editor Options
Dependencies
Member Properties
MDX
Cross-Cube Formula
Internal Cube Formula
Paste and Drill-Through Functions
Dependencies
OLAPReadWrite
OLAPFormula
OLAPIsFormula
Model Cubes
Calculation Engines
Calculation Engines
Dependencies
Dependencies
Formula Syntax and Terminology
Formula Basics
PowerOLAP Cube Formula Grammar
Member Aliases & Alias Groups
General Tab
PROPERTY
lookup
Access Privileges
Secure Database
Assigning Database Privileges
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Create a New Linked Cube
Additional Information
Fact Data Import Commands
member
level
Advanced PowerOLAP Worksheet Functions
OLAPFormula
OLAPIsFormula
cubedimcount
PowerOLAP Cube Formula Grammar
cubedim
char
len
mid
RIGHT
SCAN
code
exact
find
PROPER
left
char
code
asin
ABS
number
lower
atan
upper
missing
OLAPRootCount
len
OLAPSubsetCount
OLAPSubsetMemberCount
OLAPUserCount
mid
RIGHT
TRIM
left
lookup
SCAN
find
aggregatesum
literal
OLAPWriteAliasToCube
OLAPRead
OLAPReadWrite
OLAPWriteMemberToCube
SIN
Advanced PowerOLAP Worksheet Functions
Excel Functions List
Advanced PowerOLAP Worksheet Functions
Excel Functions List
ROUND
int
log
acos
cos
day
minute
int
min
OLAPMemberType
OLAPUserGroupCount
Creating a Local Database from the Synchronization Server
Register and Activate the PowerOLAP Client
Excel Integration
New Slice Menu & OLAPNavigate
OLAPReadWrite
Installing Additional PowerOLAP Client Components
OLAPPivot
Building & Updating Cubes that Support Incremental Updating
Register and Activate the PowerOLAP Server
About PowerOLAP Services
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
Licensing Tab
Creating a Cube
Make Changes Offline and then Synchronize [Remote Capabilities]
Quick Start Introduction
Member Types/ Hierarchy Dialog box
Member Properties
Advanced PowerOLAP Worksheet Functions
Excel Functions List
Entering Data in a Slice
Summary of Quick Start Exercises
Database Reference Formulas
OLAPRootCount
OLAPUserInGroup
Excel Integration
Paste and Drill-Through Functions
Select Page MembersUsing Edit Slice
OLAPFactSecurityMember
OLAPCubeDimCount
WEEKDAY
OLAPAliasToMember
current
ischildof
aggregatesum
asread
char
OLAPTable
OLAPWriteAliasToCube
Security Export/Import Feature
OLAPFactSecurityRuleCount
number
levelcount
log
member
oledbreadwrite
now
OLAPFactSecurityRuleName
cuberead
ABS
len
asin
OLAPSubsetCount
The Dimension Hierarchy Toolbar
OLAPFactSecurityRangeMembers
New Slice Menu & OLAPNavigate
Formula Syntax and Terminology
pmt
OLAPFactSecurityRule
SIN
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
Dependencies
OLAPTable
SIGN
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
date
Cube Formula Functions
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
Transfer/Export/Clear Cube
OLAPReadWrite
Introduction to Formula Basic, Cube Formulas, Dependencies &
parent
SQRT
mid
SUBSTITUTE
membercount
OLAPFactSecurityStatus
OLAPChild
OLAPSubsetMemberCount
Process Cube for Fact or Meta Data Update
Formula Basics
SUMMARY: The Dimension Hierarchy Toolbar
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
PowerOLAP's Add-In Menuand Toolbar
PPMT
SECOND
lower
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
level
fv
aliastomember
OLAPUser
Dependencies Grammar
Constraints
REPT
RAND
OLAPCubeSecurity
iserror
AND
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
The Edit Slice Dialog Box
Creating an Excel Worksheet
Model Cubes
oledbread
OLAPGroupCount
OLAPCube
OLAPCubeCount
find
atan
Creating an Excel Worksheet
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Update Linked Cube
The OLAPPivot Function
PROPER
ln
OLAPCurrentUser
TAN
OLAPAlias
currentindex
day
General Tab
Entering Data in a Slice
Internal Cube Formula
OR
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIME
TIMESTRING
TODAY
dbreadwrite
upper
OLAPMemberCount
Importing and Exporting
parentcount
ROUND
lookup
memberindex
minute
TRIM
WEIGHT
OLAPChildCount
cubereadwrite
OLAPMemberType
OLAPRoot
Applying Database Security
missing
YEAR
int
exp
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
Save Database/Save and Backup Database/Update from Synchronize
Calculation Depth
PV
min
ismissing
OLAPSliceSecurity
Quick Start Introduction
User Considerations
Short-Cut Menus for the Grid
mod
NOT
OLAPFactSecurityPrivileges
hour
ipmt
child
ROOT
max
left
asreadwrite
OLAPRenameProperty
Dependencies
OLAPRenameMember
OLAPRenameAlias
OLAPNavigate
OLAPFormula
Active Directory Authentication
OLAPWriteMemberToCube
MDX
OLAPQuery
OLAPIsFormula
OLAPNavigateRW
min
max
OLAPMemberToAlias
OLAPMemberNext
OLAPMemberIndex
OLAPMemberProperty
OLAPMemberLevel
OLAPMemberType
Internal Cube Formula
The Dimension Hierarchy Toolbar
Dependencies
Dependencies
Create the User Domain Account in the Active Directory
Define Links—Star Schema
Create/Save a Dimension Subset
Entering Data from within Excel
Create a New Linked Cube
Defining Users and Groups
Calculation Engines
Creating a Slice View
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Working with OLAP Exchange on the MDB Server
OLAPPivot
Zero Suppression
Creating the Measures Dimension
Creating a Local Database from the Synchronization Server
Define Hierarchy
Creating the 3rd and Further Dimensions
Define Drill Through
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Dynamic Multidimensional Graphs
Create Dimension Hierarchy
Assigning Fact Data Security Privileges
Importing and Exporting
Creating a PowerOLAP Database
Define Rollups / Drill-Through with Rollups
Incremental Update vs. Update from Source
Fact Data Security Ranges
Assigning Database Privileges
Creating the 2nd Dimension
The Edit Slice Dialog Box
Creating the 3rd and Further Dimensions
Define Hierarchy
Creating the 2nd Dimension
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
Calculation Engines
CUBEREAD
Create and define IDS task to Push Fact Data from a Local Cube
Caching
Transfer Cube
Create and define IDS task to Pull Fact Data from a Remote Cube
CUBEREADWRITE
New Slice Menu & OLAPNavigate
OLAPNavigate
OLAPQuery
CUBEREAD
CUBEREADWRITE
Executing Cube Tasks in Excel
pmt
PowerOLAP Cube Formula Grammar
PPMT
fv
PV
ipmt