Index

A

• Actions, drillthrough
  • defining / Actions
  • Generic Action / Actions
  • Reporting Action / Actions
  • Drillthrough Action / Actions
• Add Business Intelligence Wizard
  • using / The Add Business Intelligence Wizard, Data stored in multiple currencies with reporting in multiple currencies
  • Currency dimension / Concepts and prerequisites
  • Time dimension / Concepts and prerequisites
  • Exchange Rate measure group / Concepts and prerequisites
  • using, methods / How to use the Add Business Intelligence wizard, Data collected in a single currency with reporting in multiple currencies, Data collected in multiple currencies with reporting in a single currency
  • data collected, in single currency with multiple currency reporting / Data collected in a single currency with reporting in multiple currencies
  • currency conversion options, setting / Data collected in a single currency with reporting in multiple currencies
  • conversion type, selecting / Data collected in a single currency with reporting in multiple currencies
  • reporting currencies, specifying / Data collected in a single currency with reporting in multiple currencies
  • page, completing / Data collected in a single currency with reporting in multiple currencies
  • data collected, in single currency with single currency reporting / Data collected in multiple currencies with reporting in a single currency
  • data collected, in multiple currency with multiple currency reporting / Data stored in multiple currencies with reporting in multiple currencies
  • Pivot Currency / DirectSlice property
  • Local Currency / DirectSlice property
  • Reporting Currency / DirectSlice property
• administrative security, Analysis Service
  • granting / Administrative security
  • granting, at database level / Administrative security
  • granting, at server level / Administrative security
• aggregation, performance-specific design features
  • advantage / Aggregations
  • intial design, creating / Creating an initial aggregation design
  • EstimatedRows property / Creating an initial aggregation design
  • AggregationUsage property / Creating an initial aggregation design
  • EstimatedCount property, verifying / Creating an initial aggregation design
  • Set Aggregation Options step / Creating an initial aggregation design
  • restrictions, applying / Creating an initial aggregation design
  • Usage-based optimisation / Usage-based optimization
  • QueryLogSampling property / Usage-based optimization
  • processing / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • and partition usage, monitoring / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • building, manually / Profilertrace results, intepretingBuilding aggregations manually
  • design issues / Common aggregation design issues
• AggregationUsage property
  • setting / Creating an initial aggregation design
  • setting, to Full value / Creating an initial aggregation design
  • setting, to Nonevalue / Creating an initial aggregation design
  • setting, to Unrestrictedvalue / Creating an initial aggregation design
  • setting, to Default value / Creating an initial aggregation design
• Analysis Service
  • database / The source database
  • data modeling / Data modeling for Analysis Services
  • phsyical database / Physical database design for Analysis Services
  • edition, selecting / Choosing an edition of Analysis Services
  • new project, setting up in BI Development Studio / Setting up a new Analysis Services project
  • project mode / Setting up a new Analysis Services project
  • online mode / Setting up a new Analysis Services project
  • project properties, setting up / Setting up a new Analysis Services project
  • Deployment Server Edition property, changing / Setting up a new Analysis Services project
  • processing option, changing / Setting up a new Analysis Services project
  • server property, changing / Setting up a new Analysis Services project
  • database property, changing / Setting up a new Analysis Services project
  • data source, accessing / Creating data sources
  • TinyInt / data source, creatingaboutCreating Data Source Views
  • groups, creating / Grouping
  • banding / Slowly Changing Dimensions
  • measures / Measures and aggregation
  • drillthrough feature / Details about transactional data
  • Rank function / Racalculated membersmoving averages calculationnks
  • queries, processing / How Analysis Services processes queries
  • Formula Engine / How Analysis Services processes queries
  • Storage Engine / How Analysis Services processes queries
  • security features / Analysis Services security features
  • permission, granting to securable object / Securable objects
  • administrative security / Administrative security
  • accessing, from outside domain / Accessing Analysis Services from outside a domain
  • proactive caching / Proactive caching
  • data directory, maintaining / BaAnalysis Servicedata directory, maintainingckup
  • database, backing up / BaAnalysis Servicedata directory, maintainingckup
  • database, copying between servers / Copying databases between servers
  • Synchronize XMLA command, using / Copying databases between servers
  • backup/restore, using / Copying databases between servers
  • Attach/Detach, using / Copying databases between servers
  • and operating system, interacting with / Analysis Services and the operating system
  • shrinkable objects / Monitoring Processing with Dynamic Management Views
  • non shrinkable objects / Monitoring Processing with Dynamic Management Views
  • usage, monitoring / Monitoring usage
• Analysis Service edition
  • Standard Edition / Choosing an edition of Analysis Services
  • selecting / Choosing an edition of Analysis Services
  • Enterprise Edition / Choosing an edition of Analysis Services
• Analysis Services Stored Procedure Project
  • about / Performance tuning methodology
• ASCMD utility
  • about / Managing processing with Integration Services

B

• banding
  • restrictions / Banding
  • changing, by user / Banding
  • advantage / Banding
• block computation
  • about / Tuning the implementation of MDX
• Blue Squiggly Lines
  • about / Deployment
• bridge table, data modeling
  • about / Bridge tables, or factless fact tables
  • example / Bridge tables, or factless fact tables
  • benefits / Bridge tables, or factless fact tables
• built-in aggregation, measures
  • sum / Basic aggregation types
  • count / Basic aggregation types
  • min and max / Basic aggregation types
  • Distinct Count / Distinct Count
  • None / None
  • semi-additive types / Semi-additive aggregation types
  • ByAccount / By Account

C

• caching
  • about / Caching
  • Query Context / Formula cache scopes
  • Session Context / Formula cache scopes
  • Global Context / Formula cache scopes
  • situations / Formula cache scopes
  • restrictions / Other scenarios that restrict caching
  • warming / Cache warming
  • CREATE CACHE statement / Create Cache statement
  • statement, creating / Create Cache statement
  • batches of queries, running / Create Cache statement
• calculated members
  • query-scoped calculated members / Different kinds of calculated members
  • session-scoped calculated members / Different kinds of calculated members
  • globally-scoped calculated members / Different kinds of calculated members
  • common calculations / Common calculations
  • simple calculations / Simple calculations
  • simple calculations, adding / Simple calculations
  • cell values, referencing / Referencing cell values
  • Aggregate function, using / Aggregating members
  • year-to-date calculations / Year-to-dates
  • ratio of measures, computing / Ratios over a hierarchy
  • previous growth periods calculation / Previous period growths
  • same period previous year calculation / Same period previous year
  • moving averages calculation / Moving averages, Racalculated membersmoving averages calculationnks
  • moving averages calculation, NonEmpty function / Moving averages
  • moving averages calculation, LastPeriods function / Moving averages
  • Rank function / Racalculated membersmoving averages calculationnks, Forcalculated membersRank functionmatting calculated measures
  • formatting / Forcalculated membersRank functionmatting calculated measures
  • errors / Forcalculated membersRank functionmatting calculated measures
• calculation dimension
  • about / Calculation dimensions
  • simple calculation dimension, creating / Implementing a simple calculation dimension
  • Time Intelligence Wizard / Calculation dimension pitfalls and problems
  • using, best practices / Calculation dimension best practices
  • example / Namcalculation dimensionexampleed sets
• cell-by-cell
  • about / Tuning the implementation of MDX
• cell security
  • Read Contingent / Cell security
  • Read / Cell security
  • disadvantage / Cell security
• Contex
  • about / Dynamic security with stored procedures
• cube
  • changes, making / Making changes to a cube in production
  • changes,deploying / Making changes to a cube in production
  • Visual Studios project, using / Making changes to a cube in production
  • Deployment Wizard, using / Making changes to a cube in production
• currency conversion
  • about / Introduction to currency conversion
  • requirements / Introduction to currency conversion
  • scenarios / Introduction to currency conversion
  • data collected, using in single currency / Data collected in a single currency
  • data collected, using in multiple currencies / Data collected in a multiple currencies
  • implementing, in Analysis Service / Where to perform currency conversion
  • implementing, MeasureExpression property used / Measure expressions

D

• database
  • data warehouse / The data warehouse
• database, Analysis Service / The source database
  • OLTP database / The OLTP database
  • data warehouse / The data warehouse
  • data mart / The data mart
• data modeling, Analysis Service
  • about / data modeling, Analysis ServiceaboutFact tables and dimension tables
  • dimension table / data modeling, Analysis ServiceaboutFact tables and dimension tables
  • fact table / data modeling, Analysis ServiceaboutFact tables and dimension tables
  • star schema / Star schemas and snowflake schemas
  • snowflake schema / Star schemas and snowflake schemas
  • star schema, generating / Star schemas and snowflake schemas
  • snowflake schema, disadvantage / Star schemas and snowflake schemas
  • snowflake schema, advantage / Star schemas and snowflake schemas
  • junk dimensions / Junk dimensions
  • junk dimension, advantages / Junk dimensions
  • junk dimension, disadvantages / Junk dimensions
  • degerate dimensions / Degenerate dimensions
  • degerate dimensions, Fact relationship / Degenerate dimensions
  • SCDs / Slowly Changing Dimensions
  • bridge table / Bridge tables, or factless fact tables
  • surrogate keys / Natural and surrogate keys
  • surrogate keys, date / Natural and surrogate keys
  • surrogate keys, ranges / Natural and surrogate keys
  • surrogate keys, junk dimension / Natural and surrogate keys
  • NULLability / Unknown members, key errors, and NULLability
  • foreign keys, using / Unknown members, key errors, and NULLability
  • key errors / Unknown members, key errors, and NULLability
• data security
  • Read acess, granting to cubes / Granting read access to cubes
  • cell security, configuring / Cell security
  • dimension security / Dimension security
  • Measure dimension, securing / Applying security to measures
  • Measure dimension, evaluating / Applying security to measures
  • dynamic security / Dynamic security
  • dynamic dimension security / Dynamic dimension security
  • dynamic security, with stored procedures / Dynamic security with stored procedures
  • parent/child hierarchies / Dimension security and parent/child hierarchies
• data source, creating
  • about / Creating data sources, data source, creatingaboutCreating Data Source Views
  • OLE DB provider, choosing for SQL Server data source / Creating data sources
  • OLE DB provider, choosing for Oracler data source / Creating data sources
  • permission, granting / Creating data sources
  • Use Service Accout option, using / Creating data sources
• data sources
  • creating / Creating data sources
• data warehouse, database
  • about / The data warehouse
  • defining / The data warehouse
  • defining, Kimball’s bus architecture / The data warehouse
  • defining, lnmon bus architecture / The data warehouse
  • structural updates / Updating fact and dimension tables
• dimension, designing
  • about / Designing simple dimensions
  • New Dimension wizard, running / Using the 'New Dimension' wizard
  • Select Creation Method, options / Using the 'New Dimension' wizard
  • New Dimension wizard, key attribute / Using the 'New Dimension' wizard
  • New Dimension wizard, name attribute / Using the 'New Dimension' wizard
  • New Dimension wizard, naming / Using the 'New Dimension' wizard, Udimension, designingNew Dimension wizard, namingsing the Dimension Editor
  • Dimension Editor, using / Udimension, designingNew Dimension wizard, namingsing the Dimension Editor
• dimension/measure group relationships
  • about / Dimension/measure group relationships
  • fact relationships / Fact relationships
  • fact relationships and regular relationship, differences / Fact relationships
  • referenced relationship / Referenced relationships
  • data mining relationship / Data mining relationships
• dimension calculations, measures
  • unary operators, defining / Unary operators and weights
  • Custom Member Formulas, using / Custom Member Formulas
  • Custom Member Formulas, advantages / Custom Member Formulas
  • Custom Member Formulas, drawback / Custom Member Formulas
• dimension design
  • grouping / Grouping
  • banding / Banding, Slowly Changing Dimensions
  • issues / Slowly Changing Dimensions, Junk dimensions, Ragged hierarchies
  • Junk dimensions / Junk dimensions
  • raggged hierarchies / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
• Dimension Editor, dimension
  • using / Adding new attributes
  • KeyColumns property / Adding new attributes
  • NameColumn property / Adding new attributes
  • AttributeHierarchyEnabled property / Adding new attributes
  • AttributeHierarchyOptimizedState property / Adding new attributes
  • OrderBy property / Adding new attributes
  • OrderByAttribute property / Adding new attributes
  • AttributeHierarchyOrdered property / Adding new attributes
  • IsAggregatable property / Adding new attributes
  • DefaultMember property / CDimension Editor, dimensionDefaultMember propertyonfiguring a Time dimension
  • Time dimension, configuring / CDimension Editor, dimensionDefaultMember propertyonfiguring a Time dimension
  • Time dimension, benefits / CDimension Editor, dimensionDefaultMember propertyonfiguring a Time dimension
  • user hierarchies, creating / Creating user hierarchies
  • attribute relationship, configuring / Configuring attribute relationships
  • natural user hierarchies / Configuring attribute relationships
  • unnatural user hierarchies / Configuring attribute relationships
• dimension processing
  • about / Dimension processing
  • full option / Dimension processing
  • add option / Dimension processing
  • update option / Dimension processing
  • unprocess option / Dimension processing
  • default option / Dimension processing
  • strategies, using / Dimension processing
• Dimensions
  • about / Dynamic security with stored procedures
• dimension security, data security
  • features / Dimension security
  • Select All Members option / Dimension security
  • Deselect All Members option / Dimension security
  • Sales Territory hierarchy / Dimension security
  • Enable Visual Totals option used / Dimension security
  • Advanced tab / Dimension security
  • Basic tab / Dimension security
• dimension tables, data modeling
  • about / data modeling, Analysis ServiceaboutFact tables and dimension tables
  • physical distinctions / Updating fact and dimension tables
  • structural updates / Updating fact and dimension tables
  • data mart indexes / Indexes in the data mart
• DMVs
  • about / Monitoring Processing with Dynamic Management Views
• drillthrough
  • about / Drillthrough
  • feature / Drillthrough
  • Actions, defining / Actions
  • action, defining / Drillthrough actions
  • modelling / Drillthrough modeling
  • data, modelling / Drillthrough modeling, Drillthrough using a transaction details dimension, Drillthrough with ROLAP dimensions, Drillthrough on Alternate Fact Table, Drillthrough recap
  • on transaction Details dimension / Drillthrough using a transaction details dimension
  • ROLAP dimensions, using / Drillthrough with ROLAP dimensions
  • Alternate Fact Table approach / Drillthrough on Alternate Fact Table
  • recap / Drillthrough recap
• drillthrough action, drillthrough
  • defining / Drillthrough actions
  • Action Target / Drillthrough actions
  • condition property / Drillthrough actions
  • Drillthrough Columns property / Drillthrough actions
  • Default property, setting / Drillthrough actions
  • executing, in Microsoft Excel 2007 / Drillthrough actions
  • Drillthrough Columns order / Drillthrough Columns order
  • real members, creating / Drillthrough and calculated members
  • DateTool dimension / Drillthrough and calculated members
  • Rowset, creating / Drillthrough and calculated members
• DSV
  • about / Views versus the Data Source View
  • disadvantages, over view / Views versus the Data Source View
  • creating / data source, creatingaboutCreating Data Source Views
  • retrieve relationship property, setting / data source, creatingaboutCreating Data Source Views
  • schema restriction property, setting / data source, creatingaboutCreating Data Source Views
  • NameMatchingCriteria property, setting / data source, creatingaboutCreating Data Source Views
  • Add/Remove Tables option / data source, creatingaboutCreating Data Source Views
  • multiple diagrams, creating / data source, creatingaboutCreating Data Source Views
• dynamic cell security
  • about / Dynamic cell security
  • requirements / Dynamic cell security

E

• Enterprise Edition, Analysis Service edition
  • lilmitation / Choosing an edition of Analysis Services
  • advantages / Choosing an edition of Analysis Services
• ErrorConfiguration property
  • about / Handling processing errors
• EstimatedRows property
  • about / Building a template partition

F

• fact table, data modeling
  • about / data modeling, Analysis ServiceaboutFact tables and dimension tables
  • transaction fact table / Snapshot and transaction fact tables
  • snapshots / Snapshot and transaction fact tables
  • snapshots, using / Snapshot and transaction fact tables
  • structural updates / Updating fact and dimension tables
  • data updates / Updating fact and dimension tables
  • data mart indexes / Indexes in the data mart

G

• Generate function
  • about / Dimension security and parent/child hierarchies
• GetMembers
  • about / Dynamic security with stored procedures
• grouping
  • need for / Grouping
  • DiscretizationMethod property / Grouping

J

• Junk dimensions
  • creating / Junk dimensions
  • Type II SCD, using / Junk dimensions

L

• Levels
  • about / Dynamic security with stored procedures
• LinkMember function
  • about / Dimension security and parent/child hierarchies

M

• many-to-many dimension
  • about / Many-to-many dimension relationships
  • implementing / Implementing a many-to-many dimension relationship
  • advanced dimensional modelling / Advanced modelling with many-to-many relationships
  • issues, resolving / Performance issues
• MDX
  • tuple / Referencing cell values, Aggregating members
• MDX calculation performance
  • formula engine performance, diagnosing / Diagnosing Formula Engine performance problems
  • performance tuning, calculating / Calculation performance tuning
  • algorithms, tuning / UsingMDX calculation performancealgorithms, tuning named sets to avoid recalculating set expressions
  • algorithms, naming sets used / UsingMDX calculation performancealgorithms, tuning named sets to avoid recalculating set expressions
  • calculated members, using / Using calculated members to cache numeric values
  • implementation, tuning / Tuning the implementation of MDX
  • rules / Tuning the implementation of MDX
  • NonEmpty function, using / Tuning the implementation of MDX
• MeasureExpression property
  • using / Measure expressions
  • about / Measure expressions
  • DirectSlice property / DirectSlice property
  • DirectSlice property, consequences / DirectSlice property
  • writeback / Writeback
  • writeback, disadvantages / Writeback
• measure groups
  • multiple groups, creating / Creating multiple measure groups
  • single cube approach, advantages / Creating multiple measure groups
  • multiple cube approach, advantages / Creating multiple measure groups
  • creating, dimension tables used / Creating measure groups from dimension tables
  • different dimensionality, handling / Handling different dimensionality
  • IgnoreUnrelatedDimensions property / Handling different dimensionality, Handling different granularities
  • different granularities, handling / Handling different granularities
  • non-aggregatable measure / Non-aggregatable measures: a different approach
  • linked objects, limitations / Using linked dimensions and measure groups
  • role playing dimensions / Role-playing dimensions
  • relationship, with dimensions / Dimension/measure group relationships
• measures
  • about / Measures and aggregation
  • property / Useful properties of measures
  • built-in aggregation, types / Basic aggregation types
  • dimension calculations / Dimension calculations
  • non-aggregatable measures / Non-aggregatable values
  • non-aggregatable measures, MembersWithData property / Non-aggregatable values
  • non-aggregatable measures, displaying / Non-aggregatable values
  • measure groups / Measure groups
• Memory management, operating system
  • about / Analysis Services memory management
  • 32-bit and 64-bit memory, differentiating / Memory differences between 32 bit and 64 bit
  • memeory manager, controlling / Controlling the Analysis Services Memory Manager
  • LowMemoryLimit property / Controlling the Analysis Services Memory Manager
  • TotalMemoryLimit. property / Controlling the Analysis Services Memory Manager
  • MidMemoryPrice property / Controlling the Analysis Services Memory Manager
  • HighMemoryPrice property / Controlling the Analysis Services Memory Manager
  • out of memory condition / Out of memory conditions in Analysis Services
  • abnormal virtual memory consumption, reasons / Out of memory conditions in Analysis Services
• memory paging
  • preventing / Memory
• Microsoft Management Console (MMC)
  • about / Performance counters
• MOLAP
  • about / Managing processing
• MOLAP (Multidimensional Online Analytical Processing) / Indexes in the data mart
• MSOLAP Memory
  • Cleaner Memory nonshrinkable KB / Monitoring Processing with Performance Monitor counters
  • Cleaner Memory shrinkable KB / Monitoring Processing with Performance Monitor counters
  • Cleaner Memory KB / Monitoring Processing with Performance Monitor counters
  • Memory Limit High KB / Monitoring Processing with Performance Monitor counters
  • Memory Limit Low KB / Monitoring Processing with Performance Monitor counters
  • Memory Usage KB / Monitoring Processing with Performance Monitor counters

N

• named set
  • defining / Regnamed setdefiningular named sets
  • regular named sets / Regnamed setdefiningular named sets, Dynanamed setregular named setsmic named sets
  • dynamic named sets / Dynanamed setregular named setsmic named sets

O

• OLTP database
  • about / The OLTP database
  • common characteristics / The OLTP database
• operating system
  • and Analysis Service, interacting with / Analysis Services and the operating system
  • resource consumption monitoring tools / Tools to monitor resource consumption
  • Memory management / Analysis Services memory management
  • SQL Server and Analysis Service, sharing / Sharing SQL Server and Analysis Services on the same machine

P

• % Processor Time
  • process category / Performance counters
• partition, performance-specific design features
  • about / Partitions
  • need for / Why partition?
  • benefits / Why partition?
  • building / Building partitions
  • building, Table Binding / Building partitions
  • building, Query Binding / Building partitions
  • Remote Partitions / Building partitions
  • slice property, setting / Building partitions
  • strategy, planning / Planning a partitioning strategy
  • generating, in large numbers / Planning a partitioning strategy
  • unexpected scanning / Unexpected partition scans
  • extra scan, factors / Unexpected partition scans
  • and aggregation, monitoring / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • managing / Managing partitions
  • relational partitioning / Relational versus Analysis Services partitioning
  • Analysis Service partitioning / Relational versus Analysis Services partitioning
  • template partition, building / Building a template partition, partition, performance-specific design featurestemplate partition, buildingGenerating partitions in Integration Services
  • building, in Integration Service / partition, performance-specific design featurestemplate partition, buildingGenerating partitions in Integration Services
• partition processing
  • full option / Partition processing
  • add option / Partition processing
  • date option / Partition processing
  • index option / Partition processing
  • default option / Partition processing
  • unprocess option / Partition processing
  • issues / Partition processing
  • options, using / Partition processing
• performance-specific design, features
  • about / Performance-specific design features
  • partition / Partitions
  • aggregation / Aggregations
• Performance Monitor
  • performance counters / Performance counters
• physical database, Analysis Service
  • multiple data sources / Multiple data sources
  • data types / Data types and Analysis Services
  • SQL generated queries / SQL queries generated during cube processing
  • subject areas / Usage of schemas
  • schema, using / Usage of schemas
  • naming conventions / Naming conventions
  • using instead of DSV / Views versus the Data Source View
  • views, advantages / Views versus the Data Source View
• prefetching
  • about / Unexpected partition scans
• processing
  • managing / Managing processing
  • dimension processing / Managing processing, Dimension processing
  • partition processing / Managing processing, Partition processing
  • Lazy aggregations option, using / Lazy Aggregations
  • reference dimension / Processing reference dimensions
  • errors, handling / Handling processing errors
  • ErrorConfiguration property used / Handling processing errors
  • UnknownMember property / Handling processing errors
  • managing, Integration Services used / Managing processing with Integration Services
  • Integration Services, benefits / Managing processing with Integration Services
  • pull-mode processing / Push-mode processing
  • push-mode processing / Push-mode processing
  • proactive caching / Proactive caching
  • performance, monitoring / Monitoring processing performance
  • monitoring, trace data used / Monitoring processing with trace data
  • monitoring, SQL Server Profiler tool / SQL Server Profiler
  • monitoring, ASTrace tool used / ASTrace
  • monitoring, XMLA command / XMLA
  • monitoring, Flight Recorder / Flight Recorder
  • monitoring, Performance Monitor counters used / Monitoring Processing with Performance Monitor counters
  • monitoring, Dynamic Management Views used / Monitoring Processing with Dynamic Management Views
• Profiler
  • using / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • trace results, intepreting / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage, Profilertrace results, intepretingBuilding aggregations manually
  • Query Subcube Verbose events / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • subcubes / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • Progress Report End event / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • Progress Report Begin event / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
  • Get Data From Aggregation event / Moaggregation, performance-specific design featuresprocessingnitoring partition and aggregation usage
• program counters
  • memory counters / Performance counters
  • memory counters, Pages/sec / Performance counters
  • memory counters, Committed Bytes / Performance counters
  • memory counters, % Committed Bytes in Use / Performance counters
  • virtual bytes / Performance counters
  • private bytes / Performance counters
  • page file bytes / Performance counters
  • page file bytes Peak / Performance counters
  • working set / Performance counters
  • working set-private / Performance counters
  • working set-peak / Performance counters
  • Disk I/O counters, PhysicalDisk / Performance counters
  • Disk I/O counters, LogicalDisk / Performance counters
  • Disk I/O counters, Current Disk Queue Length / Performance counters
  • Disk I/O counters, / Performance counters
  • Disk I/O counters, Disk Read Bytes/sec / Performance counters
  • Disk I/O counters, Disk Write Bytes/ / Performance counters
  • process category, IO Data Bytes/sec / Performance counters
  • process category, IO Write Bytes/sec / Performance counters
  • process category, IO Read Bytes/sec / Performance counters
  • Processor category / Performance counters
• property, measures
  • format string / Format String
  • setting, points / Format String
  • display folders / Display folders
  • AggregateFunction / Built-in measure aggregation types

Q

• query performance
  • tuning methodology / Performance tuning methodology
  • designing / Designing for performance
  • optimising / Diagnosing Formula Engine performance problems
  • MDX calculation performance / Diagnosing Formula Engine performance problems
  • and security / Security and query performance
  • cell security / Cell security
  • dimension security / Dimension security, Dynamic security
  • monitoring, trace data used / Monitoring query performance
  • monitoring / Monitoring query performance
  • trace events / Monitoring queries with trace data
  • monitoring, Performance Monitor counters used / Monitoring queries with Performance Monitor counters
  • MSOLAPTopicnquery performanceMSOLAPCache / Monitoring queries with Performance Monitor counters
  • MSOLAPTopicnquery performanceMSOLAPMDX / Monitoring queries with Performance Monitor counters
  • MSOLAPTopicnquery performanceMSOLAPMemory / Monitoring queries with Performance Monitor counters
  • MSOLAPTopicnquery performanceMSOLAPStorage Engine Query / Monitoring queries with Performance Monitor counters
  • monitoring, DMV used / Monitoring queries with Dynamic Management Views
  • MDX Studio / MDX Studio

R

• raggged hierarchies
  • about / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • modeling / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • parent/child hierarchies / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • AttributeHierarchyVisible property / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • parent/child hierarchies, NamingTemplate property / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • parent/child hierarchies, limitations / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • parent/child hierarchies usage, avoiding / dimension designraggged hierarchiesraggged hierarchiesaboutParent/child hierarchies
  • HideMemberIf, setting / Ragged hierarchies with HideMemberIf
  • HideMemberIf, using / Summraggged hierarchiesHideMemberIf, usingary
• RegionsForUsers.isRegionEnabled function
  • about / Dynamic security with stored procedures
• resource consumption monitoring tools, operating system
  • Windows Task Manager / Windows Task Manager
  • performance counters / Performance counters
  • Resource Monitor tool / Resource Monitor
• resources, operating system
  • CPU / CPU
  • system memory / Memory
  • virtual memory manager / Memory
  • private memory / Memory
  • memory paging / Memory
  • I/O operation / I/O operations
  • I/O operation, direct I/O request / I/O operations
  • I/O operation, indirect I/O request / I/O operations
  • I/O operation, disk-related operations / I/O operations
  • I/O operation, transfer of query / I/O operations
• ROLAP
  • about / Managing processing
• role permission, defining
  • general / Creating roles
  • membership / Creating roles
  • data source / Creating roles
  • cubes / Creating roles
  • dimensions / Creating roles
  • dimension data / Creating roles
  • multiple roles membership / Membership of multiple roles

S

• scale-down
  • about / Scale-up and scale-out
• scale-up
  • about / Scale-up and scale-out
• SCDs
  • about / TypSCDsaboute I SCDs
  • Type I SCDs / TypSCDsaboute I SCDs
  • Type II SCDs / TypeType I SCDs, SCDsqueries, saving II SCDs
  • Type III SCDs / Type III SCDs
• SCDs, data modeling
  • type 1 Dimension / Slowly Changing Dimensions
  • type 2 Dimension / Slowly Changing Dimensions
  • type 3 Dimension / Slowly Changing Dimensions
  • type 2 Dimensions modelling, ways / Slowly Changing Dimensions
  • drawbacks / Slowly Changing Dimensions
• security
  • sample requirements / Sample security requirements
  • administrative security / Administrative security
  • data security / Data security
  • managing / Managing security
  • and query performance / Security and query performance
  • cell security / Cell security
  • dimension security / Dimension security
• security features, Analysis Service
  • roles / Roles and role membership
  • roles, accessing / Roles and role membership
  • securable objects / Securable objects
  • Data sources / Securable objects
  • cubes / Securable objects
  • dimensions / Securable objects
  • cells / Securable objects
  • roles, creating / Creating roles
  • role permission, defining / Creating roles
  • roles, testing / Testing roles
  • Roles property / Testing roles
  • EffectiveUserNameproperty / Testing roles
• simple cube, building
  • about / Building a Simple Cube
  • New Cube wizard, using / Using the 'New Cube' wizard
  • deployment / Deployment
  • processing option / warningaboutProcessing
  • processing errors / warningaboutProcessing
• SQL generated queries, physical database
  • Dimension, processing / Dimension processing
  • Dimension, with joined tables / Dimensions with joined tables
  • reference Dimension / Reference dimensions
  • fact Dimension / Fact dimensions
  • distinct count measures / Distinct count measures
  • data mart indexes / Indexes in the data mart
• SQL Management Studio Object Explorer
  • about / Performance tuning methodology
• Standard Edition, Analysis Service edition
  • limitation / Choosing an edition of Analysis Services
• Stored Procedure
  • about / Dynamic security with stored procedures

T

• Time Intelligence Wizard, calculation dimension
  • attribute overwrite / Attribute overwrite
  • problems, avoiding / Attribute overwrite
  • calculated members, limitations / Limitations of calculated members
• trace events, query performance / Monitoring queries with trace data
  • Query Cube Begin (70) / Query Cube End (71)- / Monitoring queries with trace data
  • Progress Report Begin (5) / Progress Report End (6) / Monitoring queries with trace data
  • Calculate Non Empty Begin (72) / Cal culate Non Empty End (74) / Monitoring queries with trace data
  • MDXQuery (0) / Monitoring queries with trace data
  • Calculate Non Empty Begin (72) / Cal / Monitoring queries with trace data
  • Get Data From Aggregation (60) / Monitoring queries with trace data
  • Get Data From Cache (61) / Monitoring queries with trace data
  • Query Dimension (81)- / Monitoring queries with trace data
  • Query Subcube (11 / Monitoring queries with trace data
  • Query Subcube Verbose (12)- / Monitoring queries with trace data
  • Serialize Results Begin (75) / Serialize Results End (77 / Monitoring queries with trace data
• transactional data
  • Fact dimension / Details about transactional data
  • document / Details about transactional data
• Type III SCDs, SCDs
  • about / Type III SCDs
• Type II SCDs, SCDs
  • problem / TypeType I SCDs, SCDsqueries, saving II SCDs
  • attribute relationships, modeling / Modeling attribute relationships on a Type II SCD
  • member status, handling / Handling member status
• Type I SCDs, SCDs
  • about / TypSCDsaboute I SCDs
  • problem / TypSCDsaboute I SCDs
  • queries, saving / TypeType I SCDs, SCDsqueries, saving II SCDs

U

• usage, monitoring
  • trace data used / Monitoring Usage with Trace Data
  • Performance Monitor counters / Monitoring usage with Performance Monitor counters
  • DMVs used / Monitoring usage with Dynamic Management Views
  • Activity Viewer tool / Activity Viewer

V

• virtual address space
  • about / Memory
• virtual memory
  • about / Memory

W

• warning
  • about / warningaboutProcessing
• Windows integrated security
  • about / Roles and role membership
• Windows user
  • about / Roles and role membership
  • domain users / Roles and role membership
  • local users / Roles and role membership
  • cube, accessing / Roles and role membership