<<

G26
G8
   OLAPTable
   OLAPPivot
GB
   Minimum Hardware Recommendations
   Set 3GB Startup Switch in Windows
GB RAM
   Introduction to the PowerOLAP MDB Server
   Minimum Hardware Recommendations
General
   Installing PowerOLAP MDB Server
   Create the SQL Server Login
   Creating a Slice View
   OLAPReadWrite
   Configuring PowerOLAP Server Service to Logon as User Account
   Slice View Formatting
   Creating an Excel Worksheet
   General Tab
   Settings General & Format Preferences
   Defining Users and Groups
   General Formatting and Printing
   Grid Shortcut Menu Options
   Formula Syntax and Terminology
   Assigning Meta Data Security Privileges
   Formula Basics
   PowerOLAP Cube Formula Grammar
   Create a Time Dimension
   Creating Cube Formulas
   Advanced PowerOLAP Worksheet Functions
   Dynamic Multidimensional Graphs
   Creating a New JOB
   Importing and Exporting
   Fact Data Security Ranges
   Summary of Quick Start Exercises
   Extended Drill-Through
   Graph's Shortcut menu options
   Creating a Task
   IDS - Internet Explorer Caching Setting
   Creating a PowerOLAP Database
    Return
General & Format Preferences
General Form
   PowerOLAP Cube Formula Grammar
   Fact Data Security Ranges
   Formula Syntax and Terminology
General Formatting
General Information dialog
   Creating a New JOB
   Creating a Task
    show
General Procedure
   Creating Cube Formulas
   Defining Users and Groups
   Assigning Meta Data Security Privileges
   Advanced PowerOLAP Worksheet Functions
   Importing and Exporting
General Settings
   Grid Shortcut Menu Options
   Dynamic Multidimensional Graphs
   Graph's Shortcut menu options
   General Formatting and Printing
General Tab
   General Tab
   Installing PowerOLAP MDB Server
   Creating a Slice View
   OLAPReadWrite
   Configuring PowerOLAP Server Service to Logon as User Account
   Creating an Excel Worksheet
   IDS - Internet Explorer Caching Setting
Generate
   Error File Reporting
   Triggers and their use for Incremental Updating
   Meta Data Import Commands
   Excel Integration
   OLAPTable
   Security Export/Import Feature
   OLAPPivot
   Process Cube for Fact or Meta Data Update
   PowerOLAP Cube Formula Grammar
   SECOND
   RAND
   iserror
   Transaction Log
   Advanced PowerOLAP Worksheet Functions
   Importing and Exporting
   ROUND
   lookup
   Calculation Depth
   Ramifications of Modify Relational Dimension
   Synchronization Server database in SQL Server
   MDX
    Hierarchies
    Meta Data
Governing
   Dependencies
   User Considerations
    Revenue
       Dependencies
       User Considerations
Grant Database Privileges
Granting
   Granting Slices Meta Security Rights
   Granting Cube Security Rights
   Access Privileges
   Granting Dimensions Meta Security Rights
   Granting Rights to Add Dimensions and Cubes
   How to Grant Database Privileges
    Cube Security Rights
    Dimensions
    Dimensions Meta Security Rights
    LDV
    Rights
    Slices Meta Security Rights
Graph
   Dynamic Multidimensional Graphs
   Graph's Shortcut menu options
   Excel Integration
   Grid Shortcut Menu Options
   Designer's Grid and Graphing Features
    Set
Graph Control Settings
Graph Footer
    Set
Graph Grid
Graph Legend
    Set
Graph Object
Graph Settings
Graph Shortcut menu
Graph X-Axis
    Set
Graph Y-Axis
    Set
Graph's Shortcut menu options
Graphing Features
Greater than
Greater than zero
Grid
   Grid Shortcut Menu Options
   Short-Cut Menus for the Grid
   Select Page MembersUsing Edit Slice
   Stack or Nest Dimensions
   General Formatting and Printing
   Creating a Slice View
   Designer Slices can be Fully Formatted and Printed
   Select Row or Column Members Using Edit Slice
   Cube Properties
   Zero Suppression
   Entering Data through an Excel Worksheet
   Changing the Grid Layout
   Designer's Grid and Graphing Features
   Grid features Drill-Down on Members and Data within the Slice
   Entering Data in a Slice
   Rearranging Dimensions within a Slice
   Dynamic Multidimensional Graphs
   Summary of Quick Start Exercises
   Arranging Slice Dimensions
    command Shows
    Hides
    Short-Cut Menus
    Short-Cut Menus for
    Shows
Grid features
Grid Layout
    Changing
Grid Shortcut menu
Grid Shortcut Menu Options
Gross Margin
   Zero Suppression
   PowerOLAP Cube Formula Grammar
Gross Profit
   Aggregate Weights
   Entering Data in a Slice
   Creating Cube Formulas
   Creating a Dimension Hierarchy
Gross Sales
Group
   OLAPUserInGroup
   Select Page MembersUsing Edit Slice
   Member Aliases & Alias Groups
   OLAPAliasToMember
   Security Export/Import Feature
   Defining Users and Groups
   OLAPMemberToAlias
   Assigning Meta Data Security Privileges
   ALIAS
   OLAPMemberProperty
   OLAPCanAddDimensionAndCubes
   ALIASTOMEMBER
   Creating the Measures Dimension
   Constraints
   OLAPCubeSecurity
   Create the User Domain Account in the Active Directory
   Change Aliases
   OLAPAlias
   Add Users and Groups
   Change Properties
   Secure Database
   Excel Paste Functions
   Assigning Fact Data Security Privileges
   Define Properties—Create a Properties Group
   Define Rollups / Drill-Through with Rollups
   Applying Database Security
   Assigning Database Privileges
   Changing Data Views from within Excel
   OLAPFactSecurityPrivileges
   Meta Data Import Commands
   Create/Save a Dimension Subset
   Member Types/ Hierarchy Dialog box
   OLAPDimensionSecurity
   OLAPUserGroup
   Select Row or Column Members Using Edit Slice
   Process Cube (Rebuild Cube)
   OLAPChild
   Granting Slices Meta Security Rights
   Process Cube for Fact or Meta Data Update
   SUMMARY: The Dimension Hierarchy Toolbar
   PROPERTY
   Granting Cube Security Rights
   Zero Suppression
   Benefits Summary
   PowerOLAP Cube Formula Grammar
   OLAPGroup
   Caching
   Granting Dimensions Meta Security Rights
   OLAPGroupCount
   OLAPPropertyGroup
   Create Dimension Hierarchy
   Excel Functions List
   Importing and Exporting
   Fact Data Security Ranges
   OLAPUserGroupCount
   OLAPPropertyGroupCount
   Database Reference Formulas
   OLAPSliceSecurity
   Granting Rights to Add Dimensions and Cubes
   Create the SQL Server Login
   OLAPRenameProperty
   OLAPRenameAlias
   The Edit Slice Dialog Box
   Active Directory Authentication
   MDX
    Add
    Add Users
    adding
    Adds
    click-selecting
    creating
    Cube
    Dimension
    entered
       OLAPAliasToMember
       ALIAS
       OLAPCanAddDimensionAndCubes
       ALIASTOMEMBER
       OLAPAlias
    expanding
    Member
       Excel Paste Functions
       Define Rollups / Drill-Through with Rollups
       Changing Data Views from within Excel
       Select Page MembersUsing Edit Slice
       Select Row or Column Members Using Edit Slice
       Constraints
    Members
       Select Page MembersUsing Edit Slice
       Creating the Measures Dimension
       Constraints
    security privileges assigned
    Select Add
    shows
    Slice
    Users
Group corresponding
    index
Group Memberships dialog
Group Name
   Defining Users and Groups
   Add Users and Groups
   OLAPUserInGroup
   OLAPGroup
   OLAPUserGroupCount
Group of Members
   Creating the Measures Dimension
   Select Page MembersUsing Edit Slice
   Select Row or Column Members Using Edit Slice
   Constraints
   Changing Data Views from within Excel
Group-privilege
Group1
Groups according
Groups Button
   Assigning Meta Data Security Privileges
   Caching
   Add Users and Groups
   Define Properties
Groups Dialog
   Defining Users and Groups
   Assigning Meta Data Security Privileges
   Granting Slices Meta Security Rights
   Granting Cube Security Rights
   Granting Dimensions Meta Security Rights
   Add Users and Groups
   Secure Database
Groups list
   Defining Users and Groups
   The Edit Slice Dialog Box
   Active Directory Authentication
Groups trying
Groups window
    Users

>>