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