<<

I,u,d
I.e
   Working with OLAP Exchange as Client in a Server Scenario
   aggregatesum
   Create a New Linked Cube
   Defining Users and Groups
   Create a New Synchronization Server
   Formula Syntax and Terminology
   Dependencies
   Assigning Meta Data Security Privileges
   Aggregate Weights
   Selecting Page Members
   Cube Properties
   Changes by Student in Read Write Group
   OLAPPivot
   Define Order
   Cross-Cube Formula
   Configure ODBC Data Source
   Entering Data in a Slice
   Secure Database
   Assigning Fact Data Security Privileges
   Creating Cube Formulas
   User Considerations
   User Considerations
   Triggers and their use for Incremental Updating
I.e.the
Ice
ICON DESCRIPTION
ICON NAME
ID
   Process Cube (Rebuild Cube)
   Process Cube for Fact or Meta Data Update
   Creating a Cube
   Creating the Measures Dimension
   Configuring the MDB Server for OLAP Exchange
   Register and Activate the PowerOLAP Version 8 Server
   Adding a Server from within PowerOLAP
   PowerOLAP Service Control Program
   MDX
   Triggers and their use for Incremental Updating
    incrementing
ID Column
Identify
   Member Properties
   Extended Drill-Through
   current
   OLAPWriteAliasToCube
   Creating a Task (Internet Data Services)
   OLAPSave
   Error File Reporting
   PowerOLAP's Add-In Menuand Toolbar
   currentindex
   Importing and Exporting
   Adding a Server from within PowerOLAP
   OLAPMemberType
   missing
   Database Reference Formulas
   OLAPFactSecurityPrivileges
   Triggers and their use for Incremental Updating
   asreadwrite
   PowerOLAP Service Control Program
   OLAPNavigate
   OLAPFormula
   OLAPQuery
   OLAPIsFormula
    Field
    Member—i.e.,
IDS
   IDS Performance Considerations
   Creating a Task (Internet Data Services)
   IDS – HTTP Interface and REST
   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
   When and why should you use IDS?
   How to Update the Fact Data of Local Cube from Remote Cube
   How to Create a Local Cube from a Remote Cube using IDS
   Minimum Hardware Recommendations
   Executing Cube Tasks in Excel
   IDS - Internet Explorer Caching Setting
   MDX
    modify
    Open
    Select
       How to Update the Fact Data of Local Cube from Remote Cube
       How to Create a Local Cube from a Remote Cube using IDS
    valid purposes
IDS Client
IDS dialog
   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
    close
    show
       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
IDS Performance Considerations
IDS request
IDS Source Region
IDS Task
   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
   IDS Performance Considerations
   Creating a Task (Internet Data Services)
   Create and define IDS task to Push Fact Data from a Local Cube
   How to Update the Fact Data of Local Cube from Remote Cube
   Executing Cube Tasks in Excel
    Define
    Options
IDS Task include
IDS window
IF
   Formula Syntax and Terminology
   Cube Formula Functions
   IF
   PowerOLAP Cube Formula Grammar
   ISERROR
   AND
   Internal Cube Formula
   OR
   NOT
    creating
    includes
    use
    user
If ragged
IF Statement
   Internal Cube Formula
   Formula Syntax and Terminology
   iserror
Ignore
   Error File Reporting
   Meta Data Import Commands
   Dependencies Grammar Definition
   exact
   PowerOLAP Cube Formula Grammar
   AND
   Internal Cube Formula
   OR
   TRIM
   Incremental Update vs. Update from Source
   Fact Data Security Ranges
   Fact Data Import Commands
   Define Member Options
    Error
Ignore everything
Ignores formatting
II
   Dependencies Grammar Definition
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
IIS
Illustrates
   Member Types/ Hierarchy Dialog box
   asread
   Stack or Nest Dimensions
   oledbreadwrite
   cuberead
   New Slice Menu & OLAPNavigate
   Creating a Task (Internet Data Services)
   Dependencies
   dbread
   PowerOLAP's Add-In Menuand Toolbar
   Transfer Cube
   Model Cubes
   Drill-Up/ Drill-Down Aggregate members in Rows and Columns
   oledbread
   Dynamic Multidimensional Graphs
   dbreadwrite
   cubereadwrite
   Server Mode - PowerOLAP as Server to Analysis Services Cubes
   Accessing a Secured Database
   Database Reference Formulas
   asreadwrite
   Dependencies
    1st Quarter
    Detail
Images’
   Working with OLAP Exchange as Client in a Server Scenario
   Administrator Topics
   Create a New Synchronization Server
   Make Changes On-line and then Synchronize
   Creating a Task (Internet Data Services)
   Granting Cube Security Rights
   Installing Additional PowerOLAP Client Components
   Define Links
   Create and define IDS task to Push Fact Data from a Local Cube
   Set the Frequency of the Scheduled Job/Task
   Define Order
   Caching
   Transfer Cube
   Installation of the PowerOLAP Client
   PowerOLAP MDB Server Installation
   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
   Dynamic Multidimensional Graphs
   Add Users and Groups
   Importing and Exporting
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Conditional Retrieval
   How to Create a Local Cube from a Remote Cube using IDS
   Saving Your Work (.olt file)
   Executing Cube Tasks in Excel
   Active Directory Authentication
   Partial Server Use for Database Creation from a Synchronization Server
Implementations
   Cube Properties
   Introduction to the PowerOLAP MDB Server
   MDX
Implementing
    Security
Import
   Security Export/Import Feature
   About PowerOLAP Services
   Importing and Exporting
   Importing Data from a File
   About Fact Data in Cubes
   Meta Data Import Commands
   Benefits Summary
   Import FactData
   PowerOLAP's Add-In Menuand Toolbar
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Fact Data Import Commands
   Summary of Quick Start Exercises
   Quick Start Introduction
   How to Create a Local Cube from a Remote Cube using IDS
   Import Metadata
   Triggers and their use for Incremental Updating
   Persistent Calculations - Design Mode Option
    Data
    Fact Data
    From
    January
    Meta Data
    refer
Import Data dialog
   Importing and Exporting
   Importing Data from a File
    right
Import Database
Import Fact Data
   Importing and Exporting
   Importing Data from a File
   Import FactData
Import Fact Data dialog
   Importing and Exporting
   Importing Data from a File
Import From
   Importing and Exporting
   About Fact Data in Cubes
    Tab-Delimited Text File
       Importing and Exporting
       About Fact Data in Cubes
Import From a Tab-Delimited Text File in Excel
Import Menu
Import Meta Data
Import Metadata dialog
Import Method
    discusses
Import Methods appearing
Import Security
Import Security dialog
Import/export
Imported lines
    PowerOLAP
ImportErr
ImportErr.log
Importing from
    Tab Delimited Text File in Excel
    Tab-Delimited Text File in Excel
Importing January data
Importing Metadata
   Meta Data Import Commands
   Import Metadata
   Importing and Exporting
In data
    pulling
Incorrect Import File Type
    stating
Incremental Data
   Benefits Summary
   Building & Updating Cubes that Support Incremental Updating
   Databases Supported for Use with OLAP Exchange
Incremental Load
   Process Cube (Rebuild Cube)
   Process Cube for Fact or Meta Data Update
   Building & Updating Cubes that Support Incremental Updating
   Creating the Measures Dimension
    Define Indexed Field
       Building & Updating Cubes that Support Incremental Updating
       Creating the Measures Dimension
Incremental Load checkboxes
    Define Indexed Field
Incremental Option
Incremental Update
Incremental Updating
   Use SQL Views
   Process Cube (Rebuild Cube)
   Creating a Cube
   Cube Properties
   Building & Updating Cubes that Support Incremental Updating
   Incremental Update vs. Update from Source
   Creating a Cube via OLAP Exchange
   Databases Supported for Use with OLAP Exchange
   Triggers and their use for Incremental Updating
    employ
    their use
    use
       Use SQL Views
       Databases Supported for Use with OLAP Exchange
Incremental Updating segment
Incrementing column
Incrementing ID
Incrementing index
Indent Children on Rows
Index
   OLAPAliasToMember
   OLAPFactSecurityRuleName
   OLAPFactSecurityRule
   OLAPFactSecurityRangeMembers
   OLAPUserGroup
   OLAPMember
   OLAPFactSecurityStatus
   PARENT
   ALIAS
   OLAPGroup
   PowerOLAP Cube Formula Grammar
   OLAPCube
   OLAPPropertyGroup
   OLAPAlias
   CURRENTINDEX
   CHILD
   OLAPFactSecurityMember
   OLAPCubeDimCount
   WEEKDAY
   OLAPWriteAliasToCube
   member
   Member Types/ Hierarchy Dialog box
   OLAPCubeDimension
   OLAPDimension
   OLAPMemberIndex
   OLAPChild
   Process Cube for Fact or Meta Data Update
   OLAPAliasGroup
   OLAPPivot
   OLAPParent
   Creating the Measures Dimension
   OLAPUser
   OLAPCubeSecurity
   cubedim
   OLAPMemberFirst
   OLAPSubset
   OLAPSubsetMember
   Advanced PowerOLAP Worksheet Functions
   OLAPFactSecurityMemberCount
   Excel Paste Functions
   memberindex
   OLAPRoot
   OLAPFactSecurityPrivileges
   ROOT
   Use Partial Field Member Name
   OLAPRenameMember
   OLAPWriteMemberToCube
    first show
    group corresponding
    member corresponding
       member
       OLAPMember
       OLAPMemberFirst
       memberindex
    Property
    Regions
    User-Group
    value signifying
       currentindex
       memberindex
Index 1
Index 4
Index number
   OLAPCubeDimCount
   OLAPAliasToMember
   OLAPWriteAliasToCube
   member
   OLAPCubeDimension
   OLAPDimension
   OLAPUserGroup
   OLAPChild
   OLAPFactSecurityStatus
   OLAPMemberIndex
   parent
   OLAPAliasGroup
   alias
   OLAPParent
   OLAPCubeSecurity
   OLAPUser
   cubedim
   OLAPCube
   OLAPAlias
   OLAPSubset
   OLAPSubsetMember
   OLAPPropertyGroup
   OLAPWriteMemberToCube
   Advanced PowerOLAP Worksheet Functions
   Excel Paste Functions
   memberindex
   OLAPRoot
   child
   ROOT
    alias
    child
       OLAPChild
       child
    cube
       OLAPCubeDimCount
       OLAPCubeDimension
       OLAPCubeSecurity
       cubedim
       OLAPCube
    dimension
       OLAPCubeDimension
       OLAPDimension
       cubedim
    member
       OLAPParent
       OLAPSubsetMember
       memberindex
Index number4
Index set
Index signifying
    position
Index'th
Indexed root
Indicating
   Creating an Excel Worksheet
   Entering Data in a Slice
    PowerOLAP
    Quantity
Information
   Register and Activate the PowerOLAP Client
   Excel Integration
   Paste and Drill-Through Functions
   WEEKDAY
   char
   Defining Users and Groups
   Security Export/Import Feature
   number
   log
   now
   asin
   Portal Tab
   New Slice Menu & OLAPNavigate
   Member Types/ Hierarchy Dialog box
   SIN
   Dependencies
   date
   Cube Formula Functions
   Error File Reporting
   OLAPReadWrite
   Member Properties
   SQRT
   Creating a Cube
   Working with OLAP Exchange on the MDB Server
   acos
   Cube Properties
   OLAPPivot
   month
   exact
   code
   cos
   Benefits Summary
   Building & Updating Cubes that Support Incremental Updating
   PowerOLAP Cube Formula Grammar
   SECOND
   lower
   Creating the Measures Dimension
   Define Links
   Create and define IDS task to Push Fact Data from a Local Cube
   Window, Tiled or Cascading Slices
   RAND
   The Edit Slice Dialog Box
   atan
   Creating an Excel Worksheet
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Creating a Local Database from the Synchronization Server
   ln
   TAN
   day
   Licensing Tab
   General Tab
   Define Drill Through
   Define Links
   Entering Data in a Slice
   Advanced PowerOLAP Worksheet Functions
   Dynamic Multidimensional Graphs
   TIME
   TIMESTRING
   TODAY
   Excel Functions List
   upper
   Secure Database
   Importing and Exporting
   minute
   OLAPMemberType
   Creating a PowerOLAP Database
   Make Changes Offline and then Synchronize [Remote Capabilities]
   Define Rollups / Drill-Through with Rollups
   Incremental Update vs. Update from Source
   Migrating OLP Databases with Cubes Built from OLAP Exchange,
   Fact Data Import Commands
   YEAR
   int
   exp
   Extended Drill-Through
   Assigning Database Privileges
   PV
   min
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Quick Start Introduction
   mod
   hour
   ipmt
   Creating a Cube via OLAP Exchange
   Saving Your Work (.olt file)
   About Meta Data
   max
   Creating a Slice
   Dependencies
   Other Task Types
   Synchronization Server database in SQL Server
   Modify Relational Dimension
   Register and Activate the PowerOLAP Server
   Creating the 3rd and Further Dimensions
   Additional Information
   lookup
   MDX
   Save Dependencies to File
   Set 3GB Startup Switch in Windows
   Creating the 2nd Dimension
   Concepts and Benefits
Information concerning
   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
Information including
Information indicating
Information needed
Ini
Ini file
Initial Values
Input
   LEN
   MID
   RIGHT
   TRIM
   LEFT
   Meta Data Import Commands
   levelcount
   member
   Creating a Slice View
   pmt
   SIGN
   SUBSTITUTE
   membercount
   REPLACE
   SCAN
   exact
   Benefits Summary
   PPMT
   lower
   level
   fv
   REPT
   iserror
   find
   PROPER
   Entering Data in a Slice
   TIME
   upper
   Creating a Cube
   memberindex
   PV
   ipmt
INPUTNUMBER
Insert After
   Meta Data Import Commands
   New Slice Menu & OLAPNavigate
Insert After Regions
    choosing
Insert Before
   Meta Data Import Commands
   New Slice Menu & OLAPNavigate
Insert Before Regions
Insert Function
   OLAPDimension
   OLAPDimCount
   OLAPAlias
   OLAP AliasGroupCount
   OLAPRootCount
   OLAPUserInGroup
   OLAPFactSecurityMember
   OLAPCubeDimCount
   OLAPAliasToMember
   OLAPFactSecurityRuleCount
   OLAPFactSecurityRuleName
   OLAPSubsetCount
   OLAPFactSecurityRangeMembers
   OLAPFactSecurityRule
   OLAPDimensionSecurity
   OLAPCubeDimension
   OLAPUserGroup
   OLAPParentCount
   OLAPMemberNext
   OLAPMember
   OLAPSave
   OLAPMemberIndex
   OLAPFactSecurityStatus
   OLAPChild
   OLAPSubsetMemberCount
   OLAPWrite
   OLAPDimMaxLevel
   OLAPParent
   OLAPMemberProperty
   OLAPMemberLevel
   OLAPGroup
   OLAPCanAddDimensionAndCubes
   OLAPCubeSecurity
   OLAPDatabase/OLAPOpen
   OLAPMemberFirst
   OLAPGroupCount
   OLAPCube
   OLAPCubeCount
   OLAPSubset
   OLAPSubsetMember
   OLAPPropertyGroup
   OLAPCurrentUser
   Advanced PowerOLAP Worksheet Functions
   OLAPIsChildOf
   OLAPIsParentOf
   OLAPMemberCount
   OLAPChildCount
   OLAPMemberType
   OLAPRoot
   OLAPWeight
   OLAPUserCount
   OLAPUserGroupCount
   OLAPPropertyGroupCount
   OLAPSliceSecurity
   OLAPRenameProperty
   OLAPRenameMember
   OLAPRenameAlias
   OLAPNavigate
   OLAPFormula
   Excel Functions List
   OLAPQuery
   OLAPIsFormula
Insert Function button
    selecting
Insert Function dialog
   Advanced PowerOLAP Worksheet Functions
   OLAPFormula
   OLAPIsFormula
Insert OLAPFormula
Insert OLAPIsFormula
Insert/Function
   OLAPWriteAliasToCube
   OLAPTable
   OLAPPivot
   OLAPFactSecurityMemberCount
   OLAPFactSecurityPrivileges
   OLAPWriteMemberToCube
Inserting
   Excel Functions List
   Triggers and their use for Incremental Updating
   OLAPFormula
   OLAPIsFormula
    selecting
       Excel Functions List
       OLAPFormula
       OLAPIsFormula
Install
Installation
   Remove Existing Version
   Installation of the PowerOLAP Version 8 Client
   Installing PowerOLAP MDB Server
   PowerOLAP Scheduler
   PowerOLAP Service Control Program
   Installing Additional PowerOLAP Client Components
   PowerOLAP's Add-In Menuand Toolbar
   Register and Activate the PowerOLAP Server
   PowerOLAP MDB Server Installation
   General Tab
   Importing Data from a File
   Installation of PowerOLAPCOM
   PowerOLAP Server Installation for Non-Admin Users
   Requirements and Recommendations
   Location of the Client Installer
   PowerOLAP Client Installation for Non-Admin Users
    completes
    created during
    PowerOLAP MDB Server
    PowerOLAP Version
Installation Welcome Screen
   PowerOLAP Version 8 MDB Server Installation
   Installation of the PowerOLAP Version 8 Client
    Proceed
Installed during
Installing
   Installing PowerOLAP MDB Server
   PowerOLAP Version 8 MDB Server Installation
   Working with OLAP Exchange on the MDB Server
   Installing Additional PowerOLAP Client Components
   Installation of the PowerOLAP Version 8 Client
   Installation of PowerOLAPCOM
   Remove Existing Version
   PowerOLAP Service Control Program
   Setting New Slice Options
   Exercises
   Register and Activate the PowerOLAP Server
   PowerOLAP Scheduling Service
   Defining an ODBC Data Source between PowerOLAP and a SQL Server
   Location of the Client Installer
   PowerOLAP Client Installation for Non-Admin Users
    Additional PowerOLAP
    licensed number
    MDB Server
    PowerOLAP MDB Server
    PowerOLAP Version
    Version
Installing Additional PowerOLAP
Installs
   Register and Activate the PowerOLAP Client
   Installing PowerOLAP MDB Server
    licensed number
InstallShied Wizard
InstallShield Wizard
   Remove Existing Version
   Installation of PowerOLAPCOM
   PowerOLAP Client Installation for Non-Admin Users
Instance_num
Institute
    Security
INT
   Cube Formula Functions
   PowerOLAP Cube Formula Grammar
   INT
   MOD
   The Edit Slice Dialog Box
    calculate
    terms
Integer
   number
   int
Integer value
Integration
   Introduction to PowerOLAP SCHEDULER
   Concepts and Benefits / Requirements
   Other Task Types
   MDX
Integration Service
Intel
Intel Core Duo
Intel Core Duo 2.33 GHz Processor
Intel Quad
Internal Cube Formula
   Internal Cube Formula
   Creating Cube Formulas
Internet Data Services
   Creating a Task (Internet Data Services)
   IDS – HTTP Interface and REST
   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
   How to Update the Fact Data of Local Cube from Remote Cube
   Internet Data Services
    Clicking
Internet Data Services dialog
   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
    show
Internet Data Services Update
Internet dialog
Internet Explorer Caching Setting
Internet Options
Internet Order Quantity
Internet Sales Amount
Internet Total Product Cost
Intranet
   Excel Integration
   Introduction to the PowerOLAP MDB Server
Introduction
   Select Page MembersUsing Edit Slice
   Quick Start Introduction
   Introduction to the PowerOLAP MDB Server
   Calculation Engines
   Introduction to Formula Basic, Cube Formulas, Dependencies &
   Caching
   Transfer Cube
   Introduction to PowerOLAP SCHEDULER
   Introduction to PowerOLAP's Persistent Calculations
   MDX
    PowerOLAP®
    review
Invert Selection
Involving
    Customers
IP
   PowerOLAP Service Control Program
   Create and define IDS task to Pull Fact Data from a Remote Cube
   Requirements and Recommendations
IP Address
IP Port
IPAddress
    server
IPMT
   PowerOLAP Cube Formula Grammar
   ipmt
IPMT function
IPMT2
IPMT3
Is a Dimension
ISCHILDOF
   ischildof
   PowerOLAP Cube Formula Grammar
ISCHILDOF function
ISERRO function
ISERROR
ISERROR function
ISMISSING
   PowerOLAP Cube Formula Grammar
   missing
   ismissing
ISMISSING function
   missing
   ismissing
ISO
Italian
Item Count

>>