OLAPUserInGroup
OLAPDimensionSecurity
OLAPFactSecurityRule
OLAPCubeSecurity
Member Aliases & Alias Groups
OLAPRenameAlias
literal
PowerOLAP Scheduler
Creating a New JOB
Set the Frequency of the Scheduled Job/Task
Executing Cube Tasks in Excel
Execute Cube Task and PowerOLAP Scheduler Job from Excel
Execute a Scheduler Job
Modify or Delete Existing Jobs
Executing PowerOLAP Scheduler Job in Excel
Process Cube for Fact or Meta Data Update
Creating the Measures Dimension
OLAPRead
OLAPNavigate
OLAPReadWrite
Excel Paste Functions
OLAPQuery
OLAPNavigateRW
OLAPRead
OLAPReadWrite
Slice View Formatting
Paste and Drill-Through Functions
New Slice Menu & OLAPNavigate
Setting New Slice Options
Create Dimension Hierarchy
Fact Data Import Commands
Changing Data Views from within Excel
REPT
left
REPT
left
Process Cube (Rebuild Cube)
Process Cube for Fact or Meta Data Update
Excel Integration
Creating a Slice
Create a New Synchronization Server
Saving / Launching PowerOLAP Databases from within Excel
Register and Activate the PowerOLAP Client
OLAPReadWrite
Closing a Database
Creating an Excel Worksheet
Creating a Local Database from the Synchronization Server
General Tab
Advanced PowerOLAP Worksheet Functions
Triggers and their use for Incremental Updating
Executing Cube Tasks in Excel
Synchronization Server database in SQL Server
IDS - Internet Explorer Caching Setting
PowerOLAP Server Installation for Non-Admin Users
Executing PowerOLAP Scheduler Job in Excel
PowerOLAP Client Installation for Non-Admin Users
Accessing the Database by a User with Read-Only Rights
How to Grant Database Privileges
Accessing a Secured Database
Granting Rights to Add Dimensions and Cubes
Create a New Linked Cube
OLAPReadWrite
level
Define Hierarchy
Creating a Local Database from the Synchronization Server
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Process Cube for Fact or Meta Data Update
Setting New Slice Options
Transfer Cube
Define Hierarchy
Define Hierarchy
Entering Data in a Slice
Importing and Exporting
TRIM
Creating Cube Formulas
Creating a PowerOLAP Database
Importing Data from a File
OLAPNavigate
OLAPQuery
Requirements and Recommendations
OLAPNavigateRW
Cube Formula Functions
MID
PowerOLAP Cube Formula Grammar
LEFT
PowerOLAP Cube Formula Grammar
Member Aliases & Alias Groups
Dependencies
Granting Cube Security Rights
Dependencies Grammar
Creating Cube Formulas
Creating Cube Formulas
Calculation Depth
Introduction to PowerOLAP's Persistent Calculations
Dependencies
MDX
PowerOLAP Cube Formula Grammar
Introduction to PowerOLAP's Persistent Calculations
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Fact Data Security Ranges
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Fact Data Security Ranges
len
PowerOLAP Cube Formula Grammar
PowerOLAP Cube Formula Grammar
level
OLAPMemberLevel
Excel Paste Functions
LEVELCOUNT
Cube Formula Functions
PowerOLAP Cube Formula Grammar
New Slice Menu & OLAPNavigate
Assigning Meta Data Security Privileges
OLAPDimMaxLevel
OLAPPivot
The Edit Slice Dialog Box
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
The OLAPPivot Function
OLAPRootCount
Additional Considerations for Data Preparation
Meta Data Import Commands
OLAPFactSecurityMember
ischildof
OLAPTable
OLAPWriteAliasToCube
Create a New Linked Cube
Calculation Engines
levelcount
oledbreadwrite
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
OLAPParentCount
Dependencies
OLAPRead
OLAPPivot
Create Additional Tables
parent
OLAPChild
Granting Cube Security Rights
OLAPReadWrite
OLAPWrite
ROOTCOUNT
childcount
Access Privileges
OLAPParent
OLAPMemberLevel
PowerOLAP Cube Formula Grammar
level
Caching
Entering Data through an Excel Worksheet
OLAPCube
Define Hierarchy
Grid features Drill-Down on Members and Data within the Slice
Change Hierarchy
Entering Data in a Slice
Dynamic Multidimensional Graphs
Create Dimension Hierarchy
OLAPIsChildOf
OLAPIsParentOf
dbreadwrite
Change Properties
Excel Paste Functions
Importing and Exporting
parentcount
WEIGHT
OLAPChildCount
OLAPMemberType
OLAPRoot
Applying Database Security
Fact Data Security Ranges
OLAPWeight
Calculation Depth
OLAPSliceSecurity
Quick Start Introduction
Introduction to PowerOLAP's Persistent Calculations
child
ROOT
asreadwrite
Dependencies
OLAPWriteMemberToCube
IDS – HTTP Interface and REST
Make Changes Offline and then Synchronize [Remote Capabilities]
Formula Syntax and Terminology
PowerOLAP Cube Formula Grammar
Cross-Cube Formula
Creating Cube Formulas
Internal Cube Formula
Fact Data Security Ranges
MISSING
Calculation Depth
Introduction to PowerOLAP's Persistent Calculations
MDX
PowerOLAP Cube Formula Grammar
Internal Cube Formula
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Fact Data Security Ranges
Register and Activate the PowerOLAP Version 8 Client
Installation of the PowerOLAP Version 8 Client
Slice View Formatting
Licensing Tab
Register and Activate the PowerOLAP Version 8 Server
Quick Start Introduction
Installing PowerOLAP MDB Server
Create a New Synchronization Server
Installing Additional PowerOLAP Client Components
About PowerOLAP Services
IDS
PowerOLAP MDB Server Installation
Creating a PowerOLAP Database
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Active Directory Authentication
General Tab
PowerOLAP Server Installation for Non-Admin Users
PowerOLAP Client Installation for Non-Admin Users
Installing PowerOLAP MDB Server
PowerOLAP Version 8 MDB Server Installation
Register and Activate the PowerOLAP Version 8 Client
Register and Activate the PowerOLAP Version 8 Server
Register and Activate the PowerOLAP Client
Register and Activate the PowerOLAP Server
Register and Activate the PowerOLAP Client
Register and Activate the PowerOLAP Server
Licensing Tab
Register and Activate the PowerOLAP Client
Slice View Formatting
PowerOLAP Client Installation for Non-Admin Users
dbreadwrite
Add/Delete Members in Measures Dimension
User Considerations
IDS Performance Considerations
Modify Relational Dimension
Transfer Cube
Create and define IDS task to Pull Fact Data from a Remote Cube
General Tab
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Calculation Depth
About Meta Data
Create a New Linked Cube
Additional Information
Update Linked Cube
OLAP Services
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Create a Time Dimension
Creating an Excel Worksheet
Advanced PowerOLAP Worksheet Functions
Extended Drill-Through
Creating an Excel Worksheet
Advanced PowerOLAP Worksheet Functions
Member Types/ Hierarchy Dialog box
OLAPPivot
Granting Dimensions Meta Security Rights
The Edit Slice Dialog Box
Update Linked Cube
Excel Paste Functions
Changing Data Views from within Excel
Working with ODBC (Open Database Connectivity)
Define Members
OLAPRootCount
OLAPUserInGroup
Define Aliases
Meta Data Import Commands
Create/Save a Dimension Subset
Paste and Drill-Through Functions
Select Page MembersUsing Edit Slice
OLAPFactSecurityMember
OLAPCubeDimCount
OLAPAliasToMember
Introduction to the PowerOLAP MDB Server
OLAPTable
OLAPWriteAliasToCube
Use Partial Field Member Name
Create the SQL Server Login
Defining Users and Groups
Security Export/Import Feature
OLAPFactSecurityRuleCount
OLAPFactSecurityRuleName
OLAPSubsetCount
Creating a Slice View
Creating Dimensions
OLAPFactSecurityRangeMembers
New Slice Menu & OLAPNavigate
OLAPFactSecurityRule
OLAPDimensionSecurity
OLAPCubeDimension
Remove Existing Version
Creating a Dimension Hierarchy
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
Creating a Task (Internet Data Services)
Select Row or Column Members Using Edit Slice
Model Dimensions
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
Cube Formula Functions
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
PowerOLAP Scheduler
Process Cube (Rebuild Cube)
Create Additional Tables
Assigning Meta Data Security Privileges
Member Properties
OLAPFactSecurityStatus
OLAPChild
Granting Slices Meta Security Rights
OLAPSubsetMemberCount
Allow Duplicates
Process Cube for Fact or Meta Data Update
Configuring PowerOLAP Server Service to Logon as User Account
Setting New Slice Options
Formula Basics
OLAPAliasGroup
Granting Cube Security Rights
OLAPReadWrite
OLAPWrite
Selecting Page Members
Cube Properties
Add Members to 2nd, 3rd, etc Dimension
OLAPDimMaxLevel
Access Privileges
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
PowerOLAP Cube Formula Grammar
PowerOLAP's Add-In Menuand Toolbar
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
Creating the Measures Dimension
OLAPUser
Define Order
Caching
Slice View Formatting
Window, Tiled or Cascading Slices
Transfer Cube
OLAPCubeSecurity
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
Changing the Grid Layout
Define Members
Define Properties
Model Cubes
OLAPGroupCount
OLAPCube
OLAPCubeCount
Transaction Log
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Define Hierarchy
Adding Members to Dimensions
Create and define IDS task to Pull Fact Data from a Remote Cube
Creating Notification
Define Hierarchy
The OLAPPivot Function
OLAPCurrentUser
OLAPAlias
Define Drill Through
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Rearranging Dimensions within a Slice
Dynamic Multidimensional Graphs
Internal Cube Formula
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
Excel Functions List
Creating a Cube
OLAPMemberCount
Slice Commands
Importing and Exporting
lookup
OLAPChildCount
Adding a Server from within PowerOLAP
Restoring a Database
OLAPMemberType
OLAPRoot
Creating a PowerOLAP Database
Minimum Hardware Recommendations
Define Rollups / Drill-Through with Rollups
Fact Data Security Ranges
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
Alias Groups
Database Reference Formulas
Defining an ODBC Data Source between PowerOLAP and a SQL Server
OLAPSliceSecurity
Arranging Slice Dimensions
Conditional Retrieval
OLAPFactSecurityPrivileges
How to Create a Local Cube from a Remote Cube using IDS
Saving Your Work (.olt file)
Triggers and their use for Incremental Updating
Databases Supported for Use with OLAP Exchange
About Meta Data
Executing Cube Tasks in Excel
Installation of PowerOLAPCOM
OLAPRenameProperty
OLAPRenameMember
Re-defining a Dimension
OLAPRenameAlias
OLAPNavigate
OLAPWriteMemberToCube
MDX
OLAPQuery
Accessing a Secured Database
Executing PowerOLAP Scheduler Job in Excel
Member Types/ Hierarchy Dialog box
The Edit Slice Dialog Box
Cube Formula Functions
LITERAL
Make Changes On-line and then Synchronize
Incremental Update vs. Update from Source
Create a New Synchronization Server
When and why should you use IDS?
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Fact Data Security Ranges
PowerOLAP Cube Formula Grammar
ln
exp
Saving Your Work (.olt file)
Process Cube (Rebuild Cube)
PowerOLAP Scheduler
OLAPReadWrite
Process Cube for Fact or Meta Data Update
Cube Properties
Save Cache to File
Introduction to PowerOLAP Scheduler
Secure Database
Save Dependencies to File
Introduction to PowerOLAP's Persistent Calculations
User Considerations
levelcount
pmt
Working with OLAP Exchange on the MDB Server
Creating a Local Database from the Synchronization Server
Creating a PowerOLAP Database
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Register and Activate the PowerOLAP Client
IDS Performance Considerations
Working with OLAP Exchange as Client in a Server Scenario
Create a New Synchronization Server
Make Changes On-line and then Synchronize
Creating a Task (Internet Data Services)
OLAPSave
Process Cube for Fact or Meta Data Update
Creating a Cube from the MDB Server Control Program
Create and define IDS task to Push Fact Data from a Local Cube
Cross-Cube Formula
OLAPDatabase/OLAPOpen
Synchronizing Changes Via Synchronization Server
When and why should you use IDS?
Create and define IDS task to Pull Fact Data from a Remote Cube
How to Update the Fact Data of Local Cube from Remote Cube
Adding a Server from within PowerOLAP
Make Changes Offline and then Synchronize [Remote Capabilities]
Defining an ODBC Data Source between PowerOLAP and a SQL Server
User Considerations
How to Create a Local Cube from a Remote Cube using IDS
Concepts and Benefits
OLAPNavigate
Register and Activate the PowerOLAP Server
IDS - Internet Explorer Caching Setting
Active Directory Authentication
MDX
PowerOLAP Server Installation for Non-Admin Users
OLAPQuery
PowerOLAP Client Installation for Non-Admin Users
Working with OLAP Exchange on the MDB Server
Migrating OLP Databases with Cubes Built from OLAP Exchange,
Creating a Local Database from the Synchronization Server
Adding a Server from within PowerOLAP
OLAPNavigate
Create and define IDS task to Pull Fact Data from a Remote Cube
OLAPQuery
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
How to Update the Fact Data of Local Cube from Remote Cube
How to Create a Local Cube from a Remote Cube using IDS
Process Cube for Fact or Meta Data Update
User Considerations
Cross-Cube Formula
Register and Activate the PowerOLAP Version 8 Client
Creating a Local Database from the Synchronization Server
IDS Performance Considerations
Create a New Synchronization Server
Make Changes On-line and then Synchronize
Synchronizing Changes Via Synchronization Server
When and why should you use IDS?
Create and define IDS task to Pull Fact Data from a Remote Cube
Make Changes Offline and then Synchronize [Remote Capabilities]
User Considerations
How to Create a Local Cube from a Remote Cube using IDS
IDS - Internet Explorer Caching Setting
Active Directory Authentication
Creating a Local Database from the Synchronization Server
Synchronizing Changes Via Synchronization Server
OLAPSave
OLAPDatabase/OLAPOpen
Creating a Cube from the MDB Server Control Program
Create a New Synchronization Server
Make Changes On-line and then Synchronize
Creating a Task (Internet Data Services)
OLAPDatabase/OLAPOpen
Creating a Local Database from the Synchronization Server
Concepts and Benefits
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Administrator Topics
Create the SQL Server Login
Calculation Engines
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
Make Changes On-line and then Synchronize
OLAPSave
PowerOLAP Scheduler
Other Task Types
Error File Reporting
Configuring PowerOLAP Server Service to Logon as User Account
Closing a Database
Benefits Summary
PowerOLAP's Add-In Menuand Toolbar
Create and define IDS task to Push Fact Data from a Local Cube
OLAPDatabase/OLAPOpen
Installation of the PowerOLAP Client
PowerOLAP MDB Server Installation
When and why should you use IDS?
Create and define IDS task to Pull Fact Data from a Remote Cube
Add Users and Groups
Assigning Fact Data Security Privileges
Importing and Exporting
Accessing a Secured Database
Importing Data from a File
Concepts and Benefits
Register and Activate the PowerOLAP Server
PowerOLAP Server Installation for Non-Admin Users
Requirements and Recommendations
Location of the Client Installer
PowerOLAP Client Installation for Non-Admin Users
Partial Server Use for Database Creation from a Synchronization Server
Caching
Assigning Fact Data Security Privileges
Access Privileges
Dynamic Multidimensional Graphs
Applying Database Security
Fact Data Security Ranges
OLAPFactSecurityStatus
Synchronization Server database in SQL Server
Assigning Fact Data Security Privileges
Applying Database Security
Caching
Assigning Fact Data Security Privileges
Applying Database Security
Creating Notification
Meta Data Import Commands
Seeing Results in PowerOLAP (.olp file)
Transaction Log
Importing and Exporting
Synchronization Server database in SQL Server
Configuring PowerOLAP Server Service to Logon as User Account
Installing PowerOLAP MDB Server
Defining Users and Groups
Create the User Domain Account in the Active Directory
Transaction Log
Secure Database
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Register and Activate the PowerOLAP Server
Configuring PowerOLAP Server Service to Logon as User Account
Create the User Domain Account in the Active Directory
LOG
Cube Formula Functions
PowerOLAP Cube Formula Grammar
Administrator Topics
Create the SQL Server Login
Creating a Cube
Configure ODBC Data Source
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Create the SQL Server Login
Administrator Topics
Creating a Cube
Configure ODBC Data Source
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Active Directory Authentication
PowerOLAP Server Installation for Non-Admin Users
Accessing a Secured Database
Configuring PowerOLAP Server Service to Logon as User Account
OLAPCurrentUser
Create the User Domain Account in the Active Directory
Active Directory Authentication
Creating the Measures Dimension
Register and Activate the PowerOLAP Client
Define Aliases
Installing PowerOLAP MDB Server
Settings General & Format Preferences
Create a New Linked Cube
Use Partial Field Member Name
Calculation Engines
Creating a Slice View
Create a New Synchronization Server
Creating a Dimension Hierarchy
Make Changes On-line and then Synchronize
OLAPTable
OLAPReadWrite
Member Properties
Process Cube for Fact or Meta Data Update
Cube Properties
Add Members to 2nd, 3rd, etc Dimension
PowerOLAP Cube Formula Grammar
Using Slices to Navigate Cubes
Create a Time Dimension
Constraints
Cross-Cube Formula
Change Aliases
Define Properties
Create and define IDS task to Pull Fact Data from a Remote Cube
Define Drill Through
Entering Data in a Slice
Rearranging Dimensions within a Slice
Create Dimension Hierarchy
Excel Functions List
Assigning Fact Data Security Privileges
Slice Commands
lookup
Define Rollups / Drill-Through with Rollups
Incremental Update vs. Update from Source
Extended Drill-Through
Database Reference Formulas
Conditional Retrieval
Triggers and their use for Incremental Updating
Other Task Types
Cube Formula Functions
LOOKUP
Dynamic Multidimensional Graphs
Caching
Transaction Log
General Tab
Use Partial Field Member Name
PowerOLAP Cube Formula Grammar
lower
lower
upper
Change Hierarchy
Hierarchy
Make Changes On-line and then Synchronize
Make Changes Offline and then Synchronize [Remote Capabilities]