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