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