IDS Performance Considerations
Creating a Slice View
Enable Caching
Selecting Page Members
Adding Members to Dimensions
Entering Data in a Slice
Modify or Delete Existing Jobs
Slice Commands
Summary of Quick Start Exercises
Set 3GB Startup Switch in Windows
How to Create a Local Cube from a Remote Cube using IDS
PowerOLAP Client Installation for Non-Admin Users
Creating a Slice View
Modify or Delete Existing Jobs
The Dimension Hierarchy Toolbar
SUMMARY: The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
Add to or Remove Members from a Subset
Mark Member as Persistent
Advanced PowerOLAP Worksheet Functions
Database Reference Formulas
Paste and Drill-Through Functions
Creating a Slice View
Register and Activate the PowerOLAP Version 8 Client
OLAPReadWrite
OLAPPivot
Caching
Slice View Formatting
General Tab
Register and Activate the PowerOLAP Version 8 Server
PowerOLAP Cube Formula Grammar
Create/Save a Dimension Subset
Select Page MembersUsing Edit Slice
Selecting Page Members
Cube Properties
Changing the Grid Layout
The Edit Slice Dialog Box
Add to or Remove Members from a Subset
Entering Data in a Slice
Create/Save a Dimension Subset
Select Page MembersUsing Edit Slice
Selecting Page Members
Cube Properties
PowerOLAP Cube Formula Grammar
Changing the Grid Layout
The Edit Slice Dialog Box
Add to or Remove Members from a Subset
Entering Data in a Slice
The Edit Slice Dialog Box
Create/Save a Dimension Subset
Select Page MembersUsing Edit Slice
Selecting Page Members
Cube Properties
PowerOLAP Cube Formula Grammar
Changing the Grid Layout
Entering Data in a Slice
Create/Save a Dimension Subset
Delete a Subset
Add to or Remove Members from a Subset
Entering Data in a Slice
Rename a Subset
Create a New Linked Cube
oledbreadwrite
Access Privileges
dbreadwrite
asreadwrite
pmt
PPMT
fv
PV
ipmt
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
Caching
Calculation Engines
Enable Caching
Cube Properties
Process Cube for Fact or Meta Data Update
Cube Properties
Administrator Topics
Create a New Linked Cube
Enabling a Database for Security
Create a New Synchronization Server
Process Cube for Fact or Meta Data Update
Allow Duplicates
Cube Properties
Building & Updating Cubes that Support Incremental Updating
Internal Cube Formula
Creating a New JOB
Assigning Fact Data Security Privileges
Adding a Server from within PowerOLAP
Make Changes Offline and then Synchronize [Remote Capabilities]
Define Rollups / Drill-Through with Rollups
Granting Rights to Add Dimensions and Cubes
How to Create a Local Cube from a Remote Cube using IDS
Create/Save a Dimension Subset
Excel Integration
OLAPTable
Create the SQL Server Login
Calculation Engines
Portal Tab
OLAPDimensionSecurity
Dependencies
OLAPIsSecureDatabase
Use SQL Views
OLAPReadWrite
PowerOLAP Service Control Program
Creating a Cube
Save Blank Members as [Undefined]
Setting New Slice Options
OLAPPivot
OLAPGroup
Creating the Measures Dimension
Define Links
OLAPUser
Register and Activate the PowerOLAP Server
Create and define IDS task to Push Fact Data from a Local Cube
About PowerOLAP Services
Caching
Entering Data through an Excel Worksheet
Cross-Cube Formula
Granting Dimensions Meta Security Rights
IDS
Continue to Next Task on Error
The Edit Slice Dialog Box
Creating an Excel Worksheet
OLAPGroupCount
Creating an Excel Worksheet
Transaction Log
Creating a Local Database from the Synchronization Server
OLAPCurrentUser
General Tab
Define Drill Through
Introduction to PowerOLAP SCHEDULER
Create Dimension Hierarchy
Concepts and Benefits / Requirements
Excel Paste Functions
Importing and Exporting
Creating Cube Formulas
Creating a PowerOLAP Database
Incremental Update vs. Update from Source
OLAPUserCount
OLAPUserGroupCount
Extended Drill-Through
Database Reference Formulas
Calculation Depth
Defining an ODBC Data Source between PowerOLAP and a SQL Server
OLAPSliceSecurity
Quick Start Introduction
Ramifications of Modify Relational Dimension
Creating a Cube via OLAP Exchange
Concepts and Benefits
About Meta Data
Active Directory Authentication
Requirements and Recommendations
Partial Server Use for Database Creation from a Synchronization Server
Create a New Linked Cube
Define Rollups / Drill-Through with Rollups
Administrator Topics
Partial Server Use for Database Creation from a Synchronization Server
Benefits Summary
IDS HTTP Interface and REST
Dependencies
General Tab
Internal Cube Formula
OLAPUserInGroup
OLAPAliasToMember
Entering Data from within Excel
Defining Users and Groups
Model Dimensions
Configuring PowerOLAP Server Service to Logon as User Account
ALIAS
Changes by Student in Read Write Group
OLAPCanAddDimensionAndCubes
ALIASTOMEMBER
Entering Data through an Excel Worksheet
The Edit Slice Dialog Box
Create and define IDS task to Pull Fact Data from a Remote Cube
Saving / Launching PowerOLAP Databases from within Excel
OLAPAlias
Entering Data in a Slice
Entering Data in a Slice
Assigning Fact Data Security Privileges
Creating Cube Formulas
Database Reference Formulas
OLAPRootCount
Register and Activate the PowerOLAP Client
Meta Data Import Commands
Excel Integration
Member Aliases & Alias Groups
OLAPFactSecurityMember
OLAPCubeDimCount
WEEKDAY
ischildof
aggregatesum
Installing PowerOLAP MDB Server
OLAPTable
OLAPWriteAliasToCube
Create the SQL Server Login
OLAPFactSecurityRuleCount
Calculation Engines
log
OLAPFactSecurityRuleName
ABS
asin
OLAPSubsetCount
Creating a Slice View
Creating Dimensions
Create a New Synchronization Server
OLAPFactSecurityRangeMembers
Save Slice
Member Types/ Hierarchy Dialog box
OLAPFactSecurityRule
SIN
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
date
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
Assigning Meta Data Security Privileges
OLAPReadWrite
parent
SQRT
OLAPFactSecurityStatus
OLAPChild
OLAPSubsetMemberCount
Aggregate Weights
Process Cube for Fact or Meta Data Update
PROPERTY
OLAPAliasGroup
cubedimcount
acos
Saving Changes to a Database
OLAPReadWrite
OLAPWrite
Cube Properties
OLAPPivot
ROOTCOUNT
month
OLAPDimMaxLevel
childcount
code
cos
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
PowerOLAP Cube Formula Grammar
Aggregate Weights
SECOND
OLAPDimCount
OLAPGroup
OLAPUser
RAND
OLAPCubeSecurity
cubedim
OLAPDatabase/OLAPOpen
OLAPMemberFirst
Installation of the PowerOLAP Client
Create the User Domain Account in the Active Directory
Creating an Excel Worksheet
Model Cubes
OLAPGroupCount
OLAPCube
OLAPCubeCount
atan
Accessing the Database by a User with Read-Only Rights
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Adding Members to Dimensions
PowerOLAP MDB Server Installation
Creating a Local Database from the Synchronization Server
Configure ODBC Data Source
The OLAPPivot Function
ln
OLAPCurrentUser
TAN
day
General Tab
Advanced PowerOLAP Worksheet Functions
Internal Cube Formula
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIMESTRING
OLAPMemberCount
Secure Database
Excel Paste Functions
Slice Commands
Importing and Exporting
parentcount
lookup
minute
WEIGHT
OLAPChildCount
Restoring a Database
OLAPMemberType
OLAPRoot
Fact Data Security Ranges
YEAR
int
exp
Summary of Quick Start Exercises
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
Changing Data Views from within Excel
Calculation Depth
PV
min
ismissing
Importing Data from a File
OLAPSliceSecurity
Introduction to PowerOLAP's Persistent Calculations
User Considerations
OLAPFactSecurityPrivileges
hour
child
About Fact Data in Cubes
ROOT
max
OLAPRenameProperty
The Dimension Hierarchy Toolbar
OLAPRenameMember
Other Task Types
SUMMARY: The Dimension Hierarchy Toolbar
OLAPRenameAlias
Cube Properties
OLAPNavigate
OLAPFormula
Register and Activate the PowerOLAP Server
Persistent Calculations - Design Mode Option
OLAPWriteMemberToCube
OLAPQuery
Make Changes Offline and then Synchronize [Remote Capabilities]
Set 3GB Startup Switch in Windows
OLAPIsFormula
OLAPNavigateRW
Entering Data from within Excel
Entering Data in a Slice
Entering Data in a Slice
OLAPAliasToMember
ALIAS
OLAPCanAddDimensionAndCubes
ALIASTOMEMBER
OLAPAlias
Entering Data in a Slice
Excel Integration
Entering Data from within Excel
Assigning Meta Data Security Privileges
Saving Changes to a Database
Cube Properties
Entering Data through an Excel Worksheet
Creating an Excel Worksheet
Entering Data in a Slice
Summary of Quick Start Exercises
Importing Data from a File
About Fact Data in Cubes
Creating Dimensions
Internal Cube Formula
Assigning Fact Data Security Privileges
Slice Commands
Make Changes Offline and then Synchronize [Remote Capabilities]
Internal Cube Formula
Assigning Fact Data Security Privileges
Creating Dimensions
Slice Commands
Error File Reporting
Allow Duplicates
Seeing Results in PowerOLAP (.olp file)
Define Links—Star Schema
Security Export/Import Feature
Error File Reporting
Additional Considerations for Data Preparation
Meta Data Import Commands
Security Export/Import Feature
Seeing Results in PowerOLAP (.olp file)
Continue to Next Task on Error
Make Changes On-line and then Synchronize
CHILD
Register and Activate the PowerOLAP Client
PowerOLAP Client Installation for Non-Admin Users
code
exact
PowerOLAP Cube Formula Grammar
lookup
Setting New Slice Options
Importing Data from a File
OLAPUserInGroup
OLAPRootCount
OLAPFactSecurityMember
OLAPOpen
OLAPCubeDimCount
Paste and Drill-Through Functions
Excel Integration
OLAPAliasToMember
OLAPWriteAliasToCube
OLAPFactSecurityRuleName
OLAPTable
Entering Data from within Excel
OLAPFactSecurityRuleCount
Create a New Linked Cube
OLAPSubsetCount
OLAPFactSecurityRule
OLAPFactSecurityRangeMembers
Creating a Slice View
The Dimension Hierarchy Toolbar
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Member Types/ Hierarchy Dialog box
New Slice Menu & OLAPNavigate
Designer Slices can be Fully Formatted and Printed
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
OLAPIsSecureDatabase
OLAPMember
OLAPTable
OLAPDimension
OLAPMemberIndex
OLAPSave
OLAPPivot
OLAPRead
OLAPFactSecurityStatus
OLAPReadWrite
Member Properties
OLAPChild
OLAPSubsetMemberCount
Format Tab
SUMMARY: The Dimension Hierarchy Toolbar
Setting New Slice Options
OLAPAliasGroup
OLAPWrite
OLAPDimMaxLevel
OLAPReadWrite
OLAPPivot
OLAPMemberLevel
OLAPParent
OLAPMemberProperty
OLAPGroup
PowerOLAP Cube Formula Grammar
PowerOLAP's Add-In Menuand Toolbar
OLAPDimCount
OLAPCanAddDimensionAndCubes
OLAPUser
About PowerOLAP Services
Create a Time Dimension
Entering Data through an Excel Worksheet
OLAPCubeSecurity
OLAPMemberFirst
OLAPGroupCount
OLAPCube
Creating an Excel Worksheet
OLAPCubeCount
OLAPSubsetMember
OLAPSubset
OLAPPropertyGroup
Creating an Excel Worksheet
The OLAPPivot Function
Saving / Launching PowerOLAP Databases from within Excel
OLAPCurrentUser
OLAPAlias
OLAPFactSecurityMemberCount
OLAPIsParentOf
General Tab
OLAPIsChildOf
Define Drill Through
Advanced PowerOLAP Worksheet Functions
Excel Functions List
Selecting a Page Member to View in Excel
Concepts and Benefits / Requirements
Importing and Exporting
OLAPChildCount
OLAPMemberCount
OLAPRoot
OLAPMemberType
Summary of Quick Start Exercises
OLAPWeight
OLAPUserGroupCount
OLAPUserCount
OLAPPropertyGroupCount
Extended Drill-Through
Changing Data Views from within Excel
Database Reference Formulas
OLAP AliasGroupCount
OLAPSliceSecurity
OLAPFactSecurityPrivileges
Quick Start Introduction
Importing Data from a File
About Fact Data in Cubes
Cube Formula Functions
Entering Data in a Slice
Excel Paste Functions
lookup
Fact Data Import Commands
Executing Cube Tasks in Excel
OLAPRenameProperty
OLAPRenameMember
OLAPRenameAlias
OLAPNavigate
OLAPFormula
OLAPWriteMemberToCube
OLAPQuery
OLAPIsFormula
Executing PowerOLAP Scheduler Job in Excel
OLAPNavigateRW
PowerOLAP Client Installation for Non-Admin Users
Creating a Slice View
OLAPReadWrite
OLAPPivot
Creating an Excel Worksheet
Creating an Excel Worksheet
General Tab
Quick Start Introduction
Saving / Launching PowerOLAP Databases from within Excel
Advanced PowerOLAP Worksheet Functions
Database Reference Formulas
Advanced PowerOLAP Worksheet Functions
Changing Data Views from within Excel
Database Reference Formulas
Client Mode - PowerOLAP as Client to Analysis Services Cubes
Saving / Launching PowerOLAP Databases from within Excel
Excel Integration
OLAPTable
OLAPReadWrite
OLAPPivot
General Formatting and Printing
Grid Shortcut Menu Options
Executing Cube Tasks in Excel
Executing PowerOLAP Scheduler Job in Excel
Excel Functions List
Advanced PowerOLAP Worksheet Functions
Database Reference Formulas
Advanced PowerOLAP Worksheet Functions
Excel Functions List
OLAPNavigate
Excel Integration
Entering Data in a Slice
About Fact Data in Cubes
Cube Formula Functions
Advanced PowerOLAP Worksheet Functions
Excel Functions List
Excel Paste Functions
PowerOLAP's Add-In Menuand Toolbar
Advanced PowerOLAP Worksheet Functions
Entering Data through an Excel Worksheet
Creating an Excel Worksheet
Creating an Excel Worksheet
Excel Integration
Paste and Drill-Through Functions
Entering Data from within Excel
Create a New Linked Cube
The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
OLAPTable
OLAPReadWrite
Member Properties
Setting New Slice Options
SUMMARY: The Dimension Hierarchy Toolbar
OLAPPivot
Saving / Launching PowerOLAP Databases from within Excel
General Tab
Advanced PowerOLAP Worksheet Functions
Excel Functions List
Summary of Quick Start Exercises
Changing Data Views from within Excel
Database Reference Formulas
Importing Data from a File
Quick Start Introduction
About Fact Data in Cubes
OLAPNavigate
OLAPQuery
Creating an Excel Worksheet
Creating an Excel Worksheet
Property Groups
Cross-Cube Formula
Importing and Exporting
Incremental Update vs. Update from Source
Quick Start Introduction
User Considerations
Set 3GB Startup Switch in Windows
How to Create a Local Cube from a Remote Cube using IDS
Installing PowerOLAP MDB Server
PowerOLAP Client Installation
Installing Additional PowerOLAP Client Components
PowerOLAP MDB Server Installation
Create and define IDS task to Push Fact Data from a Local Cube
Set the Frequency of the Scheduled Job/Task
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
Introduction to the PowerOLAP MDB Server
Dependencies
Building & Updating Cubes that Support Incremental Updating
Transfer Cube
iserror
Execute SQL via ODBC
Creating a New JOB
Importing and Exporting
NOT
How to Create a Local Cube from a Remote Cube using IDS
Executing Cube Tasks in Excel
Dependencies
Other Task Types
IDS - Internet Explorer Caching Setting
Persistent Calculations - Design Mode Option
Execute a Scheduler Job
MDX
Executing PowerOLAP Scheduler Job in Excel
Transfer Cube
Executing Cube Tasks in Excel
Importing and Exporting
Executing PowerOLAP Scheduler Job in Excel
Exercises
Excel Integration
Select Page MembersUsing Edit Slice
Member Aliases & Alias Groups
Create a New Linked Cube
Creating a Slice View
Member Types/ Hierarchy Dialog box
Make Changes On-line and then Synchronize
OLAPTable
Error File Reporting
Aggregate Weights
Formula Basics
Aggregate Weights
Create and define IDS task to Push Fact Data from a Local Cube
Synchronizing Changes Via Synchronization Server
Add New Member to Display Results
Accessing the Database by a User with Read-Only Rights
How to Grant Database Privileges
Define Hierarchy
Entering Data in a Slice
Advanced PowerOLAP Worksheet Functions
Internal Cube Formula
Create Dimension Hierarchy
Creating a Cube
Importing and Exporting
Creating Cube Formulas
Make Changes Offline and then Synchronize [Remote Capabilities]
Accessing a Secured Database
Database Reference Formulas
Importing Data from a File
Granting Rights to Add Dimensions and Cubes
How to Create a Local Cube from a Remote Cube using IDS
Concepts and Benefits
Summary of Quick Start Exercises
Requirements and Recommendations
Meta Data Import Commands
Create a New Synchronization Server
New Slice Menu & OLAPNavigate
Creating a Dimension Hierarchy
PowerOLAP Version 8 MDB Server Installation
Assigning Meta Data Security Privileges
Process Cube for Fact or Meta Data Update
EXACT
Installation of the PowerOLAP Version 8 Client
PowerOLAP Cube Formula Grammar
Add New Member to Display Results
Model Cubes
Update Linked Cube
Slice Commands
Importing and Exporting
Applying Database Security
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Meta Data Import Commands
Process Cube for Fact or Meta Data Update
Add New Member to Display Results
Model Cubes
Meta Data Import Commands
New Slice Menu & OLAPNavigate
Assigning Meta Data Security Privileges
PowerOLAP Cube Formula Grammar
Importing and Exporting
PowerOLAP Version 8 MDB Server Installation
Installation of the PowerOLAP Version 8 Client
Slice Commands
Using Slices to Navigate Cubes
Dependencies Grammar Definition
PowerOLAP Cube Formula Grammar
ln
exp
ln
exp
New Slice Menu & OLAPNavigate
Make Changes On-line and then Synchronize
Add Users and Groups
Define Rollups / Drill-Through with Rollups
Create the SQL Server Login
Stack or Nest Dimensions
PowerOLAP Service Control Program
Setting New Slice Options
Modify Relational Dimension
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
Change Hierarchy
Advanced PowerOLAP Worksheet Functions
Create Dimension Hierarchy
Secure Database
Creating Cube Formulas
Make Changes Offline and then Synchronize [Remote Capabilities]
Changing Data Views from within Excel
Hierarchy
Triggers and their use for Incremental Updating
About Meta Data
Synchronization Server database in SQL Server
New Slice Menu & OLAPNavigate
The Edit Slice Dialog Box
Drill-Up/ Drill-Down Aggregate members in Rows and Columns
New Slice Menu & OLAPNavigate
OLAPFactSecurityPrivileges
OLAPRootCount
OLAPUserInGroup
Create/Save a Dimension Subset
Select Page MembersUsing Edit Slice
OLAPFactSecurityMember
OLAPCubeDimCount
OLAPAliasToMember
OLAPTable
OLAPWriteAliasToCube
OLAPFactSecurityRuleCount
OLAPFactSecurityRuleName
OLAPSubsetCount
Creating a Slice View
OLAPFactSecurityRangeMembers
Formula Syntax and Terminology
Member Types/ Hierarchy Dialog box
OLAPFactSecurityRule
OLAPDimensionSecurity
OLAPCubeDimension
OLAPUserGroup
OLAPParentCount
OLAPMemberToAlias
OLAPMemberNext
OLAPDimension
OLAPIsSecureDatabase
OLAPAliasGroupCount
OLAPMember
Cube Formula Functions
OLAPSave
OLAPRead
OLAPPivot
OLAPMemberIndex
Introduction to Formula Basic, Cube Formulas, Dependencies &
SUBSTITUTE
OLAPFactSecurityStatus
OLAPChild
Creating a Cube
OLAPSubsetMemberCount
Save Blank Members as [Undefined]
Formula Basics
REPLACE
OLAPAliasGroup
OLAPReadWrite
OLAPWrite
Modify Relational Dimension
Add Members to 2nd, 3rd, etc Dimension
OLAPPivot
month
OLAPDimMaxLevel
OLAPParent
OLAPMemberProperty
OLAPMemberLevel
SECOND
OLAPDimCount
OLAPGroup
OLAPCanAddDimensionAndCubes
OLAPUser
OLAPCubeSecurity
OLAPDatabase/OLAPOpen
OLAPMemberFirst
The Edit Slice Dialog Box
Creating an Excel Worksheet
Model Cubes
OLAPGroupCount
OLAPCube
OLAPCubeCount
OLAPSubset
OLAPSubsetMember
OLAPPropertyGroup
Saving / Launching PowerOLAP Databases from within Excel
OLAPCurrentUser
OLAPAlias
day
Advanced PowerOLAP Worksheet Functions
Internal Cube Formula
Create Dimension Hierarchy
OLAPFactSecurityMemberCount
OLAPIsChildOf
OLAPIsParentOf
TIMESTRING
Excel Functions List
OLAPMemberCount
Assigning Fact Data Security Privileges
Secure Database
minute
OLAPChildCount
Creating Cube Formulas
OLAPMemberType
OLAPRoot
OLAPWeight
OLAPUserCount
OLAPUserGroupCount
OLAPPropertyGroupCount
ismissing
OLAPSliceSecurity
Quick Start Introduction
hour
Creating a Cube via OLAP Exchange
About Meta Data
OLAPRenameProperty
OLAPRenameMember
OLAPRenameAlias
OLAPNavigate
OLAPFormula
OLAPWriteMemberToCube
OLAPQuery
OLAPIsFormula
OLAPNavigateRW
Meta Data Import Commands
Calculation Engines
Security Export/Import Feature
Transfer/Export/Clear Cube
About PowerOLAP Services
Importing and Exporting
Fact Data Import Commands
About Fact Data in Cubes
Export Slice
Transfer Cube
IDS
Executing Cube Tasks in Excel
Persistent Calculations - Design Mode Option
MDX
Executing PowerOLAP Scheduler Job in Excel
Transfer Cube
Importing and Exporting
Executing Cube Tasks in Excel
Importing and Exporting
Executing Cube Tasks in Excel
Export Slice
Importing and Exporting
MDX
Benefits Summary
Define Drill Through
Concepts and Benefits / Requirements
Extended Drill-Through