Process Cube for Fact or Meta Data Update
Granting Dimensions Meta Security Rights
mid
The Edit Slice Dialog Box
Preparing Relational Data for Use with OLAP Exchange
Dynamic Multidimensional Graphs
Grid Shortcut Menu Options
General Formatting and Printing
Grid Shortcut Menu Options
Grid Shortcut Menu Options
Zero Suppression
General Formatting and Printing
Setting New Slice Options
Dynamic Multidimensional Graphs
Set 3GB Startup Switch in Windows
Meta Data Import Commands
Select Page MembersUsing Edit Slice
AGGREGATESUM
The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
New Slice Menu & OLAPNavigate
Creating a Dimension Hierarchy
Select Row or Column Members Using Edit Slice
Model Dimensions
Property Groups
Create Additional Tables
Aggregate Weights
Process Cube for Fact or Meta Data Update
SUMMARY: The Dimension Hierarchy Toolbar
Setting New Slice Options
IDS – HTTP Interface and REST
Cube Properties
OLAPPivot
PowerOLAP Cube Formula Grammar
Aggregate Weights
Define Links—Snowflake Schema
Define Order
The Edit Slice Dialog Box
Model Cubes
Define Hierarchy
Adding Members to Dimensions
Grid features Drill-Down on Members and Data within the Slice
Change Hierarchy
Entering Data in a Slice
Create Dimension Hierarchy
Selecting a Page Member to View in Excel
Define Hierarchy— Creating Dimension Hierarchies
Change Properties
Importing and Exporting
Creating Cube Formulas
Define Rollups / Drill-Through with Rollups
Summary of Quick Start Exercises
Alias Groups
Changing Data Views from within Excel
Hierarchy
Triggers and their use for Incremental Updating
About Meta Data
ischildof
Entering Data from within Excel
levelcount
OLAPMemberNext
Make Changes On-line and then Synchronize
alias
Add Members to 2nd, 3rd, etc Dimension
ROOTCOUNT
OLAPDimMaxLevel
Access Privileges
OLAPMemberLevel
level
Granting Dimensions Meta Security Rights
Change Aliases
Additional Information
Excel Functions List
lookup
WEIGHT
OLAPMemberType
Add/Delete Members in Measures Dimension
ROOT
Creation of Ragged and Multiple Hierarchies
Creating a Dimension Hierarchy
Create Additional Tables
Define Hierarchy
The Edit Slice Dialog Box
About Meta Data
WEIGHT
About Meta Data
ischildof
The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
Creating a Dimension Hierarchy
Aggregate Weights
Aggregate Weights
Create Dimension Hierarchy
Creating Cube Formulas
SUMMARY: The Dimension Hierarchy Toolbar
Member Types/ Hierarchy Dialog box
Property Groups
Aggregate Weights
Add Members to 2nd, 3rd, etc Dimension
Aggregate Weights
Change Aliases
Change Hierarchy
Create Dimension Hierarchy
Creating Cube Formulas
Define Rollups / Drill-Through with Rollups
Alias Groups
Hierarchy
Creating a Dimension Hierarchy
Make Changes On-line and then Synchronize
Member Types/ Hierarchy Dialog box
Property Groups
Add Members to 2nd, 3rd, etc Dimension
Aggregate Weights
Change Aliases
Change Hierarchy
Create Dimension Hierarchy
Define Rollups / Drill-Through with Rollups
Alias Groups
Hierarchy
Creating a Dimension Hierarchy
Make Changes On-line and then Synchronize
Creating Cube Formulas
Changing Data Views from within Excel
New Slice Menu & OLAPNavigate
Select Row or Column Members Using Edit Slice
OLAPPivot
The Edit Slice Dialog Box
Entering Data in a Slice
Changing Data Views from within Excel
Calculation Engines
Dynamic Multidimensional Graphs
OLAPFactSecurityMember
OLAPDimMaxLevel
Caching
General Tab
Calculation Depth
OLAPFactSecurityMember
OLAPDimMaxLevel
Use Partial Field Member Name
Formula Basics
Caching
Entering Data in a Slice
Quick Start Introduction
Granting Cube Security Rights
Changing Data Views from within Excel
MIN
MOD
MAX
ROUND
PowerOLAP Cube Formula Grammar
TIME
hour
Working with OLAP Exchange as Client in a Server Scenario
Create/Save a Dimension Subset
Select Page MembersUsing Edit Slice
aggregatesum
Create the SQL Server Login
Defining Users and Groups
Stack or Nest Dimensions
Calculation Engines
OLAPTable
Creation of Ragged and Multiple Hierarchies
Create a New Synchronization Server
Member Types/ Hierarchy Dialog box
OLAPFactSecurityRangeMembers
Dependencies
Enable Caching
Make Changes On-line and then Synchronize
OLAPAliasGroupCount
OLAPParentCount
Process Cube (Rebuild Cube)
Other Task Types
Assigning Meta Data Security Privileges
OLAPPivot
Process Cube for Fact or Meta Data Update
Working with OLAP Exchange on the MDB Server
Add Members to 2nd, 3rd, etc Dimension
Modify Relational Dimension
Seeing Results in PowerOLAP (.olp file)
Cube Properties
OLAPDimMaxLevel
Building & Updating Cubes that Support Incremental Updating
Using Slices to Navigate Cubes
Aggregate Weights
OLAPDimCount
Define Order
Creating the Measures Dimension
Transfer Cube
Cross-Cube Formula
Caching
Slice View Formatting
Synchronizing Changes Via Synchronization Server
The Edit Slice Dialog Box
Creating Cube Formulas
OLAPCubeCount
OLAPGroupCount
Define Hierarchy Creating Dimension Hierarchies
How to Grant Database Privileges
Create and define IDS task to Pull Fact Data from a Remote Cube
Update Linked Cube
Removing Expired Locks
Saving / Launching PowerOLAP Databases from within Excel
How to Update the Fact Data of Local Cube from Remote Cube
Entering Data in a Slice
Rearranging Dimensions within a Slice
Creating a New JOB
Secure Database
Assigning Fact Data Security Privileges
Importing and Exporting
Slice Commands
OLAPChildCount
OLAPMemberCount
lookup
Incremental Update vs. Update from Source
Creating Cube Formulas
MDX
Fact Data Import Commands
Applying Database Security
Summary of Quick Start Exercises
Extended Drill-Through
Accessing a Secured Database
Set 3GB Startup Switch in Windows
Changing Data Views from within Excel
Database Reference Formulas
Calculation Depth
OLAPPropertyGroupCount
PV
Conditional Retrieval
Quick Start Introduction
Arranging Slice Dimensions
Defining an ODBC Data Source between PowerOLAP and a SQL Server
Introduction to PowerOLAP's Persistent Calculations
User Considerations
Working with Cubes
Triggers and their use for Incremental Updating
Creating the 2nd Dimension
Creating a Cube via OLAP Exchange
How to Create a Local Cube from a Remote Cube using IDS
About Meta Data
len
upper
WEEKDAY
now
date
dbread
month
SECOND
oledbread
day
TIME
TODAY
dbreadwrite
minute
YEAR
hour
General Formatting and Printing
Grid Shortcut Menu Options
IDS Performance Considerations
IDS – HTTP Interface and REST
Quick Start Introduction
How to Create a Local Cube from a Remote Cube using IDS
Create and define IDS task to Pull Fact Data from a Remote Cube
PowerOLAP Service Control Program
IDS Performance Considerations
IDS
DBREAD
DBREADWRITE