ABS
Cube Formula Functions
SQRT
PowerOLAP Cube Formula Grammar
Assigning Meta Data Security Privileges
Granting Slices Meta Security Rights
Granting Cube Security Rights
Access Privileges
Granting Dimensions Meta Security Rights
Assigning Fact Data Security Privileges
Caching
OLAPFactSecurityPrivileges
Assigning Fact Data Security Privileges
Assigning Meta Data Security Privileges
Access Privileges
Fact Data Security Ranges
OLAPFactSecurityPrivileges
Granting Cube Security Rights
Aggregate Weights
Aggregate Weights
Transfer Cube
Internal Cube Formula
Creating Cube Formulas
current
Dependencies
Zero Suppression
Cross-Cube Formula
Granting Dimensions Meta Security Rights
Creating Cube Formulas
Add New Member to Display Results
Entering Data in a Slice
Importing and Exporting
Database Reference Formulas
Cube Formula Functions
ACOS
PowerOLAP Cube Formula Grammar
Create the User Domain Account in the Active Directory
Active Directory Authentication
General Tab
Active Directory Authentication
General Tab
Create the User Domain Account in the Active Directory
Active Directory Authentication
OLAPCubeDimCount
OLAPFactSecurityMember
OLAPAliasToMember
OLAPUserInGroup
OLAPRootCount
OLAPWriteAliasToCube
OLAPFactSecurityRuleCount
OLAPFactSecurityRuleName
OLAPTable
OLAPDimensionSecurity
OLAPCubeDimension
OLAPFactSecurityRangeMembers
OLAPFactSecurityRule
OLAPSubsetCount
OLAPAliasGroupCount
OLAPDimension
OLAPUserGroup
OLAPIsSecureDatabase
OLAPMember
OLAPMemberNext
OLAPMemberToAlias
OLAPParentCount
OLAPChild
OLAPFactSecurityStatus
OLAPMemberIndex
OLAPSave
OLAPPivot
OLAPRead
OLAPAliasGroup
OLAPSubsetMemberCount
OLAPDimMaxLevel
OLAPWrite
OLAPReadWrite
OLAPGroup
OLAPCanAddDimensionAndCubes
OLAPDimCount
OLAPMemberLevel
OLAPParent
OLAPMemberProperty
OLAPCubeSecurity
OLAPUser
OLAPCube
OLAPCubeCount
OLAPGroupCount
OLAPMemberFirst
OLAPDatabase/OLAPOpen
OLAPCurrentUser
OLAPAlias
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
OLAPChildCount
OLAPMemberCount
OLAPRoot
OLAPMemberType
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
OLAPFactSecurityPrivileges
OLAPSliceSecurity
Changes by Student in Read Write Group
Meta Data Import Commands
Make Changes On-line and then Synchronize
Granting Dimensions Meta Security Rights
The Dimension Hierarchy Toolbar
SUMMARY: The Dimension Hierarchy Toolbar
Defining Users and Groups
Creating a Dimension Hierarchy
Process Cube (Rebuild Cube)
The Edit Slice Dialog Box
The Dimension Hierarchy Toolbar
SUMMARY: The Dimension Hierarchy Toolbar
Creating a Dimension Hierarchy
The Edit Slice Dialog Box
Assigning Meta Data Security Privileges
Assigning Database Privileges
Granting Rights to Add Dimensions and Cubes
Creating Dimensions
Model Dimensions
OLAPCanAddDimensionAndCubes
Excel Paste Functions
Mark Member as Persistent
Member Aliases & Alias Groups
Define Aliases—Create an Alias Group
Change Aliases
Change Properties
Define Properties—Create a Properties Group
Defining Users and Groups
Define Aliases
Member Aliases & Alias Groups
Change Aliases
Define Properties
Change Properties
Add Members to 2nd, 3rd, etc Dimension
Define Members
Member Types/ Hierarchy Dialog box
Access Privileges
Creating the Measures Dimension
Creating Cube Formulas
Add New Member to Display Results
Adding Members to Dimensions
Create Dimension Hierarchy
Importing and Exporting
Summary of Quick Start Exercises
Mark Member as Persistent
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Applying Database Security
Granting Rights to Add Dimensions and Cubes
Add New Member to Display Results
The Dimension Hierarchy Toolbar
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
SUMMARY: The Dimension Hierarchy Toolbar
Granting Dimensions Meta Security Rights
Access Privileges
Assigning Meta Data Security Privileges
The Dimension Hierarchy Toolbar
SUMMARY: The Dimension Hierarchy Toolbar
Creating a Dimension Hierarchy
Define Links
The Dimension Hierarchy Toolbar
Creating a Dimension Hierarchy
SUMMARY: The Dimension Hierarchy Toolbar
Setting New Slice Options
Adding a Server from within PowerOLAP
PowerOLAP Client Installation for Non-Admin Users
Setting New Slice Options
Adding a Server from within PowerOLAP
PowerOLAP Client Installation for Non-Admin Users
Defining Users and Groups
Add Users and Groups
Model Cubes
Enable Caching
Administrative Cube
Security Export/Import Feature
PowerOLAP Client Installation
Register and Activate the PowerOLAP Server
Register and Activate the PowerOLAP Server
Configure ODBC Data Source
Model Cubes
Cube Properties
Administrative Cube
Security Export/Import Feature
Defining Users and Groups
Enabling a Database for Security
Assigning Meta Data Security Privileges
Creating a Cube
Access Privileges
OLAPCanAddDimensionAndCubes
Granting Dimensions Meta Security Rights
Model Cubes
OLAPCurrentUser
Register and Activate the PowerOLAP Version 8 Server
Secure Database
Assigning Fact Data Security Privileges
Administrator Changes
Creating a PowerOLAP Database
Applying Database Security
OLAPSliceSecurity
Quick Start Introduction
Triggers and their use for Incremental Updating
Create the User Domain Account in the Active Directory
Working with OLAP Exchange as Client in a Server Scenario
Allow Duplicates
Working with OLAP Exchange on the MDB Server
PowerOLAP Service Control Program
Seeing Results in PowerOLAP (.olp file)
Cube Properties
Granting Cube Security Rights
Building & Updating Cubes that Support Incremental Updating
Administrative Cube
Creating the Measures Dimension
Define LinksStar Schema
Define Hierarchy Creating Dimension Hierarchies
Create and define IDS task to Pull Fact Data from a Remote Cube
Active Directory Authentication
Define LinksSnowflake Schema
Add Users and Groups
PowerOLAP Server Installation for Non-Admin Users
Assigning Database Privileges
Creating a Cube via OLAP Exchange
PowerOLAP Client Installation for Non-Admin Users
Defining Users and Groups
Granting Dimensions Meta Security Rights
Create the User Domain Account in the Active Directory
Model Cubes
Add Users and Groups
Secure Database
Assigning Database Privileges
Enabling a Database for Security
Administrator Changes
Administrative Cube
PowerOLAP Server Installation for Non-Admin Users
PowerOLAP Client Installation for Non-Admin Users
Administrator Topics
Creating a Cube
Allow Duplicates
Seeing Results in PowerOLAP (.olp file)
Cube Properties
Define Links—Snowflake Schema
Define Hierarchy— Creating Dimension Hierarchies
Define Links—Star Schema
Working with OLAP Exchange as Client in a Server Scenario
Working with OLAP Exchange on the MDB Server
Building & Updating Cubes that Support Incremental Updating
Creating a Cube via OLAP Exchange
Formula Syntax and Terminology
Member Properties
Formula Basics
Constraints Grammar for Advanced Users
Zero Suppression
Dependencies Grammar
Advanced PowerOLAP Worksheet Functions
Importing and Exporting
Member Types/ Hierarchy Dialog box
Define Order
Importing and Exporting
aggregatesum
Entering Data from within Excel
Creating a Dimension Hierarchy
Introduction to Formula Basic, Cube Formulas, Dependencies &
Aggregate Weights
Formula Basics
childcount
Aggregate Weights
Entering Data through an Excel Worksheet
The Edit Slice Dialog Box
Add New Member to Display Results
Adding Members to Dimensions
Grid features Drill-Down on Members and Data within the Slice
Entering Data in a Slice
Create Dimension Hierarchy
Entering Data in a Slice
OLAPChildCount
Creating Cube Formulas
Summary of Quick Start Exercises
Importing Data from a File
Hierarchy
child
The OLAPPivot Function
Aggregate Weights
Aggregate Weights
Summary of Quick Start Exercises
Entering Data from within Excel
The Dimension Hierarchy Toolbar
Creating Cube Formulas
IDS Performance Considerations
Paste and Drill-Through Functions
Entering Data from within Excel
Calculation Engines
The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
Dependencies
Dependencies Grammar Definition
Introduction to Formula Basic, Cube Formulas, Dependencies &
Aggregate Weights
Formula Basics
OLAPPivot
PowerOLAP Cube Formula Grammar
Aggregate Weights
Caching
Creating Cube Formulas
Add New Member to Display Results
Accessing the Database by a User with Read-Only Rights
Adding Members to Dimensions
The OLAPPivot Function
Internal Cube Formula
Entering Data in a Slice
Create Dimension Hierarchy
Entering Data in a Slice
Importing and Exporting
OLAPMemberType
Creating Cube Formulas
Fact Data Security Ranges
Summary of Quick Start Exercises
User Considerations
Importing Data from a File
Hierarchy
Introduction to PowerOLAP's Persistent Calculations
aggregatesum
OLAPChild
Allow Duplicates
Setting New Slice Options
childcount
Access Privileges
Define Order
Entering Data through an Excel Worksheet
Slice View Formatting
Transfer Cube
The Edit Slice Dialog Box
Define Hierarchy
Create and define IDS task to Pull Fact Data from a Remote Cube
Define Hierarchy
Grid features Drill-Down on Members and Data within the Slice
Dynamic Multidimensional Graphs
OLAPIsChildOf
OLAPIsParentOf
Change Properties
OLAPChildCount
Add/Delete Members in Measures Dimension
Define Rollups / Drill-Through with Rollups
child
Dependencies
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Fact Data Security Ranges
AGGREGATESUM
Cube Formula Functions
PowerOLAP Cube Formula Grammar
User Considerations
User Considerations
aggregatesum
Calculation Engines
Creating a Dimension Hierarchy
Dependencies
Aggregate Weights
PowerOLAP Cube Formula Grammar
Caching
Add New Member to Display Results
Define Hierarchy
General Tab
Additional Information
Entering Data in a Slice
Create Dimension Hierarchy
Change Properties
Add/Delete Members in Measures Dimension
Define Rollups / Drill-Through with Rollups
Dependencies
Enable Caching
aggregatesum
PowerOLAP Cube Formula Grammar
Meta Data Import Commands
Member Aliases & Alias Groups
OLAPAliasToMember
The Dimension Hierarchy Toolbar
OLAPMemberToAlias
Cube Formula Functions
Property Groups
Member Properties
Process Cube for Fact or Meta Data Update
SUMMARY: The Dimension Hierarchy Toolbar
ALIAS
PowerOLAP Cube Formula Grammar
ALIASTOMEMBER
Define Links—Snowflake Schema
Create a Time Dimension
Change Aliases
Change Hierarchy
Change Properties
Excel Paste Functions
Importing and Exporting
Define Aliases
Define Properties—Create a Properties Group
Database Reference Formulas
OLAP AliasGroupCount
Triggers and their use for Incremental Updating
Define Aliases
OLAPWriteAliasToCube
OLAPParentCount
Process Cube (Rebuild Cube)
OLAPChild
OLAPAliasGroup
Cube Properties
Access Privileges
OLAPParent
OLAPCanAddDimensionAndCubes
Creating the 3rd and Further Dimensions
OLAPAlias
Excel Functions List
memberindex
WEIGHT
Alias Groups
About Meta Data
OLAPRenameAlias
The Edit Slice Dialog Box
OLAPWriteMemberToCube
MDX
Member Aliases & Alias Groups
OLAPMemberToAlias
OLAPMemberToAlias
Excel Paste Functions
Member Aliases & Alias Groups
Define Aliases
Member Aliases & Alias Groups
Define Aliases
Change Aliases
OLAPRenameAlias
Member Aliases & Alias Groups
Alias Groups
Define Aliases
Change Aliases
Member Properties
Change Aliases
Alias Groups
ALIASTOMEMBER
Define Aliases
Member Aliases & Alias Groups
OLAPWriteAliasToCube
OLAPMemberToAlias
alias
PowerOLAP Cube Formula Grammar
OLAPAlias
Excel Paste Functions
memberindex
Define Aliases
Database Reference Formulas
OLAPRenameAlias
Member Aliases & Alias Groups
Property Groups
Process Cube for Fact or Meta Data Update
Change Aliases
Define Properties
Define Links
Define Aliases
Member Properties
alias
Access Privileges
aliastomember
Triggers and their use for Incremental Updating
Cube Formula Functions
PowerOLAP Cube Formula Grammar
ALIASTOMEMBER
Create Additional Tables
Allow Duplicates
Define Member Options
Creating the Measures Dimension
Creating a Cube from the MDB Server Control Program
Define Hierarchy
General Tab
Importing and Exporting
Defining an ODBC Data Source between PowerOLAP and a SQL Server
literal
Creating a PowerOLAP Database
Use SQL Views
Creating a Cube
Building & Updating Cubes that Support Incremental Updating
Databases Supported for Use with OLAP Exchange
ASREAD
OLEDBREADWRITE
About PowerOLAP Services
OLEDBREAD
ASREADWRITE
Create a New Linked Cube
Client Mode - PowerOLAP as Client to Analysis Services Cubes
dbread
dbreadwrite
Server Mode - PowerOLAP as Server to Analysis Services Cubes
OLAP Services
MDX
Create a New Linked Cube
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Server Mode - PowerOLAP as Server to Analysis Services Cubes
asread
dbread
oledbread
dbreadwrite
asreadwrite
MDX
asread
oledbreadwrite
oledbread
asreadwrite
Cube Formula Functions
Constraints Grammar for Advanced Users
Zero Suppression
PowerOLAP Cube Formula Grammar
AND
OR
Constraints Grammar for Advanced Users
SCAN
find
Executing PowerOLAP Scheduler Job in Excel
Model Cubes
Applying Database Security
Excel Functions List
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
cuberead
ABS
len
asin
OLAPSubsetCount
OLAPFactSecurityRangeMembers
pmt
OLAPFactSecurityRule
SIN
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
Dependencies
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
date
Cube Formula Functions
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
parent
SQRT
mid
SUBSTITUTE
membercount
OLAPFactSecurityStatus
OLAPChild
OLAPSubsetMemberCount
PROPERTY
REPLACE
RIGHT
SCAN
OLAPAliasGroup
cubedimcount
acos
alias
OLAPReadWrite
OLAPWrite
ROOTCOUNT
literal
month
OLAPDimMaxLevel
dbread
exact
code
cos
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
PowerOLAP Cube Formula Grammar
PPMT
SECOND
lower
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
level
fv
aliastomember
OLAPUser
REPT
RAND
OLAPCubeSecurity
iserror
AND
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
oledbread
OLAPGroupCount
OLAPCube
OLAPCubeCount
find
atan
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
PROPER
ln
OLAPCurrentUser
TAN
OLAPAlias
currentindex
day
OR
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIME
TIMESTRING
TODAY
dbreadwrite
upper
OLAPMemberCount
Excel Paste Functions
lookup
memberindex
minute
TRIM
WEIGHT
OLAPChildCount
cubereadwrite
OLAPMemberType
OLAPRoot
Fact Data Import Commands
YEAR
int
exp
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
Changing Data Views from within Excel
Database Reference Formulas
PV
min
ismissing
OLAPSliceSecurity
mod
NOT
OLAPFactSecurityPrivileges
hour
ipmt
child
ROOT
max
left
asreadwrite
OLAPRenameProperty
Dependencies
OLAPRenameMember
Other Task Types
OLAPRenameAlias
OLAPFormula
OLAPWriteMemberToCube
OLAPIsFormula
OLAPTable
Select Row or Column Members Using Edit Slice
OLAPReadWrite
OLAPPivot
Entering Data in a Slice
Changing Data Views from within Excel
Advanced PowerOLAP Worksheet Functions
OR
OLAPTable
OLAPReadWrite
OLAPPivot
Select Row or Column Members Using Edit Slice
Changing Data Views from within Excel
ALIASTOMEMBER
Working with ODBC (Open Database Connectivity)
Client Mode - PowerOLAP as Client to Analysis Services Cubes
MDX
Meta Data Import Commands
CHAR
CODE
About Fact Data in Cubes
ISCHILDOF
AGGREGATESUM
ALIASTOMEMBER
WEIGHT
childcount
ASIN
SIN
Cube Formula Functions
PowerOLAP Cube Formula Grammar
ASREAD
Cube Formula Functions
ASREADWRITE
asread
asreadwrite
Cube Formula Functions
ASREADWRITE
Applying Database Security
Assigning Database Privileges
The Dimension Hierarchy Toolbar
SUMMARY: The Dimension Hierarchy Toolbar
Applying Database Security
Assigning Meta Data Security Privileges
Assigning Meta Data Security Privileges
Assigning Fact Data Security Privileges
Creating Cube Formulas
MISSING
Summary of Quick Start Exercises
Assigning Database Privileges
Cube Formula Functions
PowerOLAP Cube Formula Grammar
ATAN