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