<<

S - The column
Sale Price
   RIGHT
   TRIM
   left
Sales
   Stack or Nest Dimensions
   Calculation Engines
   Creating a Dimension Hierarchy
   OLAPRenameMember
   Error File Reporting
   Aggregate Weights
   OLAPNavigate
   OLAPPivot
   Zero Suppression
   Aggregate Weights
   Create and define IDS task to Push Fact Data from a Local Cube
   Cross-Cube Formula
   Creating Cube Formulas
   Add New Member to Display Results
   Entering Data in a Slice
   Advanced PowerOLAP Worksheet Functions
   Internal Cube Formula
   Entering Data in a Slice
   Slice Commands
   OLAPQuery
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Database Reference Formulas
    calculate Cost
    choose
    compute
    Cost
       Aggregate Weights
       Aggregate Weights
       Add New Member to Display Results
       Entering Data in a Slice
       Entering Data in a Slice
    in Cost
       Aggregate Weights
       Zero Suppression
       Aggregate Weights
    Luxembourg
    Margin
    Member Cost
    Region Canada
    Select
Sales Account dimension
Sales Accounts
   Excel Integration
   Stack or Nest Dimensions
   Select Row or Column Members Using Edit Slice
   Error File Reporting
   OLAPPivot
   Zero Suppression
   Aggregate Weights
   Cross-Cube Formula
   Entering Data in a Slice
   Rearranging Dimensions within a Slice
   Internal Cube Formula
   Slice Commands
   Changing Data Views from within Excel
Sales Acount
Sales columns
    Cost
Sales cube
   Excel Integration
   Zero Suppression
   Cross-Cube Formula
   Creating Cube Formulas
   Entering Data in a Slice
   Internal Cube Formula
   Slice Commands
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Partial Server Use for Database Creation from a Synchronization Server
Sales cube's Margin
Sales data
    Cost
Sales in
   Aggregate Weights
   Aggregate Weights
    as the weight of Cost
    Cost
Sales Person
Sales Representative
   Property Groups
   Define PropertiesCreate a Properties Group
Sales value
Salespeople
   Member Types/ Hierarchy Dialog box
   Model Cubes
   Create Dimension Hierarchy
Salesperson
   Member Types/ Hierarchy Dialog box
   Model Dimensions
   About Meta Data
Salesperson dimension
   Member Properties
   Create Dimension Hierarchy
Salesperson Hierarchy
Sample database
Save
   Create/Save a Dimension Subset
   General Formatting and Printing
   Grid Shortcut Menu Options
   Saving Changes to a Database
   Saving / Launching PowerOLAP Databases from within Excel
   Entering Data in a Slice
   Dynamic Multidimensional Graphs
   Slice Commands
   Creating a PowerOLAP Database
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Save Database/Save and Backup Database/Update from Synchronize
   User Considerations
   Graph's Shortcut menu options
   Saving Your Work (.olt file)
   Excel Integration
   Paste and Drill-Through Functions
   Security Export/Import Feature
   Calculation Engines
   Stack or Nest Dimensions
   Creating a Slice View
   The Dimension Hierarchy Toolbar
   Save Slice
   Member Types/ Hierarchy Dialog box
   Dependencies
   OLAPSave
   Process Cube (Rebuild Cube)
   Assigning Meta Data Security Privileges
   Save Blank Members as [Undefined]
   Cube Properties
   Add Members to 2nd, 3rd, etc Dimension
   OLAPPivot
   Closing a Database
   Exercises
   Access Privileges
   Creating a Cube from the MDB Server Control Program
   Building & Updating Cubes that Support Incremental Updating
   PowerOLAP Cube Formula Grammar
   Caching
   Transfer Cube
   OLAPDatabase/OLAPOpen
   Change Aliases
   Model Cubes
   Creating an Excel Worksheet
   General Tab
   Change Hierarchy
   Secure Database
   Excel Paste Functions
   Importing and Exporting
   Creating Cube Formulas
   Restoring a Database
   Add/Delete Members in Measures Dimension
   Define Rollups / Drill-Through with Rollups
   Summary of Quick Start Exercises
   PV
   Importing Data from a File
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   OLAPSliceSecurity
   Arranging Slice Dimensions
   Ramifications of Modify Relational Dimension
   How to Create a Local Cube from a Remote Cube using IDS
   Dependencies
   PowerOLAP Service Control Program
   Cube Properties
   OLAPNavigate
   Save Cache to File
   Transaction Log
   Active Directory Authentication
   Modify or Delete Existing Jobs
   OLAPQuery
   Save Dependencies to File
   Set 3GB Startup Switch in Windows
    Changes
    Click OK
    Database
    Fact Data
    New Slice
    OK
    Slice
       General Formatting and Printing
       Grid Shortcut Menu Options
       Slice Commands
       Make Changes Offline and then Synchronize [Remote Capabilities]
    Subset
    Your Work
Save All
   Saving Changes to a Database
   Model Cubes
   Entering Data in a Slice
   Creating Cube Formulas
   Importing Data from a File
   Closing a Database
   Importing and Exporting
Save As
   Creating a Slice View
   Save Slice
   Arranging Slice Dimensions
   Excel Integration
   General Formatting and Printing
   Grid Shortcut Menu Options
   Creating an Excel Worksheet
   Dynamic Multidimensional Graphs
   Creating a PowerOLAP Database
   Graph's Shortcut menu options
   How to Create a Local Cube from a Remote Cube using IDS
   Saving Your Work (.olt file)
Save as png file
Save As dialog
   Importing and Exporting
   Creating a PowerOLAP Database
   Saving Your Work (.olt file)
    open
Save as JPEG
Save As Option
Save as PNG
Save as Text file
   General Formatting and Printing
   Grid Shortcut Menu Options
Save Blank Members
Save button
Save Cache
   Cube Properties
   Save Cache to File
    File
       Cube Properties
       Save Cache to File
Save Changes
   Saving / Launching PowerOLAP Databases from within Excel
   OLAPSave
   Saving Changes to a Database
   Entering Data in a Slice
   Secure Database
   Importing and Exporting
   Summary of Quick Start Exercises
   Importing Data from a File
   Modify or Delete Existing Jobs
Save command—Save All
Save Cube Changes
    Disk
Save Current Database
Save Current Database In Modeler
    use
Save Database
   Saving Changes to a Database
   Cube Properties
   Exercises
   Model Cubes
   Entering Data in a Slice
   Importing and Exporting
   Save Database/Save and Backup Database/Update from Synchronize
   General Tab
Save Database toolbar button
Save Database/Save
Save Slice
   Creating a Slice View
   Save Slice
   Slice Commands
   Assigning Meta Data Security Privileges
   Closing a Database
   Access Privileges
   Entering Data in a Slice
   Make Changes Offline and then Synchronize [Remote Capabilities]
   OLAPSliceSecurity
Save Slice As dialog
   Save Slice
   Entering Data in a Slice
    following
Save Slice button
    clicking
    toolbar
Save Slice Icon
    use
Saved Page
Saves dependency information
    file
Saving intermediate
Saving Your Work
Say
    DTS
SCAN
   SCAN
   PowerOLAP Cube Formula Grammar
SCAN function
Schedule events
    take place
Scheduled
   Create a New Synchronization Server
   PowerOLAP Scheduler
   Set the Frequency of the Scheduled Job/Task
   Transfer Cube
   Continue to Next Task on Error
   When and why should you use IDS?
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Creating Notification
   Introduction to PowerOLAP SCHEDULER
   Other Task Types
   Execute a Scheduler Job
   Importing and Exporting
   Executing PowerOLAP Scheduler Job in Excel
Scheduled Job/Task
Scheduled SSIS task
Scheduler
   Other Task Types
   Process Cube for Fact or Meta Data Update
   Execute a Scheduler Job
   Creating a New JOB
   Modify or Delete Existing Jobs
   Executing PowerOLAP Scheduler Job in Excel
Scheduler Task Options
    following
SCHEMA
Schema Slice
Schema file
Screen
   The Dimension Hierarchy Toolbar
   SUMMARY: The Dimension Hierarchy Toolbar
   Select Page MembersUsing Edit Slice
   ischildof
   aggregatesum
   Installing PowerOLAP MDB Server
   Creating a Slice
   Calculation Engines
   number
   ABS
   Creating a Slice View
   Create a New Synchronization Server
   New Slice Menu & OLAPNavigate
   Remove Existing Version
   Select Row or Column Members Using Edit Slice
   parent
   Allow Duplicates
   Setting New Slice Options
   PROPERTY
   cubedimcount
   alias
   Seeing Results in PowerOLAP (.olp file)
   ROOTCOUNT
   literal
   childcount
   Building & Updating Cubes that Support Incremental Updating
   PowerOLAP's Add-In Menuand Toolbar
   aliastomember
   Creating the Measures Dimension
   Caching
   Window, Tiled or Cascading Slices
   Constraints
   Transfer Cube
   iserror
   cubedim
   Installation of the PowerOLAP Client
   PowerOLAP MDB Server Installation
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Creating a Local Database from the Synchronization Server
   Configure ODBC Data Source
   Define Drill Through
   Advanced PowerOLAP Worksheet Functions
   Slice Commands
   parentcount
   lookup
   WEIGHT
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Define Rollups / Drill-Through with Rollups
   Migrating OLP Databases with Cubes Built from OLAP Exchange,
   missing
   ismissing
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   child
   How to Create a Local Cube from a Remote Cube using IDS
   ROOT
    Dimension Hierarchy
       The Dimension Hierarchy Toolbar
       SUMMARY: The Dimension Hierarchy Toolbar
Screen captures
   Advanced PowerOLAP Worksheet Functions
   Define Rollups / Drill-Through with Rollups
    dialog
Screen indicating
   Calculation Engines
   Transfer Cube
   How to Create a Local Cube from a Remote Cube using IDS
Screens/dialog
Screenshots
    following
Scrollbars
Search button
    locate
Season
Sec
Sec file
SECOND
   PowerOLAP Cube Formula Grammar
   SECOND
Second Example
SECOND function
Seconds
   SECOND
   TIME
Section
   Working with OLAP Exchange as Client in a Server Scenario
   Allow Duplicates
   Working with OLAP Exchange on the MDB Server
   Modify Relational Dimension
   Seeing Results in PowerOLAP (.olp file)
   Building & Updating Cubes that Support Incremental Updating
   Creating the Measures Dimension
   Define Hierarchy Creating Dimension Hierarchies
   Importing and Exporting
   Fact Data Import Commands
   Applying Database Security
   Creating the 2nd Dimension
   Creating a Cube via OLAP Exchange
   About Fact Data in Cubes
    preceding
Section concerns
Section Import
Section on Creating
Section Working
Sections on Formulas
Secure Connection
   How to Create a Local Cube from a Remote Cube using IDS
   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
Secure Connection checkbox
   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
    check
Secure Database
   Defining Users and Groups
   Enabling a Database for Security
   Secure Database
   Creating a PowerOLAP Database
   Applying Database Security
   Accessing a Secured Database
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Security Export/Import Feature
   Create and define IDS task to Push Fact Data from a Local Cube
   Accessing the Database by a User with Read-Only Rights
   Create and define IDS task to Pull Fact Data from a Remote Cube
   OLAPCurrentUser
    Accessing
    check
    close
    leave
    Uncheck
Secure Database checkbox
   Enabling a Database for Security
   Creating a PowerOLAP Database
    Enable
Secure Existing Database
Secure New Database
Secure Socket Layer
    enable
SecureSlice
   Granting Slices Meta Security Rights
   Changes by Student in Read Write Group
   Accessing the Database by a User with Read-Only Rights
   OLAPSliceSecurity
   Administrator Changes
    Open
    rights
Security
   Create the SQL Server Login
   Security Export/Import Feature
   Enabling a Database for Security
   Assigning Meta Data Security Privileges
   Model Cubes
   Creating a Local Database from the Synchronization Server
   Secure Database
   Creating a PowerOLAP Database
   Applying Database Security
   OLAPUserInGroup
   Create/Save a Dimension Subset
   OLAPFactSecurityMember
   Introduction to the PowerOLAP MDB Server
   Defining Users and Groups
   OLAPFactSecurityRuleCount
   OLAPFactSecurityRuleName
   Member Types/ Hierarchy Dialog box
   OLAPFactSecurityRule
   OLAPDimensionSecurity
   OLAPUserGroup
   Model Dimensions
   OLAPIsSecureDatabase
   OLAPReadWrite
   OLAPChild
   Creating a Cube
   exact
   Access Privileges
   OLAPGroup
   OLAPCanAddDimensionAndCubes
   OLAPUser
   Caching
   OLAPCubeSecurity
   OLAPGroupCount
   OLAPCurrentUser
   OLAPFactSecurityMemberCount
   Add Users and Groups
   Creating a Cube
   Excel Paste Functions
   Importing and Exporting
   Fact Data Security Ranges
   Accessing a Secured Database
   OLAPUserCount
   OLAPUserGroupCount
   OLAPSliceSecurity
   OLAPFactSecurityPrivileges
   How to Create a Local Cube from a Remote Cube using IDS
   Concepts and Benefits
   Granting Slices Meta Security Rights
   Administrative Cube
   Accessing the Database by a User with Read-Only Rights
   How to Grant Database Privileges
   Active Directory Authentication
   Granting Rights to Add Dimensions and Cubes
   PowerOLAP Client Installation for Non-Admin Users
    implementing
    institute
    levels
    PowerOLAP User Manual dedicated
    User Manual dedicated
Security Dialog
   Assigning Meta Data Security Privileges
   Granting Slices Meta Security Rights
Security enabled
   OLAPDimensionSecurity
   OLAPCurrentUser
Security Error
Security Export/Import
   Security Export/Import Feature
   Applying Database Security
Security Export/Import Feature
   Security Export/Import Feature
   Applying Database Security
Security Grammar
Security pertaining
Security Privileges
   Introduction to the PowerOLAP MDB Server
   Secure Database
   Accessing a Secured Database
   Create/Save a Dimension Subset
   OLAPDimensionSecurity
   Model Dimensions
   Assigning Meta Data Security Privileges
   OLAPChild
   OLAPCanAddDimensionAndCubes
   OLAPCubeSecurity
   Add Users and Groups
   Creating a Cube
   Excel Paste Functions
   Importing and Exporting
   OLAPSliceSecurity
   OLAPFactSecurityPrivileges
   Enabling a Database for Security
Security Privileges assigned
   Introduction to the PowerOLAP MDB Server
   Add Users and Groups
   Accessing a Secured Database
    clients
    group
Security ranges
   OLAPFactSecurityRuleCount
   OLAPFactSecurityRuleName
   OLAPFactSecurityRule
   Excel Paste Functions
   Access Privileges
   Caching
   Fact Data Security Ranges
Security Rule
SecurityRule
See PowerOLAP User Manual
See results
   Define Order
   Entering Data in a Slice
    Let's now proceed
See Values
Select
   Select Page MembersUsing Edit Slice
   Creating a Slice
   Create a New Linked Cube
   Creating a Slice View
   New Slice Menu & OLAPNavigate
   Select Row or Column Members Using Edit Slice
   Assigning Meta Data Security Privileges
   Formula Basics
   Selecting Page Members
   Granting Cube Security Rights
   OLAPPivot
   OLAPFormula
   Cross-Cube Formula
   Window, Tiled or Cascading Slices
   Caching
   IDS - Internet Explorer Caching Setting
   Drill-Up/ Drill-Down Aggregate members in Rows and Columns
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Creating Notification
   OLAPWriteMemberToCube
   Entering Data in a Slice
   Internal Cube Formula
   Selecting a Page Member to View in Excel
   Modify or Delete Existing Jobs
   Secure Database
   Importing and Exporting
   Creating Cube Formulas
   Restoring a Database
   Accessing a Secured Database
   OLAPIsFormula
   Assigning Database Privileges
   Changing Data Views from within Excel
   Database Reference Formulas
   Importing Data from a File
   Partial Server Use for Database Creation from a Synchronization Server
    Alternate
    clicking
    Edit
       Creating a Slice View
       Modify or Delete Existing Jobs
    enabling
    Event
    Financials
    Insert
       OLAPFormula
       OLAPIsFormula
    Last Months
    LDV
    Margin
    OK
    OK button
    Products
    Refresh button
    Sales
    Set
    Settings button
    Total Year
    Window menu
    World
    Yes
Select 1st Quarter
Select Add
Select Alternate Cubes
Select Canada
Select City
   Change Hierarchy
   Change Properties
Select ContactName
Select ContactTitle
Select Cube
Select CustomerID
Select Customers
   Change Aliases
   Change Properties
Select Deepest Items
Select Dimension Attributes dialog
Select Dimensions
   Create a New Linked Cube
   Model Cubes
   Changing Data Views from within Excel
Select Dimensions dialog
   Create a New Linked Cube
   Creating the Measures Dimension
   Creating the 3rd and Further Dimensions
   Changing Data Views from within Excel
   Creating the 2nd Dimension
Select Discontinued
Select Done
   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 Edit
   Slice View Formatting
   General Tab
   Database Reference Formulas
Select Edit Weights
Select Items
Select January
   Creating a Dimension Hierarchy
   Creating Cube Formulas
Select Margin
   Internal Cube Formula
   Creating Cube Formulas
Select menu
Select Months
   Creating Cube Formulas
   Arranging Slice Dimensions
Select New Login
Select OK
   Configuring PowerOLAP Server Service to Logon as User Account
   OLAPPivot
   Importing and Exporting
Select PowerOLAP
   OLAPRenameProperty
   OLAPWriteAliasToCube
   OLAPTable
   OLAPPivot
   OLAPRenameAlias
   OLAPNavigate
   OLAPAlias
   OLAPWriteMemberToCube
   OLAPFactSecurityMemberCount
   OLAPQuery
   OLAPFactSecurityPrivileges
Select PowerOLAP, Import - Process Entire File
Select PowerOLAP, Import - Process Next Line
Select PowerOLAP, Select
Select ProductName
Select Products
Select Quantity
Select Regions
Select Register
Select Row
Select Slice, Edit
Select Slice, New
   Creating a Slice View
   Cube Properties
   Entering Data in a Slice
Select Slice, Open
   Accessing the Database by a User with Read-Only Rights
   Importing and Exporting
   Slice Commands
   Importing Data from a File
Select Source
Select Subset dialog
Select Tab, Comma
Select the Specify Member Weights toolbar button
Select Tile
Select Total Year
   Creating a Dimension Hierarchy
   Changing the Grid Layout
Select UnitPrice
Select User dialog
    succeeding
Select User Directory
Select Users
   Granting Slices Meta Security Rights
   Granting Cube Security Rights
   Granting Dimensions Meta Security Rights
   Active Directory Authentication
Selected button
    use
Selected Dimension
   Select Page MembersUsing Edit Slice
   Create a New Linked Cube
   Security Export/Import Feature
   New Slice Menu & OLAPNavigate
   OLAPPivot
   Creating the Measures Dimension
   Model Cubes
   Creating the 3rd and Further Dimensions
   Creating a Cube
   Changing Data Views from within Excel
   Creating the 2nd Dimension
   The Edit Slice Dialog Box
Selecting Subset
SemiColon
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
Separate databases
September
   Creating a Dimension Hierarchy
   Zero Suppression
September 24
Serial
   WEEKDAY
   date
   SECOND
   TIMESTRING
   YEAR
Serial Date
   WEEKDAY
   date
   month
   SECOND
   day
   TIMESTRING
   minute
   YEAR
   hour
Serial Number
   char
   now
   month
   SECOND
   day
   TIME
   TODAY
   minute
   hour
Serial_number
   WEEKDAY
   month
   SECOND
   day
   TIMESTRING
   minute
   YEAR
   hour
Serial_number argument
   month
   SECOND
   day
   minute
   hour
Series
Server
   Working with OLAP Exchange as Client in a Server Scenario
   Introduction to the PowerOLAP MDB Server
   To add a database to the Server:
   Create a New Linked Cube
   Create the SQL Server Login
   Create a New Synchronization Server
   Remove Existing Version
   Creating a Task (Internet Data Services)
   PowerOLAP Version 8 MDB Server Installation
   PowerOLAP Service Control Program
   Working with OLAP Exchange on the MDB Server
   DBREAD
   Creating a Cube from the MDB Server Control Program
   Transaction Log
   Creating a Local Database from the Synchronization Server
   Configure ODBC Data Source
   General Tab
   Register and Activate the PowerOLAP Version 8 Server
   Advanced PowerOLAP Worksheet Functions
   DBREADWRITE
   CUBEREADWRITE
   Adding a Server from within PowerOLAP
   Creating a PowerOLAP Database
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Migrating OLP Databases with Cubes Built from OLAP Exchange,
   Server Mode - PowerOLAP as Server to Analysis Services Cubes
   Accessing a Secured Database
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Register and Activate the PowerOLAP Client
   asread
   Installing PowerOLAP MDB Server
   oledbreadwrite
   Make Changes On-line and then Synchronize
   OLAPSave
   Setting New Slice Options
   Exercises
   Create and define IDS task to Push Fact Data from a Local Cube
   OLAPDatabase/OLAPOpen
   Installation of the PowerOLAP Client
   IDS
   oledbread
   When and why should you use IDS?
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Additional Information
   Excel Paste Functions
   Restoring a Database
   User Considerations
   How to Create a Local Cube from a Remote Cube using IDS
   asreadwrite
   OLAPNavigate
   Active Directory Authentication
   MDX
   PowerOLAP Server Installation for Non-Admin Users
   OLAPQuery
   Set 3GB Startup Switch in Windows
   Enable Diagnostic Logging
   OLAPNavigateRW
   PowerOLAP Client Installation for Non-Admin Users
   Concepts and Benefits
    Add
    connects
    IPAddress
    Local
       Working with OLAP Exchange on the MDB Server
       Migrating OLP Databases with Cubes Built from OLAP Exchange,
    Microsoft Analysis Services
    PowerOLAP database residing
       dbread
       dbreadwrite
    RAM
    select
    Specify
    Start / Stop
    type in
    use
Server Control Program
   PowerOLAP Service Control Program
   Creating a Cube from the MDB Server Control Program
   Transaction Log
   PowerOLAP Server Installation for Non-Admin Users
Server CPU
Server Environment
Server happens
Server Installation
Server Mode
   Server Mode - PowerOLAP as Server to Analysis Services Cubes
   Creating a PowerOLAP Database
Server Properties Dialog
Server Roles
Server Scenario
Server Status
Server that is
    name of
Servername
Service
   Installing PowerOLAP MDB Server
   Introduction to the PowerOLAP MDB Server
   Configuring PowerOLAP Server Service to Logon as User Account
   Register and Activate the PowerOLAP Server
   MDX
   PowerOLAP Server Installation for Non-Admin Users
Service Control Program
   Introduction to the PowerOLAP MDB Server
   Create a New Synchronization Server
   Transaction Log
   Restoring a Database
   PowerOLAP Service Control Program
   Enable Diagnostic Logging
Service Control Program dialog
Service during
Service Status
Services dialog
    back
Services Icon
   Installing PowerOLAP MDB Server
   Configuring PowerOLAP Server Service to Logon as User Account
    clicking
Set
   Creating a Cube
   Set the Frequency of the Scheduled Job/Task
   Importing and Exporting
   Set 3GB Startup Switch in Windows
    Frequency
    selected
Set 3GB Startup Switch in Windows
Set Import File
Set Options
   Grid Shortcut Menu Options
   Extended Drill-Through
Set Page Member
   Select Page MembersUsing Edit Slice
   Selecting Page Members
   The Edit Slice Dialog Box
Set Page Member button
Set selected
Setting General Preferences
Settings
   Configuring PowerOLAP Server Service to Logon as User Account
   PowerOLAP Service Control Program
   Configure ODBC Data Source
   MDX
   Set 3GB Startup Switch in Windows
   Enable Diagnostic Logging
Settings button
    select
Setup
Several enhancements
Share
   Introduction to the PowerOLAP MDB Server
   Creating the Measures Dimension
   Transfer Cube
   When and why should you use IDS?
   Creating a Local Database from the Synchronization Server
   Additional Information
   Entering Data in a Slice
   Assigning Fact Data Security Privileges
   Importing and Exporting
   Creating a PowerOLAP Database
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Applying Database Security
   Creating the 2nd Dimension
   Concepts and Benefits
Shared Dimension
   Additional Information
   Creating the 2nd Dimension
Sharing characteristics
Shift
   Defining Users and Groups
   Select Row or Column Members Using Edit Slice
   Create Dimension Hierarchy
   Importing and Exporting
Shift key
   Creating a Dimension Hierarchy
   Granting Cube Security Rights
    holding
ShippingDate
Short-Cut Menus
   Short-Cut Menus for the Grid
   General Formatting and Printing
    Grid
Short-Cut Menus for
    Grid
Short-cut menus options
Show Grid
Show Marker
   Dynamic Multidimensional Graphs
   Graph's Shortcut menu options
Show Marker Option
Show value
Show Value Option
Showing
   Entering Data from within Excel
   Transfer Cube
   Dynamic Multidimensional Graphs
   Assigning Fact Data Security Privileges
   Creating Cube Formulas
   Changing Data Views from within Excel
    Actual VS
    Canada
    Margin
    Month
    Unit Cost
Showing results
Sibling
   The Dimension Hierarchy Toolbar
   SUMMARY: The Dimension Hierarchy Toolbar
   Create Dimension Hierarchy
    Members
       The Dimension Hierarchy Toolbar
       Create Dimension Hierarchy
SIGN
   SIGN
   PowerOLAP Cube Formula Grammar
    ascertaining
    value
    written
SIGN function
Signifiers
Signifies that
   OLAPMember
   OLAPMemberNext
Signifying
    East Coast
Simple Transfer Cube Task
    Creating
Simplified Chinese
Simply uncheck all
SIN
   SIN
   PowerOLAP Cube Formula Grammar
SIN function
Since
Since Best Mexican Restaurants
Since Revenue figures
Sine
   asin
   SIN
Single Quote
Situated
Six-dimensional Cube
    build
Size
   Designer Slices can be Fully Formatted and Printed
   Slice View Formatting
Skip Aggregates
   IDS Performance Considerations
   Transfer Cube
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Importing and Exporting
Skip Calculated Values
   IDS Performance Considerations
   Transfer Cube
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Importing and Exporting
Skip Zero
   IDS Performance Considerations
   Transfer Cube
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Importing and Exporting
    choose
SLCom
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
Slice
   Create/Save a Dimension Subset
   Select Page MembersUsing Edit Slice
   Excel Integration
   Entering Data from within Excel
   Settings General & Format Preferences
   Create a New Linked Cube
   Creating a Slice
   Calculation Engines
   Stack or Nest Dimensions
   General Formatting and Printing
   Creating a Slice View
   Client Mode - PowerOLAP as Client to Analysis Services Cubes
   Save Slice
   Grid Shortcut Menu Options
   Member Types/ Hierarchy Dialog box
   New Slice Menu & OLAPNavigate
   Dependencies
   Select Row or Column Members Using Edit Slice
   Assigning Meta Data Security Privileges
   OLAPReadWrite
   Granting Slices Meta Security Rights
   Format Tab
   Process Cube for Fact or Meta Data Update
   Setting New Slice Options
   Saving Changes to a Database
   Selecting Page Members
   Cube Properties
   OLAPPivot
   Zero Suppression
   Closing a Database
   Using Slices to Navigate Cubes
   Create and define IDS task to Push Fact Data from a Local Cube
   Define Order
   Caching
   Entering Data through an Excel Worksheet
   Constraints
   Window, Tiled or Cascading Slices
   Transfer Cube
   Slice View Formatting
   Changing the Grid Layout
   The Edit Slice Dialog Box
   Model Cubes
   Drill-Up/ Drill-Down Aggregate members in Rows and Columns
   Accessing the Database by a User with Read-Only Rights
   Creating an Excel Worksheet
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Saving / Launching PowerOLAP Databases from within Excel
   Grid features Drill-Down on Members and Data within the Slice
   General Tab
   How to Update the Fact Data of Local Cube from Remote Cube
   Entering Data in a Slice
   Rearranging Dimensions within a Slice
   Dynamic Multidimensional Graphs
   Entering Data in a Slice
   Secure Database
   Excel Paste Functions
   Assigning Fact Data Security Privileges
   Slice Commands
   Importing and Exporting
   Restoring a Database
   Administrator Changes
   Creating a PowerOLAP Database
   Creating Cube Formulas
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Add/Delete Members in Measures Dimension
   Define Rollups / Drill-Through with Rollups
   Fact Data Import Commands
   Summary of Quick Start Exercises
   Extended Drill-Through
   Calculation Depth
   Database Reference Formulas
   Quick Start Introduction
   Importing Data from a File
   Arranging Slice Dimensions
   Hierarchy
   User Considerations
   Introduction to PowerOLAP's Persistent Calculations
   How to Create a Local Cube from a Remote Cube using IDS
   About Fact Data in Cubes
   Paste and Drill-Through Functions
   OLAPFactSecurityMember
   OLAPCubeDimCount
   OLAPAliasToMember
   current
   OLAPTable
   OLAPWriteAliasToCube
   OLAPFactSecurityRuleCount
   oledbreadwrite
   now
   OLAPFactSecurityRuleName
   OLAPSubsetCount
   OLAPFactSecurityRangeMembers
   OLAPFactSecurityRule
   OLAPDimensionSecurity
   OLAPCubeDimension
   OLAPUserGroup
   OLAPParentCount
   OLAPMemberToAlias
   OLAPMemberNext
   OLAPTable
   OLAPDimension
   OLAPIsSecureDatabase
   OLAPAliasGroupCount
   OLAPMember
   OLAPRead
   OLAPPivot
   OLAPMemberIndex
   OLAPFactSecurityStatus
   OLAPChild
   OLAPSubsetMemberCount
   OLAPAliasGroup
   OLAPReadWrite
   OLAPWrite
   OLAPDimMaxLevel
   Access Privileges
   OLAPParent
   OLAPMemberProperty
   OLAPMemberLevel
   OLAPDimCount
   OLAPGroup
   OLAPCanAddDimensionAndCubes
   OLAPUser
   RAND
   OLAPCubeSecurity
   OLAPMemberFirst
   Creating an Excel Worksheet
   OLAPGroupCount
   OLAPCube
   OLAPCubeCount
   OLAPSubset
   OLAPSubsetMember
   OLAPPropertyGroup
   Add to or Remove Members from a Subset
   OLAPCurrentUser
   OLAPAlias
   currentindex
   Advanced PowerOLAP Worksheet Functions
   Internal Cube Formula
   OLAPFactSecurityMemberCount
   OLAPIsChildOf
   OLAPIsParentOf
   TODAY
   dbreadwrite
   OLAPMemberCount
   OLAPChildCount
   OLAPMemberType
   OLAPRoot
   OLAPWeight
   OLAPUserCount
   OLAPUserGroupCount
   OLAPPropertyGroupCount
   Changing Data Views from within Excel
   OLAPSliceSecurity
   OLAPFactSecurityPrivileges
   OLAPUserInGroup
   OLAPRootCount
   OLAPRenameProperty
   Dependencies
   OLAPRenameMember
   OLAPRenameAlias
   OLAPNavigate
   Administrative Cube
   OLAPFormula
   Active Directory Authentication
   OLAPWriteMemberToCube
   OLAPIsFormula
   OLAPNavigateRW
   PowerOLAP Client Installation for Non-Admin Users
    alter
    arrange
    beginning
    Builds
    can configure
    changes
       Creating a Slice View
       Entering Data in a Slice
       Slice Commands
    changes made
       Saving Changes to a Database
       Slice Commands
    check
    close
       Slice Commands
       Define Rollups / Drill-Through with Rollups
    comparing
    create
       Cube Properties
       Create and define IDS task to Push Fact Data from a Local Cube
       The Edit Slice Dialog Box
       Summary of Quick Start Exercises
       How to Create a Local Cube from a Remote Cube using IDS
    Creating
       Creating a Slice
       Creating a Slice View
       New Slice Menu & OLAPNavigate
    Cube
       Excel Integration
       Assigning Meta Data Security Privileges
    Data within
    delete
       Entering Data in a Slice
       Slice Commands
    Example
    Excel
       Client Mode - PowerOLAP as Client to Analysis Services Cubes
       Saving / Launching PowerOLAP Databases from within Excel
    existing
    function
    give
    group
    launch
    make
    Margin
    name
       Select Page MembersUsing Edit Slice
       Importing and Exporting
    Open
       Slice View Formatting
       Entering Data in a Slice
       Add/Delete Members in Measures Dimension
    Product Cube
    Products
    Recalculate
    reopen
    representations
    resulting
    return
       Select Page MembersUsing Edit Slice
       Select Row or Column Members Using Edit Slice
       Cube Properties
       Hierarchy
    Revenue
    right
    save
       General Formatting and Printing
       Grid Shortcut Menu Options
       Slice Commands
       Make Changes Offline and then Synchronize [Remote Capabilities]
    Select
       Assigning Meta Data Security Privileges
       Granting Slices Meta Security Rights
       Window, Tiled or Cascading Slices
       Slice Commands
    shows
    viewing
    want
    Within
Slice Cell
   Entering Data in a Slice
   Assigning Fact Data Security Privileges
Slice Commands
Slice configured
Slice containing
Slice Content
   Create/Save a Dimension Subset
   Select Page MembersUsing Edit Slice
   Select Row or Column Members Using Edit Slice
   The Edit Slice Dialog Box
   Add to or Remove Members from a Subset
   Selecting Page Members
   Cube Properties
   Changing the Grid Layout
   Entering Data in a Slice
Slice Content list
   Create/Save a Dimension Subset
   Select Page MembersUsing Edit Slice
   Select Row or Column Members Using Edit Slice
   Selecting Page Members
   Cube Properties
   Changing the Grid Layout
   The Edit Slice Dialog Box
   Entering Data in a Slice
Slice Dialogs
   Assigning Meta Data Security Privileges
   Granting Slices Meta Security Rights
   Slice Commands
Slice Dimensions
   Arranging Slice Dimensions
   Summary of Quick Start Exercises
    Arranging
Slice Fact Data
Slice forces
Slice Grid Features
Slice in
   General Formatting and Printing
   Excel Integration
   oledbreadwrite
   How to Update the Fact Data of Local Cube from Remote Cube
   Entering Data in a Slice
   dbreadwrite
   Excel Paste Functions
   Slice Commands
   Fact Data Import Commands
   OLAPNavigateRW
   OLAPSliceSecurity
Slice list
   Slice Commands
   Importing Data from a File
Slice Menu
   Creating a Slice
   Zero Suppression
   Transfer Cube
   Model Cubes
   Entering Data in a Slice
   Slice Commands
   Dynamic Multidimensional Graphs
   Administrative Cube
    Use
Slice Menu/Graph
Slice Meta
   Assigning Meta Data Security Privileges
   Granting Slices Meta Security Rights
   Access Privileges
Slice Meta Data Privilege
Slice Meta Data Security
    Users
Slice Name
   Creating a Slice View
   Fact Data Import Commands
   OLAPSliceSecurity
   Arranging Slice Dimensions
   Window, Tiled or Cascading Slices
Slice rearranging
Slice Sales Account
Slice View
   Creating a Slice View
   Select Row or Column Members Using Edit Slice
   Zero Suppression
   Slice View Formatting
   Constraints
   The Edit Slice Dialog Box
   Model Cubes
   Entering Data in a Slice
   Slice Commands
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Importing Data from a File
   Quick Start Introduction
Slice View dialog
Slice View Formatting
Slices Meta Security
   Granting Slices Meta Security Rights
   Access Privileges
Slices Meta Security Rights
    Granting
Slices Security Rights
Small
    Big
Software
Source
   Process Cube (Rebuild Cube)
   Creating Cube Formulas
   Incremental Update vs. Update from Source
   Additional Considerations for Data Preparation
   Paste and Drill-Through Functions
   asread
   Create a New Linked Cube
   oledbreadwrite
   cuberead
   Create a New Synchronization Server
   Creating a Cube
   Process Cube for Fact or Meta Data Update
   dbread
   Benefits Summary
   Building & Updating Cubes that Support Incremental Updating
   Creating the Measures Dimension
   Caching
   Transfer Cube
   oledbread
   Update Linked Cube
   When and why should you use IDS?
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Configure ODBC Data Source
   Grid features Drill-Down on Members and Data within the Slice
   General Tab
   Additional Information
   dbreadwrite
   Importing and Exporting
   lookup
   memberindex
   cubereadwrite
   Fact Data Import Commands
   Extended Drill-Through
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Quick Start Introduction
   Conditional Retrieval
   User Considerations
   Creating the 2nd Dimension
   Triggers and their use for Incremental Updating
   Mark Member as Persistent
   asreadwrite
   Other Task Types
   MDX
Source Cube
   Transfer Cube
   Create and define IDS task to Pull Fact Data from a Remote Cube
   asread
   Create a New Linked Cube
   oledbreadwrite
   cuberead
   dbread
   oledbread
   Update Linked Cube
   dbreadwrite
   lookup
   cubereadwrite
   Creating Cube Formulas
   asreadwrite
    Specify
Source Data Point
    Defining
Source from
Source Tables
   Process Cube (Rebuild Cube)
   Process Cube for Fact or Meta Data Update
   Incremental Update vs. Update from Source
   Triggers and their use for Incremental Updating
   Creating the Measures Dimension
Source tables/views
   Process Cube for Fact or Meta Data Update
   Incremental Update vs. Update from Source
Sources direct
South America
   Calculation Engines
   Member Types/ Hierarchy Dialog box
   Creating a Dimension Hierarchy
Southwest
Spanish
Specific Functions
Specifically
Specified dimension within
Specified areas
Specified counting
Specified deriving
   lower
   upper
Specified dimension
Specified during
Specified number
Specified range
   OLAPPivot
   OLAPNavigate
   Excel Paste Functions
   OLAPNavigateRW
Specified string
   lower
   upper
Specified TRUE
Specifies a
Specifies that the
Specify
   ASREAD
   Create a New Synchronization Server
   OLAPPivot
   Creating a Cube
   Zero Suppression
   Create and define IDS task to Push Fact Data from a Local Cube
   Define Links—Snowflake Schema
   Creating the Measures Dimension
   Cross-Cube Formula
   Transfer Cube
   Creating a Local Database from the Synchronization Server
   The OLAPPivot Function
   Add Users and Groups
   Assigning Fact Data Security Privileges
   Define Links—Star Schema
   User Considerations
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   How to Create a Local Cube from a Remote Cube using IDS
   ASREADWRITE
   OLAPRootCount
   OLAPUserInGroup
   IDS Performance Considerations
   Meta Data Import Commands
   Member Aliases & Alias Groups
   OLAPFactSecurityMember
   OLAPCubeDimCount
   WEEKDAY
   OLAPAliasToMember
   current
   ischildof
   aggregatesum
   char
   OLAPTable
   OLAPWriteAliasToCube
   Create the SQL Server Login
   OLAPFactSecurityRuleCount
   number
   levelcount
   log
   member
   oledbreadwrite
   OLAPFactSecurityRuleName
   cuberead
   len
   OLAPSubsetCount
   The Dimension Hierarchy Toolbar
   OLAPFactSecurityRangeMembers
   Formula Syntax and Terminology
   Member Types/ Hierarchy Dialog box
   pmt
   OLAPFactSecurityRule
   SIN
   OLAPCubeDimension
   OLAPUserGroup
   OLAPParentCount
   OLAPMemberToAlias
   OLAPMemberNext
   Dependencies
   SIGN
   OLAPDimension
   OLAPIsSecureDatabase
   OLAPAliasGroupCount
   OLAPMember
   date
   OLAPSave
   OLAPMemberIndex
   Property Groups
   parent
   SQRT
   mid
   SUBSTITUTE
   membercount
   OLAPFactSecurityStatus
   OLAPChild
   OLAPSubsetMemberCount
   Aggregate Weights
   Allow Duplicates
   Configuring PowerOLAP Server Service to Logon as User Account
   Formula Basics
   SUMMARY: The Dimension Hierarchy Toolbar
   PROPERTY
   REPLACE
   RIGHT
   SCAN
   OLAPAliasGroup
   cubedimcount
   IF
   alias
   Granting Cube Security Rights
   OLAPWrite
   OLAPPivot
   ROOTCOUNT
   month
   OLAPDimMaxLevel
   dbread
   exact
   childcount
   code
   OLAPParent
   OLAPMemberProperty
   OLAPMemberLevel
   Building & Updating Cubes that Support Incremental Updating
   PowerOLAP Cube Formula Grammar
   Aggregate Weights
   PPMT
   lower
   OLAPDimCount
   OLAPGroup
   OLAPCanAddDimensionAndCubes
   level
   fv
   aliastomember
   OLAPUser
   Dependencies Grammar
   Caching
   REPT
   OLAPCubeSecurity
   iserror
   AND
   cubedim
   OLAPDatabase/OLAPOpen
   OLAPMemberFirst
   The Edit Slice Dialog Box
   Creating Cube Formulas
   oledbread
   OLAPGroupCount
   OLAPCube
   OLAPCubeCount
   find
   Transaction Log
   How to Grant Database Privileges
   OLAPSubset
   OLAPSubsetMember
   OLAPPropertyGroup
   Create and define IDS task to Pull Fact Data from a Remote Cube
   PROPER
   ln
   OLAPCurrentUser
   OLAPAlias
   currentindex
   day
   Additional Information
   Advanced PowerOLAP Worksheet Functions
   OR
   OLAPFactSecurityMemberCount
   OLAPIsChildOf
   OLAPIsParentOf
   TIME
   dbreadwrite
   upper
   OLAPMemberCount
   Excel Paste Functions
   Importing and Exporting
   parentcount
   ROUND
   lookup
   memberindex
   TRIM
   WEIGHT
   OLAPChildCount
   cubereadwrite
   Creating Cube Formulas
   Restoring a Database
   OLAPMemberType
   OLAPRoot
   Migrating OLP Databases with Cubes Built from OLAP Exchange,
   Applying Database Security
   Fact Data Import Commands
   YEAR
   int
   exp
   OLAPWeight
   OLAPUserCount
   OLAPUserGroupCount
   OLAPPropertyGroupCount
   Extended Drill-Through
   Database Reference Formulas
   Calculation Depth
   PV
   min
   ismissing
   OLAPSliceSecurity
   mod
   OLAPFactSecurityPrivileges
   ipmt
   child
   Triggers and their use for Incremental Updating
   About Fact Data in Cubes
   ROOT
   max
   left
   OLAPRenameProperty
   Dependencies
   OLAPRenameMember
   Other Task Types
   Synchronization Server database in SQL Server
   OLAPRenameAlias
   OLAPNavigate
   OLAPFormula
   Active Directory Authentication
   OLAPWriteMemberToCube
   MDX
   OLAPQuery
   OLAPIsFormula
   OLAPNavigateRW
    Database Name
    Dependency
    Destination Cube
    Dimension Name
       Define Links—Snowflake Schema
       Define Links—Star Schema
    File Name
    Member Name
    Members
    Name
    ODBC
    range of
    Rows
       OLAPPivot
       The OLAPPivot Function
    Server
    Source Cube
    User Name
    user needs
    username
       Creating a Cube
       Create and define IDS task to Push Fact Data from a Local Cube
       How to Create a Local Cube from a Remote Cube using IDS
    we need
    Where
Specify Data Security Access Levels dialog
    close
Specify evaluates
    TRUE
Specify Member Weights
   The Dimension Hierarchy Toolbar
   Aggregate Weights
   SUMMARY: The Dimension Hierarchy Toolbar
   Aggregate Weights
Specify Member Weights toolbar button
    select
Specify nesting
   OLAPPivot
   The OLAPPivot Function
Specify USA
Spreadsheet
   Entering Data from within Excel
   Creating a Slice View
   Cube Formula Functions
   OLAPReadWrite
   OLAPPivot
   Closing a Database
   Benefits Summary
   About PowerOLAP Services
   Creating an Excel Worksheet
   Saving / Launching PowerOLAP Databases from within Excel
   General Tab
   Entering Data in a Slice
   Advanced PowerOLAP Worksheet Functions
   Excel Functions List
   Concepts and Benefits / Requirements
   Executing Cube Tasks in Excel
   Excel Integration
   New Slice Menu & OLAPNavigate
   Setting New Slice Options
   Creating an Excel Worksheet
   The OLAPPivot Function
   Executing PowerOLAP Scheduler Job in Excel
   OLAPNavigateRW
Sq
SQL
   Use SQL Views
   Configuring the MDB Server for OLAP Exchange
   Create the User Domain Account in the Active Directory
   Concepts and Benefits / Requirements
   Create the SQL Server Login
   Other Task Types
   Creating a Cube
   Working with OLAP Exchange on the MDB Server
   Requirements and Recommendations
   Configure ODBC Data Source
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Conditional Retrieval
   Hierarchy
   Creating a Cube via OLAP Exchange
   Triggers and their use for Incremental Updating
   Databases Supported for Use with OLAP Exchange
   Create a New Synchronization Server
   Synchronization Server database in SQL Server
   Process Cube for Fact or Meta Data Update
   Creating a Local Database from the Synchronization Server
   Requirements and Recommendations
   Concepts and Benefits
    create
SQL Packages
SQL Server
   Create the SQL Server Login
   Creating a Cube
   Configuring the MDB Server for OLAP Exchange
   Requirements and Recommendations
   Configure ODBC Data Source
   Hierarchy
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Creating a Cube via OLAP Exchange
   Triggers and their use for Incremental Updating
   Other Task Types
   Create a New Synchronization Server
   Synchronization Server database in SQL Server
   Process Cube for Fact or Meta Data Update
   Creating a Local Database from the Synchronization Server
   Requirements and Recommendations
   Concepts and Benefits
    Microsoft
    NT
    rights
    running
    Select
    underlying
SQL Server Authentication
   Create a New Synchronization Server
   Creating a Local Database from the Synchronization Server
SQL Server Management Studio
   Create the SQL Server Login
   Synchronization Server database in SQL Server
SQL Server Management Studio dialog
SQL Sever
SQRT
   SQRT
   PowerOLAP Cube Formula Grammar
SQRT function
Square
SQuoteString
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
SQuoteStringEnd
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
SS
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
Ssame
SSIS
Stack
   Stack or Nest Dimensions
   New Slice Menu & OLAPNavigate
   Window, Tiled or Cascading Slices
   Dynamic Multidimensional Graphs
   OLAPNavigate
    Dimensions
Stacked Bar
Stacked bar Chart
Staff Date Lookup
   WEEKDAY
   now
   date
   month
   SECOND
   day
   TIME
   TODAY
   minute
   YEAR
   hour
Staff.'Last Name
Stages
   Building & Updating Cubes that Support Incremental Updating
   missing
    Cube
Standalone
Standalone machine
Standard
   Register and Activate the PowerOLAP Version 8 Client
   char
   Calculation Engines
   New Slice Menu & OLAPNavigate
   Other Task Types
   Introduction to Formula Basic, Cube Formulas, Dependencies &
   Aggregate Weights
   Formula Basics
   code
   PowerOLAP Cube Formula Grammar
   Aggregate Weights
   Create a Time Dimension
   Transfer Cube
   IDS
   Preparing Relational Data for Use with OLAP Exchange
   Dynamic Multidimensional Graphs
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Working with ODBC (Open Database Connectivity)
   Active Directory Authentication
   MDX
   Set 3GB Startup Switch in Windows
   PowerOLAP Client Installation for Non-Admin Users
Standard Edition
Standard PowerOLAP License
   Register and Activate the PowerOLAP Version 8 Client
   PowerOLAP Client Installation for Non-Admin Users
    Select
Standard Windows ODBC
Stands
    Avon Trading Company
Start / Stop
    Server
Start button
   Installing PowerOLAP MDB Server
   Configuring PowerOLAP Server Service to Logon as User Account
   Creating a Cube from the MDB Server Control Program
   Define Links—Star Schema
   Remove Existing Version
   PowerOLAP Service Control Program
Start menu
   Create the SQL Server Login
   Register and Activate the PowerOLAP Version 8 Client
   Configuring PowerOLAP Server Service to Logon as User Account
   Creating a Cube from the MDB Server Control Program
   Create the User Domain Account in the Active Directory
   Configure ODBC Data Source
   Register and Activate the PowerOLAP Version 8 Server
   Creating a PowerOLAP Database
   Installation of PowerOLAPCOM
   PowerOLAP Server Installation for Non-Admin Users
   PowerOLAP Client Installation for Non-Admin Users
Started
   Installing PowerOLAP MDB Server
   Installation of PowerOLAPCOM
   Creating Notification
   Creating a PowerOLAP Database
Starting with
STARTINLINE
    EndInline
StartInline command
StartNull
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
Startup
State
   len
   mid
Status
Steps
    preceding
Steps required
    discussion concerns
Stop button
Stopped
   Remove Existing Version
   Configuring PowerOLAP Server Service to Logon as User Account
Storage and
   OLAPSave
   OLAPDatabase/OLAPOpen
Store
Stored within Cubes
Straightforward
   The Edit Slice Dialog Box
   Importing and Exporting
Straightforward specification
    complex regions
String
   char
   Dependencies Grammar Definition
   code
   exact
   PowerOLAP Cube Formula Grammar
   lower
   upper
   About Fact Data in Cubes
String Data Manipulations
   char
   len
   SUBSTITUTE
   mid
   RIGHT
   SCAN
   REPLACE
   code
   exact
   lower
   REPT
   find
   PROPER
   upper
   TRIM
   left
Structure
   Excel Functions List
   Database Reference Formulas
   current
   Create a New Linked Cube
   levelcount
   oledbreadwrite
   Creation of Ragged and Multiple Hierarchies
   OLAPRead
   Creating a Cube
   Process Cube for Fact or Meta Data Update
   OLAPReadWrite
   Modify Relational Dimension
   ROOTCOUNT
   Building & Updating Cubes that Support Incremental Updating
   PowerOLAP Cube Formula Grammar
   level
   Cross-Cube Formula
   Transfer Cube
   Granting Dimensions Meta Security Rights
   The Edit Slice Dialog Box
   Drill-Up/ Drill-Down Aggregate members in Rows and Columns
   Create Dimension Hierarchy
   dbreadwrite
   Importing and Exporting
   OLAPMemberType
   Changing Data Views from within Excel
   Conditional Retrieval
   How to Create a Local Cube from a Remote Cube using IDS
   Triggers and their use for Incremental Updating
   ROOT
   asreadwrite
   MDX
    Database Reference Formulas
    Database References
Subset
   Create/Save a Dimension Subset
   Member Types/ Hierarchy Dialog box
   Dependencies Grammar Definition
   OLAPPivot
   PowerOLAP Cube Formula Grammar
   Transfer Cube
   The Edit Slice Dialog Box
   Delete a Subset
   OLAPSubsetMember
   The OLAPPivot Function
   Add to or Remove Members from a Subset
   Entering Data in a Slice
   Rename a Subset
   OLAPSubsetCount
   OLAPSubsetMemberCount
   Access Privileges
   Creating the Measures Dimension
   OLAPSubset
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Dynamic Multidimensional Graphs
   Excel Functions List
   Excel Paste Functions
   User Considerations
    access
    containing
    create
       Create/Save a Dimension Subset
       Entering Data in a Slice
    Delete
    function counts
    may select
    Members
    name
    Rename
    save
    Select
       Create/Save a Dimension Subset
       Delete a Subset
       Add to or Remove Members from a Subset
       Rename a Subset
    shows
    use
Subset Creation
   Entering Data in a Slice
   Create/Save a Dimension Subset
Subset Function
Subset list
Subset Members
   OLAPPivot
   OLAPSubsetMemberCount
   OLAPSubsetMember
Subset Tab
SUBSTITUTE
   SUBSTITUTE
   PowerOLAP Cube Formula Grammar
SUMMARY
   Select Page MembersUsing Edit Slice
   Member Types/ Hierarchy Dialog box
   SUMMARY: The Dimension Hierarchy Toolbar
   Transfer Cube
   Create Dimension Hierarchy
   Summary of Quick Start Exercises
    details
    Quick Start Exercises
Summary dialog
   Create and define IDS task to Push Fact Data from a Local Cube
   Transfer Cube
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Importing and Exporting
   Modify or Delete Existing Jobs
SUMMARY LIST
   Cube Formula Functions
   Excel Functions List
    Excel Functions
    PowerOLAP Cube Formula Functions
Summary window
   Triggers and their use for Incremental Updating
   Set the Frequency of the Scheduled Job/Task
Synched
Synchronization
   Administrator Topics
   Create a New Synchronization Server
   Seeing Results in PowerOLAP (.olp file)
   Synchronizing Changes Via Synchronization Server
   Creating a Local Database from the Synchronization Server
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Concepts and Benefits
   Triggers and their use for Incremental Updating
   Make Changes On-line and then Synchronize
   Creating a PowerOLAP Database
   Applying Database Security
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Quick Start Introduction
   Synchronization Server database in SQL Server
   PowerOLAP Service Control Program
   Requirements and Recommendations
   Partial Server Use for Database Creation from a Synchronization Server
   About Fact Data in Cubes
    configuring
    create
    defined
    existing
    Fact
    Select
Synchronization Server
   Administrator Topics
   Create a New Synchronization Server
   Make Changes On-line and then Synchronize
   Synchronizing Changes Via Synchronization Server
   Creating a Local Database from the Synchronization Server
   Creating a PowerOLAP Database
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Applying Database Security
   Quick Start Introduction
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Concepts and Benefits
   Synchronization Server database in SQL Server
   PowerOLAP Service Control Program
   Requirements and Recommendations
   Partial Server Use for Database Creation from a Synchronization Server
   About Fact Data in Cubes
    benefit
    changes
    concerning
    Configuring
    create
       Create a New Synchronization Server
       Creating a Local Database from the Synchronization Server
    Create Local Database From
    leveraging
    name
       Create a New Synchronization Server
       Creating a Local Database from the Synchronization Server
       Creating a PowerOLAP Database
    run
    Select
    triggering
Synchronization Server Manual
    see
Synchronization Server Name
Synchronization Server OSS Files
    use
Synchronization Server Selection Dialog
Synchronization Server User Manual
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   About Fact Data in Cubes
    see
Synchronize
   Make Changes On-line and then Synchronize
   Synchronizing Changes Via Synchronization Server
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Administrator Topics
   Create a New Synchronization Server
   Seeing Results in PowerOLAP (.olp file)
   Creating a Local Database from the Synchronization Server
   Creating a PowerOLAP Database
   Save Database/Save and Backup Database/Update from Synchronize
   Concepts and Benefits
    Changes Via Synchronization Server
    Meta
Synchronize menu item
Synchronize Server
Syntax
   Calculation Engines
   OLAPRootCount
   OLAPUserInGroup
   OLAPFactSecurityMember
   OLAPCubeDimCount
   WEEKDAY
   OLAPAliasToMember
   current
   ischildof
   aggregatesum
   asread
   char
   OLAPTable
   OLAPWriteAliasToCube
   OLAPFactSecurityRuleCount
   number
   levelcount
   log
   member
   oledbreadwrite
   now
   OLAPFactSecurityRuleName
   cuberead
   ABS
   len
   asin
   OLAPSubsetCount
   OLAPFactSecurityRangeMembers
   pmt
   OLAPFactSecurityRule
   SIN
   OLAPDimensionSecurity
   OLAPCubeDimension
   OLAPUserGroup
   OLAPParentCount
   OLAPMemberToAlias
   OLAPMemberNext
   SIGN
   OLAPDimension
   OLAPIsSecureDatabase
   OLAPAliasGroupCount
   OLAPMember
   date
   OLAPSave
   OLAPRead
   OLAPPivot
   OLAPMemberIndex
   parent
   SQRT
   mid
   SUBSTITUTE
   membercount
   OLAPFactSecurityStatus
   OLAPChild
   OLAPSubsetMemberCount
   Formula Basics
   PROPERTY
   REPLACE
   RIGHT
   SCAN
   OLAPAliasGroup
   cubedimcount
   IF
   acos
   alias
   OLAPReadWrite
   OLAPWrite
   ROOTCOUNT
   literal
   month
   OLAPDimMaxLevel
   dbread
   exact
   childcount
   code
   cos
   OLAPParent
   OLAPMemberProperty
   OLAPMemberLevel
   PPMT
   SECOND
   lower
   OLAPDimCount
   OLAPGroup
   OLAPCanAddDimensionAndCubes
   level
   fv
   aliastomember
   OLAPUser
   REPT
   RAND
   OLAPCubeSecurity
   iserror
   AND
   cubedim
   OLAPDatabase/OLAPOpen
   OLAPMemberFirst
   oledbread
   OLAPGroupCount
   OLAPCube
   OLAPCubeCount
   find
   atan
   OLAPSubset
   OLAPSubsetMember
   OLAPPropertyGroup
   The OLAPPivot Function
   PROPER
   ln
   OLAPCurrentUser
   TAN
   OLAPAlias
   currentindex
   day
   Advanced PowerOLAP Worksheet Functions
   Internal Cube Formula
   OR
   OLAPFactSecurityMemberCount
   OLAPIsChildOf
   OLAPIsParentOf
   TIME
   TIMESTRING
   TODAY
   Excel Functions List
   dbreadwrite
   upper
   OLAPMemberCount
   Assigning Fact Data Security Privileges
   parentcount
   ROUND
   lookup
   memberindex
   minute
   TRIM
   WEIGHT
   OLAPChildCount
   cubereadwrite
   Creating Cube Formulas
   OLAPMemberType
   OLAPRoot
   Fact Data Import Commands
   missing
   YEAR
   int
   exp
   OLAPWeight
   OLAPUserCount
   OLAPUserGroupCount
   OLAPPropertyGroupCount
   PV
   min
   ismissing
   OLAPSliceSecurity
   Introduction to PowerOLAP's Persistent Calculations
   mod
   NOT
   OLAPFactSecurityPrivileges
   hour
   ipmt
   child
   Triggers and their use for Incremental Updating
   ROOT
   max
   left
   asreadwrite
   OLAPRenameProperty
   OLAPRenameMember
   OLAPRenameAlias
   OLAPNavigate
   OLAPFormula
   OLAPWriteMemberToCube
   MDX
   OLAPQuery
   OLAPIsFormula
   OLAPNavigateRW
    Check
Sysadmin
    select
System
    Operating
System Account
   Installing PowerOLAP MDB Server
   Register and Activate the PowerOLAP Server
System Administrator
System DSN
   Configure ODBC Data Source
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
    select
System Properties dialog

>>