Index
A
- <AllowedBrowsingFolders> property / How it works...
- Activity Viewer
- used, for SSAS instance monitoring / Monitoring SSAS instance using Activity Viewer, How to do it..., How it works...
- Add Related Tables button / How to do it...
- advanced attribute properties
- customizing / Customizing advanced attribute properties, How it works...
- advanced dimension processing
- AGGREGATE function / How to do it...
- aggregation designs
- defining / Defining aggregation designs
- BIDS Helper, used for aggregations customizations / Using BIDS Helper for customizing aggregations, How to do it..., There's more...
- aggregation function
- about / There's more...
- SUM / There's more...
- COUNT / There's more...
- MIN / There's more...
- MAX / There's more...
- DISTINCT COUNT / There's more...
- NONE / There's more...
- ByAccount / There's more...
- AverageOfChildren / There's more...
- FirstChild / There's more...
- LastChild / There's more...
- FirstNonEmpty / There's more...
- LastNonEmpty / There's more...
- Aggregation wizard / How to do it...
- All level / Building dimension hierarchies
- AllowedBrowsingFolders property / How to do it...
- Analysis Management Objects (AMO) / Partitioning strategies, Introduction
- Analysis Services
- securing / Introduction
- Analysis Services cubes
- about / Introduction
- Analysis Services database
- backing up / How to do it..., How it works...
- restoring / How to do it..., How it works...
- Analyze in Excel feature / See also
- Analyze with Excel feature / There's more…
- ANCESTOR function / How to do it...
- Attach command / How to do it...
- Attach method / Detaching and attaching databases
- AttributeAllMemberName property / Dimension properties
- AttributeHierarchyEnabled property / How it works...
- AttributeHierarchyOrdered property / How it works...
- AttributeHierarchyVisible property / How it works...
- attributes
- sorting / Sorting the attributes, How to do it...
- AutoSum feature / Creating AutoSum measures
- AutoSum measures
- creating / Creating AutoSum measures
B
- backup/restore commands / How it works...
- backup command / How to do it...
- basic dimension
- about / Learning about basic dimension processing
- processing / How to do it..., How it works...
- BI
- about / Introduction
- business value / The business value of Business Intelligence
- challenges / Challenges and barriers of effective BI
- barriers / Challenges and barriers of effective BI
- challenges, overcoming / Overcoming BI challenges and barriers
- barriers, overcoming / Overcoming BI challenges and barriers
- BIDS
- about / Introduction
- BISM server memory report / BISM server memory report
- BOTTOMCOUNT function / How to do it...
- ByAccount measure / There's more...
- ByAttribute option / Processing performance issues
C
- calculated column
- creating / Creating a calculated column, How to do it…
- calculated columns
- used, for table combining / Combining tables using calculated columns, How to do it…, There's more…
- adding / Adding a calculated column, How to do it…
- calculated measure
- creating / Creating a calculated measure, How to do it…
- calculated measures
- defining / Defining calculated measures, How to do it..., How to do it...
- creating / Creating calculated measures
- CALCULATE function
- using / Using the CALCULATE function
- measures, testing / Test the Measures in Excel
- Time Intelligence, working with / Working with Time Intelligence
- CANCEL command / Cancelling a session
- CategoryName option / Understanding Row Context
- cell-level security
- implementing / Implementing cell-level security, How to do it..., There's more...
- Change User button / How to do it...
- Children function / How to do it...
- Command Begin event / How to do it...
- Command End event / How to do it...
- common issues
- resolving, issues / Managing memory usage
- cube-level security
- managing / Managing cube-level security, How to do it...
- cube-level translations
- defining / How to do it...
- cube acess
- checking / Checking whether cubes are accessible
- cube data
- browsing / Browsing the cube data, How to do it...
- cube dimensions
- time / Introduction
- product / Introduction
- Country of sale / Introduction
- cube file structures
- examining / Examining cube file structures, How to do it..., There's more...
- Cube Structure tab / How to do it...
- Cube Wizard / How to do it...
D
- data
- returning, on query axis / Getting ready, How to do it...
- loading / How to do it…, There's more…
- modeling / Modeling the data, How to do it…, How it works…, There's more…
- Data Analysis Expressions (DAX) / Choosing multidimensional or Tabular Models
- database-level security
- managing / Managing database-level security
- database-level permissions, defining / How to do it...
- database consistency checker (DBCC) command / Checking whether cubes are accessible
- databases
- creating / Creating and dropping databases, How to do it...
- dropping / Creating and dropping databases, How to do it...
- synchronizing / Synchronizing databases, How to do it..., How it works...
- deattaching / How to do it..., How it works...
- attaching / How to do it..., How it works...
- Data Format property / How to do it…
- Data Mining Extensions (DMX) / How to do it...
- data mining relationship / How to do it...
- DataQuery, with Tabular models
- data sources / Data sources
- DataQuery, with Tabular models
- role-based security / Security
- design limitations / Design limitations
- client restrictions / Client restrictions
- data sources
- defining / Defining data sources, How to do it...
- working with / Working with data sources and loading data, How to do it…, There's more…
- Data Source Views (DSVs) / Defining measure groups and measures
- Data type / There's more...
- date and time dimensions
- DAX
- about / Introduction
- DAX Function Reference pages / See also
- DAX Studio / See also
- deadlock / Deadlock
- Deployment Wizard
- using / How to do it...
- DESCENDANTS function / How to do it...
- Deselect all members option / How to do it...
- Detach/Robocopy/Attach method / How it works...
- dimension data
- browsing / Browsing dimension data, How to do it..., How it works...
- dimension hierarchies
- building / Building dimension hierarchies, How to do it..., There's more
- properties, setting / Setting dimension properties
- navigating / Navigating dimension hierarchies, How to do it...
- dimension hierarchy-level security
- dimension processing
- options / Learning advanced dimension processing options
- out-of-line bindings, using / Using out-of-line bindings for dimension processing, How to do it...
- dimension processing, options
- Key error action / Learning advanced dimension processing options
- processing error limit / Learning advanced dimension processing options
- specific error conditions / Learning advanced dimension processing options
- error log path / Learning advanced dimension processing options
- error handling, customizing / How to do it...
- dimension processing options
- about / Understanding dimension processing options
- ProcessFull / How it works...
- ProcessClear / How it works...
- ProcessData / How it works...
- ProcessIndexes / How it works...
- ProcessAdd / How it works...
- ProcessUpdate / How it works...
- ProcessDefault / How it works...
- dimension properties
- AttributeAllMemberName / Dimension properties
- StorageMode / Dimension properties
- ErrorConfiguration / Dimension properties
- ProcessingGroup / Dimension properties
- ProcessingMode / Dimension properties
- StringStoresCompatibilityLevel / Dimension properties
- MDXMissingMemberMode / Dimension properties
- UnknownMember / Dimension properties
- Dimension Structure tab / Setting dimension properties
- dimension usage
- measure group, using / Dimension usage with measure group, How to do it...
- Dimension Usage tab / How to do it...
- DiscretizationBucketCount property / How it works...
- DiscretizationMethod property / How it works...
- DisplayFolder / There's more...
- distinct count measure group
- implementing / How to do it..., There's more...
- DMVs
- used, for SSAS instance monitoring / How to do it..., How it works...
- drillthrough actions
- defining / Defining drillthrough actions, How to do it...
- working / How it works...
- DRILLTHROUGH command / How it works...
- DSV
- about / Defining data source views
- defining / How to do it...
- entity relationships, defining / Defining entity relationships in DSV
- extending / Extending data source views, How to do it...
- dynamic dimension security
- implementing / Implementing dynamic dimension security, How to do it...
- dynamic management view (DMV) / See also
- Dynamic Management Views (DMV) / How it works...
- Dynamic Management Views (DMVs) / Dynamic Management Views
E
- <ExternalCommandTimeout> property / How it works...
- <ExternalConnectionTimeout> property / How it works...
- English Promotion Type attribute / How to do it...
- ErrorConfiguratio property / Dimension properties
- essential attribute properties
- Excel
- model, analyzing / Analyzing your model in Excel, There's more…
- Model, testing / Testing a Tabular Model in Excel, How to do it…, Understanding Row Context
- Extraction, Transformation, and Loading (ETL) / Learning advanced dimension processing options
F
- <ForceCommitTimeout> property / How it works...
- fact relationship / How to do it...
- FILTER function / How to do it..., There's more…
- Format property / Creating AutoSum measures
- FormatString / There's more...
- FormatString property / How to do it...
- Format String property / How to do it...
- Form View button / How to do it...
G
- globally unique identifier (GUID) / How it works...
H
- hierarchy
- creating / Creating a hierarchy, How to do it…
- Hybrid OLAP (HOLAP) / Partition storage mode options
I
- Inherit option / How to do it...
- InMemory option / Dimension properties
- instance-level administrative security
- managing / Managing instance-level administrative security
- members, adding / How to do it...
- InvalidXMLCharacters property / There's more...
- IsAggregatable property / How it works...
- isolation property / There's more...
K
- KPI
- about / Defining key performance indicators, Getting ready
- defining / Defining key performance indicators, How to do it...
- creating / How to do it…, There's more…
L
- <Log><FlightRecorder><FileSizeMB> property / How it works...
- <Log><FlightRecorder><LogDurationSec> property / How it works...
- <Log><FlightRecorder><TraceDefinitionFile> property / How it works...
- <Log><QueryLog><QueryLogSampling> property / How it works...
- Local Cube / How to do it...
M
- <Memory><HardMemoryLimit> property / How it works...
- <Memory><PreAllocate> property / How it works...
- many-to-many dimension relationships
- performance considerations / Performance considerations for many-to-many dimension relationships
- many-to-many relationship / How to do it...
- Materialized Query Tables (MQT) / Working with non-SQL Server data sources
- MDX
- about / Introduction
- MDXMissingMemberMode property / Dimension properties
- MDX queries
- tuning / Monitoring and tuning MDX queries, How to do it...
- monitoring / Monitoring and tuning MDX queries, How to do it...
- MDX scripts functionality
- about / MDX script's functionality
- using / How to do it...
- MeasureExpression / There's more...
- measure expressions
- defining / Defining measure expressions, How to do it...
- measure groups
- defining / Defining measure groups and measures, How to do it...
- dimension usage / Dimension usage with measure group, How to do it...
- Measure Name property / How to do it…
- measure properties
- setting / How to do it..., There's more...
- aggregation function / There's more...
- Aggregation function / There's more...
- Data type / There's more...
- DisplayFolder / There's more...
- MeasureExpression / There's more...
- FormatString / There's more...
- Visible / There's more...
- Source / There's more...
- measures
- defining / Getting ready, How to do it...
- properties, measuring / Setting measure properties, How to do it..., There's more...
- creating / Creating measures
- AutoSum measures, creating / Creating AutoSum measures
- calculated measures, creating / Creating calculated measures
- Members tab / How to do it…
- MembersWithData property / How it works...
- Memory><LowMemoryLimit> property / How it works...
- model, Excel
- analyzing / How to do it…, There's more…
- Model, Excel
- testing / Testing a Tabular Model in Excel, Understanding Row Context, Understanding Filter Context
- Row Context / Understanding Row Context
- model design
- memory usage, managing / Managing memory usage
- Multi-Dimensional Expressions (MDX) / How it works...
- Multi-Dimensional OLAP (MOLAP) / Partition storage mode options
- MultiDimensional Expressions (MDX) / Choosing multidimensional or Tabular Models
- Multidimensional models
- choosing / Choosing multidimensional or Tabular Models
- requirements / Choosing multidimensional or Tabular Models
N
- NameColumn property / How to do it...
- named calculations
- named sets
- New Perspective button / How to do it…
- NextMember function / How to do it...
- NONEMPTY function / How to do it...
- NonLeafDataVisible property / How it works...
- nonSQL Server data sources
- working with / Working with non-SQL Server data sources
- SSAS data structures / SSAS data structures
- transaction isolation levels / Transaction isolation levels
- performance issues, processing / Processing performance issues
- NON_EMPTY_BEHAVIOR property / How to do it...
- No relationship / How to do it...
- normalizing (Snowflaking) / Star- or Snowflake-relational schema
- Notification event / How to do it...
- NullProcessing property / There's more...
O
- <OLAP><LazyProcessing><Enabled> property / How it works...
- <OLAP><LazyProcessing><MaxCPUUsage> property / How it works...
- Online Analytical Processing (OLAP) / How to do it...
- ORDER function / How to do it...
P
- <Port> property / How it works...
- <Process><BufferRecordLimit> property / How it works...
- <Process><IndexBuildThreshold> property / How it works...
- ParallelPeriod function / How to do it...
- parent-child dimensions
- partition
- processing, options / Dealing with partition processing options
- processing, steps / How to do it..., How it works...
- Partition Manager dialog / How to do it…
- partition processing, options
- ProcessClear / Dealing with partition processing options
- ProcessFull / Dealing with partition processing options
- ProcessAdd / Dealing with partition processing options
- ProcessData / Dealing with partition processing options
- ProcessIndexes / Dealing with partition processing options
- ProcessClearIndexes / Dealing with partition processing options
- ProcessDefault / Dealing with partition processing options
- partitions
- merging / Merging partitions, How to do it...
- partition slice
- defining / Defining partition slice, How to do it...
- Partitions option / There's more…
- performance issues
- diagnosing / Diagnosing performance issues
- query-related performance / Processing and query-related performance
- performance tools
- tools / Using performance tools
- Task Manager / Task Manager and Resource Monitor
- Resource Monitor / Task Manager and Resource Monitor
- Dynamic Management Views (DMVs) / Dynamic Management Views
- BISM server memory report / BISM server memory report
- performance tuning / Understanding usability limits
- PeriodsToDate function / How to do it...
- perspective / Returning data on the query axes
- perspectives
- defining / Defining perspectives
- implementing / Implementing perspectives, There's more…, See also
- Perspectives tab / How to do it...
- ProcessAdd option / How it works...
- Process Add option / How it works…
- ProcessClear option / How it works...
- Process Clear or Process Data option / How it works…
- ProcessData option / How it works...
- ProcessDefault option / How it works...
- Process Full option / Managing memory usage
- ProcessFull option / How it works...
- ProcessIndexes command / File is corrupted
- ProcessIndexes option / Defining aggregation designs, How it works...
- ProcessingGroup property / Dimension properties
- ProcessingMode property / There's more..., Dimension properties
- processing performance
- monitoring / Monitoring and tuning processing performance
- tuning / Monitoring and tuning processing performance
- PerfMon counters, collecting / How to do it...
- Process option / How to do it...
- ProcessUpdate option / How it works...
- Progress Report End event / How to do it...
Q
- queries
- Query End event / How to do it…
- query level calculations
- Query Log / Defining aggregation designs
- query output
- limiting / Limiting the query output, How to do it...
- sorting / Sorting the query output, How to do it...
- query performance
- investigating, with SQL Server Profiler / Investigating query performance with SQL Server Profiler, How to do it…, There's more…
- Query timeout property / There's more...
R
- referenced relationship / How to do it...
- regular relationship / How to do it...
- RELATED function / How to do it…
- Relational OLAP (ROLAP) / Partition storage mode options
- reporting actions
- defining / Defining reporting actions, How to do it...
- Reset Default button / How to do it...
- restore function / How it works...
- Reverse button / How to do it...
- Robocopy (Robust File Copy / How it works...
- Robocopy command / Detaching and attaching databases
- Role Manager dialog / How to do it…
- Row Filters tab / How to do it…
- Run Trace button / How to do it...
S
- <ServerTimeout> property / How it works...
- SAAS
- about / Introduction
- sales report
- creating, in Excel / How to do it…, There's more…
- scaling out / Introduction
- scaling up / Introduction
- script to new query window option / Defining aggregation designs
- security
- implementing, in Tabular Models / Implementing security in Tabular Models, Getting ready, How to do it…
- Select Creation Method dialog / How to do it...
- Select Tables and Views dialog / How to do it…
- server process identifier (SPID) / How to do it...
- session
- cancelling / Cancelling a session, How to do it...
- simple dimensions
- creating / Creating simple dimensions, How to do it..., How it works...
- snowflake schema
- about / Star- or Snowflake-relational schema
- selecting, scenario / A sample scenario for choosing the Snowflake schema
- Solid State Disk (SSD) / Monitoring and tuning processing performance
- Solution Explorer window / How to do it...
- Source / There's more...
- Source Type property / How to do it...
- SQL
- about / Introduction
- SQL Profiler / Monitoring and tuning MDX queries
- SQL Server Data Tools (SSDT)
- about / Introduction
- SQL Server Integration Services (SSIS) / Working with non-SQL Server data sources
- SQL Server Management Studio (SSMS) / SSAS instance configuration options, Getting ready
- SQL Server Profiler / How it works...
- using / Defining calculated measures
- used, for query performance investigation / Investigating query performance with SQL Server Profiler, How to do it…, There's more…
- SQL Server Reporting Services (SSRS) / Defining reporting actions
- SSAS / Introduction
- about / Introduction, Introduction
- instance configuration options / SSAS instance configuration options
- SSAS errors
- binding / Binding is too small
- attribute key not found / Attribute key cannot be found
- undefined column name / Undefined column name
- xyz column definition / DSV does not contain definition for an xyz column
- operation is cancelled / Operation is cancelled
- corrupted file / File is corrupted
- transport layer error / Error encountered in the transport layer
- unexpected exception / Internal error or unexpected exception
- deadlock / Deadlock
- SSAS instance
- monitoring, Activity Viewer used / Monitoring SSAS instance using Activity Viewer, How to do it..., How it works...
- monitoring, DMVs used / Monitoring SSAS instance using DMVs, How it works...
- SSAS instance settings
- modifying / How to do it..., How it works...
- configuration modifying, SSMS used / How to do it...
- SSAS object sizes
- checking, programmatically / Checking SSAS object sizes programmatically, How to do it..., There's more...
- SSAS solution, scaling / Scaling out SSAS solutions
- SSDT
- about / Introduction
- SSIS
- SSMS / Introduction
- star schema
- Status Indicator / How to do it...
- Storage Area Network (SAN) / Monitoring and tuning processing performance
- StorageMode property / Dimension properties
- strategies partitioning
- about / Partitioning strategies
- creating / How to do it...
- creating, through wizards / Creating partitions through the wizard
- creating, through AMO / Creating partitions through AMO
- storage mode options / Partition storage mode options
- StringStoresCompatibilityLevel option / Dimension properties
- StringStoresCompatibilityLevel property / Dimension properties
- StrToMember function / How to do it...
- SUMMARIZE function / How to do it…
- Synchronize command / How it works...
T
- <ThreadPool><IOProcess> property / How it works...
- table
- combining, calculated columns used / Getting ready, How to do it…, There's more…
- TABLE | Partitions option / How to do it…
- Tabular model
- choosing / Choosing multidimensional or Tabular Models
- requirements / Choosing multidimensional or Tabular Models
- Tabular Model
- creating / Creating a Tabular Model, How to do it…, There's more…
- security, implementing in / Implementing security in Tabular Models, How to do it…
- processing, automated method / Automating Tabular Model processing, There's more…
- querying / Querying a Tabular Model, Getting ready, How to do it…, There's more…, See also
- Tabular Model processing
- automating / Automating Tabular Model processing
- Tabular Models
- deploying / Getting ready, How to do it…, How it works…
- scripting, XMLA used / Getting ready
- processing / How to do it…, See also
- partitioning / Partitioning Tabular Models, How to do it…, There's more…
- Tabular models
- DirectQuery / DirectQuery with Tabular Models
- Test Connection button / How to do it...
- time dimension based
- creating / How to do it...
- time dimensions
- working with / Working with the Time dimensions, How to do it...
- Time Intelligence
- working with / Working with Time Intelligence
- TOPCOUNT function / How to do it...
- translations
- defining / Defining translations, How to do it...
- Translations tab / How to do it...
- Trend Indicator / How to do it...
- tuple / Introduction
U
- UnknownMemberName dimension property / Dimension properties
- UnknownMember property / Dimension properties
- URL actions
- defining / Defining URL actions, How to do it...
- usability limits
- about / Understanding usability limits
- Usage-based Optimization (UBO) wizard / Defining aggregation designs
V
- Visible / There's more...
- Visible property / How to do it...
- Visual Data Tools (VDT) / How to do it...
W
- What You See Is What You Get (WYSIWYG) / Working with data sources and loading data
- write-back feature
- enabling / Enabling write-back feature, How to do it...
- Writeback folder / How to do it...
X
- XMLA
- about / How it works...
- used, for Tabular Models scripting / Getting ready
- xVelocity In-Memory Analytics Engine / Managing memory usage
Z
- Zoom option / How to do it...