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