OLAPUserInGroup
Paste and Drill-Through Functions
Select Page MembersUsing Edit Slice
OLAPAliasToMember
Create a New Synchronization Server
Member Types/ Hierarchy Dialog box
Creating a Task (Internet Data Services)
OLAPSave
Creating a Cube
REPLACE
SCAN
EXACT
PowerOLAP Cube Formula Grammar
OLAPCanAddDimensionAndCubes
Create and define IDS task to Push Fact Data from a Local Cube
Creating the Measures Dimension
ISERROR
FIND
The OLAPPivot Function
OLAPAlias
Assigning Fact Data Security Privileges
Importing and Exporting
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Fact Data Import Commands
Database Reference Formulas
Saving Your Work (.olt file)
Rename a Subset
OLAPRootCount
Administrator Topics
Define Aliases
Meta Data Import Commands
Create/Save a Dimension Subset
Member Aliases & Alias Groups
OLAPFactSecurityMember
OLAPCubeDimCount
current
ischildof
aggregatesum
asread
char
OLAPTable
OLAPWriteAliasToCube
Create a New Linked Cube
Use Partial Field Member Name
Create the SQL Server Login
OLAPFactSecurityRuleCount
levelcount
member
oledbreadwrite
OLAPFactSecurityRuleName
cuberead
len
OLAPSubsetCount
Creating a Slice View
The Dimension Hierarchy Toolbar
OLAPFactSecurityRangeMembers
Save Slice
OLAPFactSecurityRule
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
Model Dimensions
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
OLAPRead
OLAPPivot
OLAPMemberIndex
Error File Reporting
Assigning Meta Data Security Privileges
Member Properties
parent
mid
SUBSTITUTE
membercount
OLAPFactSecurityStatus
OLAPChild
OLAPSubsetMemberCount
Allow Duplicates
Process Cube for Fact or Meta Data Update
Constraints Grammar for Advanced Users
SUMMARY: The Dimension Hierarchy Toolbar
PROPERTY
RIGHT
OLAPAliasGroup
cubedimcount
alias
Saving Changes to a Database
Granting Cube Security Rights
OLAPReadWrite
OLAPWrite
Seeing Results in PowerOLAP (.olp file)
ROOTCOUNT
literal
OLAPDimMaxLevel
dbread
childcount
code
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
lower
OLAPDimCount
OLAPGroup
level
aliastomember
Define Links
OLAPUser
Dependencies Grammar
Constraints
Transfer Cube
REPT
OLAPCubeSecurity
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
Define Properties
Creating Cube Formulas
Model Cubes
oledbread
OLAPGroupCount
OLAPCube
OLAPCubeCount
Transaction Log
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Adding Members to Dimensions
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating a Local Database from the Synchronization Server
Creating Notification
PROPER
OLAPCurrentUser
currentindex
Define Drill Through
Additional Information
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Create Dimension Hierarchy
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
dbreadwrite
upper
Creating a New JOB
OLAPMemberCount
Secure Database
Excel Paste Functions
Slice Commands
parentcount
lookup
memberindex
TRIM
WEIGHT
OLAPChildCount
cubereadwrite
Define Aliases
Adding a Server from within PowerOLAP
OLAPMemberType
OLAPRoot
Add/Delete Members in Measures Dimension
Creating a PowerOLAP Database
Define Rollups / Drill-Through with Rollups
Fact Data Security Ranges
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
Alias Groups
Changing Data Views from within Excel
Defining an ODBC Data Source between PowerOLAP and a SQL Server
OLAPSliceSecurity
OLAPFactSecurityPrivileges
child
How to Create a Local Cube from a Remote Cube using IDS
Triggers and their use for Incremental Updating
ROOT
left
asreadwrite
Installing PowerOLAP MDB Server
OLAPRenameProperty
OLAPRenameMember
PowerOLAP Service Control Program
PowerOLAP Client Installation
Add Members to 2nd, 3rd, etc Dimension
OLAPRenameAlias
OLAPNavigate
OLAPFormula
The Edit Slice Dialog Box
Define Hierarchy Creating Dimension Hierarchies
Active Directory Authentication
PowerOLAP MDB Server Installation
General Tab
OLAPWriteMemberToCube
MDX
OLAPQuery
OLAPIsFormula
OLAPNavigateRW
PowerOLAP Client Installation for Non-Admin Users
OLAPAliasToMember
OLAPAlias
Creating a Cube
The OLAPPivot Function
PowerOLAP Cube Formula Grammar
Creating the Measures Dimension
Fact Data Import Commands
Select Page MembersUsing Edit Slice
Importing and Exporting
OLAPUserInGroup
OLAPCanAddDimensionAndCubes
OLAPSubset
OLAPSubsetMember
New Slice Menu & OLAPNavigate
Changing Data Views from within Excel
Using Slices to Navigate Cubes
OLAPNavigate
Set 3GB Startup Switch in Windows
Location of the Client Installer
Entering Data from within Excel
Aggregate Weights
Entering Data in a Slice
Creating Cube Formulas
Importing Data from a File
Creating a Dimension Hierarchy
Introduction to the PowerOLAP MDB Server
Create a New Synchronization Server
Create the User Domain Account in the Active Directory
Configure ODBC Data Source
Secure Database
Importing and Exporting
Minimum Hardware Recommendations
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Concepts and Benefits
PowerOLAP Service Control Program
General Tab
Introduction to the PowerOLAP MDB Server
Minimum Hardware Recommendations
Create the SQL Server Login
Creating a Slice
Create a New Linked Cube
Member Types/ Hierarchy Dialog box
REPLACE
Creating a Task
Transfer Cube
Adding Members to Dimensions
Creating Notification
Define Rollups / Drill-Through with Rollups
Make Changes Offline and then Synchronize [Remote Capabilities]
Configure ODBC Data Source
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Exercises
Creating a Cube from the MDB Server Control Program
Creating a Local Database from the Synchronization Server
Creating a PowerOLAP Database
asread
Create a New Linked Cube
oledbreadwrite
Model Dimensions
dbread
Model Cubes
oledbread
dbreadwrite
Secure Database
Importing and Exporting
Defining an ODBC Data Source between PowerOLAP and a SQL Server
asreadwrite
Create a New Linked Cube
Creating a Local Database from the Synchronization Server
Secure Database
Creating a PowerOLAP Database
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Creating Dimensions
Creating the 3rd and Further Dimensions
Define Links—Star Schema
Creating the 2nd Dimension
Model Dimensions
Modify Relational Dimension
OLAPPivot
Assigning Database Privileges
Changing Data Views from within Excel
Granting Rights to Add Dimensions and Cubes
Process Cube (Rebuild Cube)
Creating the Measures Dimension
Introduction to PowerOLAP SCHEDULER
Dynamic Multidimensional Graphs
Quick Start Introduction
MDX
Create a New Linked Cube
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Additional Information
Create a New Linked Cube
Additional Information
Process Cube for Fact or Meta Data Update
The Dimension Hierarchy Toolbar
New Slice Menu & OLAPNavigate
Member Types/ Hierarchy Dialog box
SUMMARY: The Dimension Hierarchy Toolbar
Building & Updating Cubes that Support Incremental Updating
Aggregate Weights
Creating the Measures Dimension
Transfer Cube
Add New Member to Display Results
Creating Cube Formulas
Changing Data Views from within Excel
Mark Member as Persistent
OLAPRenameMember
OLAPRenameProperty
OLAPRenameMember
OLAPRenameAlias
Creating a Slice View
New Slice Menu & OLAPNavigate
Process Cube for Fact or Meta Data Update
Entering Data in a Slice
Slice Commands
Creating a Slice
Save Slice
Setting New Slice Options
Cube Properties
Using Slices to Navigate Cubes
Create and define IDS task to Push Fact Data from a Local Cube
Define Order
Transfer Cube
Model Cubes
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
Dynamic Multidimensional Graphs
Make Changes Offline and then Synchronize [Remote Capabilities]
Creating a Slice
Creating a Slice View
New Slice Menu & OLAPNavigate
Cube Properties
Transfer Cube
Entering Data in a Slice
Make Changes Offline and then Synchronize [Remote Capabilities]
Setting New Slice Options
New Slice Menu & OLAPNavigate
Create a New Synchronization Server
Synchronization Server database in SQL Server
Create the User Domain Account in the Active Directory
Defining Users and Groups
Installation of the PowerOLAP Version 8 Client
Building & Updating Cubes that Support Incremental Updating
Concepts and Benefits / Requirements
Extended Drill-Through
SUBSTITUTE
REPLACE
IDS Performance Considerations
Define Members
Installing PowerOLAP MDB Server
Create a New Linked Cube
Use Partial Field Member Name
Define Properties
Remove Existing Version
Define Aliases—Create an Alias Group
PowerOLAP Version 8 MDB Server Installation
Installing Additional PowerOLAP Client Components
Add Members to 2nd, 3rd, etc Dimension
Installation of the PowerOLAP Version 8 Client
Building & Updating Cubes that Support Incremental Updating
Create and define IDS task to Push Fact Data from a Local Cube
Set the Frequency of the Scheduled Job/Task
Creating the Measures Dimension
Create a Time Dimension
Define Order
Define Members
Change Aliases
Define Hierarchy
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating Notification
Configure ODBC Data Source
Creating the 3rd and Further Dimensions
Define Drill Through
Change Hierarchy
Creating a New JOB
Define Hierarchy— Creating Dimension Hierarchies
Change Properties
Define Aliases
Define Properties—Create a Properties Group
Add/Delete Members in Measures Dimension
Define Rollups / Drill-Through with Rollups
Define Links—Star Schema
Database Reference Formulas
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Conditional Retrieval
Administrator Topics
Additional Considerations for Data Preparation
Meta Data Import Commands
Create/Save a Dimension Subset
ischildof
Create the SQL Server Login
Defining Users and Groups
Creating a Slice View
New Slice Menu & OLAPNavigate
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
OLAPMemberToAlias
OLAPMemberNext
Make Changes On-line and then Synchronize
OLAPTable
OLAPMemberIndex
Property Groups
Assigning Meta Data Security Privileges
OLAPReadWrite
OLAPMemberProperty
OLAPMemberLevel
PowerOLAP's Add-In Menuand Toolbar
Register and Activate the PowerOLAP Server
Caching
Window, Tiled or Cascading Slices
Cross-Cube Formula
Transfer Cube
Continue to Next Task on Error
Create the User Domain Account in the Active Directory
Creating Cube Formulas
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
Adding Members to Dimensions
currentindex
Entering Data in a Slice
Dynamic Multidimensional Graphs
Create Dimension Hierarchy
OLAPFactSecurityMemberCount
OLAPIsChildOf
Concepts and Benefits / Requirements
Entering Data in a Slice
Assigning Fact Data Security Privileges
Secure Database
Excel Paste Functions
Slice Commands
Importing and Exporting
Creating Cube Formulas
Restoring a Database
OLAPMemberType
Make Changes Offline and then Synchronize [Remote Capabilities]
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Extended Drill-Through
Importing Data from a File
Ramifications of Modify Relational Dimension
Working with Cubes
OLAPFactSecurityPrivileges
Creating a Cube via OLAP Exchange
Mark Member as Persistent
About Fact Data in Cubes
About Meta Data
Installation of PowerOLAPCOM
Zero Suppression
Creating a Task
OLAPFormula
Modify or Delete Existing Jobs
Save Dependencies to File
PowerOLAP Client Installation for Non-Admin Users
Partial Server Use for Database Creation from a Synchronization Server
Creating the Measures Dimension
Transfer Cube
Define Drill Through
Importing and Exporting
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Fact Data Security Ranges
The Edit Slice Dialog Box
Creating a Local Database from the Synchronization Server
Slice Commands
PowerOLAP Server Installation for Non-Admin Users
PowerOLAP Client Installation for Non-Admin Users
Creating a Local Database from the Synchronization Server
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Select Page MembersUsing Edit Slice
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
Dependencies
parent
Caching
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
User Considerations
Partial Server Use for Database Creation from a Synchronization Server
ROOT
PowerOLAP Cube Formula Grammar
General Tab
MDX
Calculation Depth
NOT
Working with OLAP Exchange as Client in a Server Scenario
Defining Users and Groups
Creating a Slice View
Formula Syntax and Terminology
Process Cube for Fact or Meta Data Update
Modify Relational Dimension
Cube Properties
Zero Suppression
Create a Time Dimension
Creating the Measures Dimension
Create the User Domain Account in the Active Directory
Add New Member to Display Results
Configure ODBC Data Source
Define Hierarchy Creating Dimension Hierarchies
Saving / Launching PowerOLAP Databases from within Excel
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Create Dimension Hierarchy
Internal Cube Formula
Define Rollups / Drill-Through with Rollups
Define Member Options
About Meta Data
Creating Notification
Set the Frequency of the Scheduled Job/Task
Modify or Delete Existing Jobs
NOW
Cube Formula Functions
PowerOLAP Cube Formula Grammar
SECOND
Cross-Cube Formula
Seeing Results in PowerOLAP (.olp file)
Define Member Options
pmt
PPMT
fv
PV
ipmt
Active Directory Authentication
Defining an ODBC Data Source between PowerOLAP and a SQL Server
char
SQRT
mid
RIGHT
SCAN
IF
REPT
find
left
SUBSTITUTE
mid
RIGHT
REPLACE
left
RIGHT
left
IF
AND
OR
NOT
IF
AND
OR
NOT
AND
OR
number
log
SQRT
ROOTCOUNT
Slice View Formatting
ln
Entering Data in a Slice
exp
mod
Format Tab
number
SUMMARY: The Dimension Hierarchy Toolbar
Slice View Formatting
Meta Data Import Commands
lookup