Index
A
- .asdatabase file
- actions
- about / Actions
- Add Business Intelligence wizard
- about / Time and date calculations
- advanced calculated measures
- creating, steps / Adding advanced calculated measures
- advanced calculations
- creating / Creating advanced calculations
- advanced deployment strategies
- used, for deplying projects / Deploying projects using advanced deployment strategies
- advanced Excel features
- about / Advanced Excel features
- named set / Named sets
- calculated measures / Calculated measures
- calculated members / Calculated members
- advanced processing options
- used, for processing cubes / Using advanced processing options when processing cubes
- Adventure Works
- URL, for info / An introduction to data warehousing
- Aggregation Design Wizard
- about / Running the aggregation wizard
- running / Running the aggregation wizard
- aggregations
- about / Aggregations
- adding, for performance improvement / Adding aggregations to improve performance
- testing / Running the aggregation wizard
- adding, manually / Adding aggregations manually
- ALTER TRACE privilege / Adding a ROLAP dimension to the FirstCube cube
- Analysis Services
- about / Understanding the BI semantic model architecture
- tool support / Tool support
- steps, for installation / Hands-on steps for installing Analysis Services
- steps, for attaching sample database / Hands-on steps for attaching the sample database
- objects, deploying to / Deploying objects to Analysis Services
- objects, processing / Processing objects in Analysis Services
- storage modes, configuring / Configuring storage modes in Analysis Services
- objects, securing / Securing objects in Analysis Services
- querying, Microsoft frontend tools used / Using Microsoft frontend tools to query Analysis Services
- Analysis Services 2012
- installing, in multidimensional mode / Installing Analysis Services 2012 in multidimensional mode
- Analysis Services Deployment Wizard
- Analysis Services Execute DDL task
- URL, for info / Adding partitions to the FirstCube cube
- analytical reporting
- anatomy, MDX query
- about / Understanding the anatomy of an MDX query
- FROM clause / The FROM clause
- WHERE clause / The WHERE clause
- query axis clause / The query axis clause
- aspects, development environment
- about / Navigating the project environment
- Solution Explorer / Solution Explorer
- Properties window / Properties window
- Build menu / Build menu
- ASSL
- about / Deploying objects to Analysis Services
- URL, for info / Deploying objects to Analysis Services
B
- bindings
- URL, for info / Understanding data sources
- BI Semantic model (BISM)
- budget solutions
- building, write-back used / Building budget solutions using writeback
- Build menu / Build menu
- business intelligence system
- user requisites / Identifying common user requirements for a BI system
C
- .configsettings file
- calculated columns
- about / Adding calculated columns to the tabular model
- adding, to tabular model / Adding calculated columns to the tabular model
- calculated measures
- about / Calculated measures, Adding measures
- creating, in tabular model / Creating calculated measures in the tabular model
- calculated members / Calculated members
- about / Calculated members
- calculations
- adding, to cubes / Adding calculations to cubes
- reviewing / Adding advanced calculated measures
- creating / Creating calculations
- Cognos
- about / Third-party tools
- columns
- specifying / Specifying other types of tables and columns
- hiding, from end users / Hiding columns and tables from the end users
- columnstore indexes
- concepts, MDX query
- unique names / Unique names
- tuples / Tuples
- sets / Sets
- calculated members / Calculated members
- named sets / Named sets
- functions / Functions
- connection
- creating, to database sources / Creating the data connection
- adding, to data source / Connecting to the data source
- cube
- creating / Creating the first cube
- Product dimension, adding / Creating additional dimensions and adding them to the cube
- calculations, adding to / Adding calculations to cubes
- optimizing, usage-based optimization used / Using usage-based optimization to optimize the cube
- querying, Reporting Services used / Using Reporting Services to query your cube
- cube project
- creating / Hands-on steps for creating your first cube project
- configuring, for deployment / Hands-on steps for configuring your cube project
- extending, with custom actions / Extending the cube with custom actions
- cubes
- processing, advanced processing options used / Using advanced processing options when processing cubes
- partitioning, for speeding up processing / Partitioning cubes to speed up processing
- custom actions
- cube, extending with / Extending the cube with custom actions
- custom assemblies
- about / Custom assemblies
- Customer Relationship Management (CRM) / Identifying common user requirements for a BI system
- custom rollups
- about / Custom rollups
- custom security roles
D
- .deploymentoptions file
- .deploymenttargets file
- Dashboard Designer
- data
- adding, from file / Adding data from other data sources
- sorting, based on columns / Sorting data based on other columns
- database permission
- administrator / Adding custom roles to the database
- Process database permission / Adding custom roles to the database
- Read definition permission / Adding custom roles to the database
- database sources
- connection, creating to / Creating the data connection
- data model
- tables, adding to / Adding tables to the data model
- data security
- implementing / Implementing data security
- testing / Testing data security
- data source
- connection, adding / Connecting to the data source
- data sources
- about / Understanding data sources
- using / Understanding data sources
- data source view
- about / Understanding the data source view
- creating / Creating a new data source view
- objects, adding to / Adding objects to the data source view
- extending / Extending the data source view
- data warehouse
- Date dimension
- creating, steps / Creating the Date dimension
- preparing, for end users / Preparing the Date dimension for end users
- atribuites, renaming / Renaming attributes
- hierarchy, creating / Creating a hierarchy and attribute relationships
- attribute relationships, creating / Creating a hierarchy and attribute relationships
- processing, for review results / Processing the dimension to review the results
- DAX / Querying tabular models
- DAX (Data Analysis Expressions) / Choosing the deployment mode
- DBO (Database owner) / Using usage-based optimization to optimize the cube
- deployment mode
- selecting / Choosing the deployment mode
- developer-focused tools
- about / Developer-focused tools
- dimensional model
- dimensions
- about / Understanding dimensions, Adding dimensions to the FirstCube project
- URL, for info / Understanding dimensions
- adding, to FirstCube project / Adding dimensions to the FirstCube project
- adding, with parent-child hierarchies / Adding dimensions with parent-child hierarchies
- dimension security
- adding, to FirstCube project / Adding dimension security to the FirstCube project
- DirectQuery partitions / Working with partitions in tabular models
- distinct count
- about / Distinct count
- dynamic data security
- implementing / Implementing dynamic data security
- about / Implementing dynamic data security
E
- end users
- columns, hiding from / Hiding columns and tables from the end users
- tables, hiding from / Hiding columns and tables from the end users
- Enterprise Resource Planning (ERP) / Identifying common user requirements for a BI system
- Excel / Understanding the BI semantic model architecture, Building budget solutions using writeback
- using, as query tool / Using Excel as the query tool against cubes
- connecting, to FirstCube cube / Connecting Excel to the FirstCube cube
- named set, creating / Named sets
- PivotTable, creating / Time and date calculations
- about / Using Excel as a self-service tool against Analysis Services cubes
- benefits / Using Excel as a self-service tool against Analysis Services cubes
- using, as self-service tool / Using Excel as a self-service tool against Analysis Services cubes
- Excel PowerPivot
F
- Fact Internet Sales cube
- creating / Creating the Fact Internet Sales cube
- fact table
- FirstCube cube
- partitions, adding to / Adding partitions to the FirstCube cube
- ROLAP dimension, adding to / Adding a ROLAP dimension to the FirstCube cube
- Excel, connecting to / Connecting Excel to the FirstCube cube
- FirstCube project
- deploying, to server / Deploying the FirstCube project to the server
- processing / Processing the FirstCube project
- dimensions, adding to / Adding dimensions to the FirstCube project
- fixed server role
- users, adding / Adding users to the fixed server role
- flexible reporting solution
- creating / Creating a flexible reporting solution
- FROM clause / The FROM clause
- functions / Functions
H
- hierarchies
- creating / Adding hierarchies
- HIERARCHIZE function / Connecting Excel to the FirstCube cube
- HOLAP
- about / HOLAP
I
- Import from PowerPivot option
- about / Creating a tabular mode project
- Import from Server (Tabular) option
- about / Creating a tabular mode project
- in-memory model
- security, adding to / Adding security to your in-memory model
- indexed view feature
- Inherit option
- about / Understanding data sources
- Inmon data warehouse
- installation, tabular mode instance / Installing a tabular mode instance
- Integrated Development Environment (IDE) / Starting SQL Server Data Tools for the first time
K
- KPI
- about / Key Performance Indicators
- adding, steps / Key Performance Indicators
- creating / KPIs
L
- Lag function
- about / Functions
- linked objects
- about / Linked objects
- local cube
- URL, for info / Understanding data sources
M
- Management Studio
- used, for writing MDX queries / Writing MDX queries using Management Studio
- used, for connection to cube / Connecting to the cube using Management Studio
- many-to-many dimensions
- about / Adding many-to-many dimensions
- adding / Adding many-to-many dimensions
- many-to-many relationships
- about / Many-to-many relationships
- MDX (Multidimensional Expressions) / Choosing the deployment mode
- MDX queries
- writing, Management Studio used / Writing MDX queries using Management Studio
- MDX query
- measure groups
- adding, steps / Adding additional measure groups
- measures
- about / Understanding multidimensionality, Adding measures
- adding, steps / Adding measures
- Microsoft / Tool support
- Microsoft Excel
- Microsoft frontend tools
- used, for querying Analysis Services / Using Microsoft frontend tools to query Analysis Services
- MicroStrategy
- about / Third-party tools
- MOLAP
- about / MOLAP
- drawbacks / Proactive caching
- MSDN (Microsoft Developer Network) / Tool support
- multidimensionality
- multidimensional mode
- Analysis Services 2012, installing in / Installing Analysis Services 2012 in multidimensional mode
- multidimensional model
- versus tabular model / Choosing the deployment mode
- actions / Actions
- aggregations / Aggregations
- custom assemblies / Custom assemblies
- custom rollups / Custom rollups
- distinct count / Distinct count
- linked objects / Linked objects
- many-to-many relationships / Many-to-many relationships
- parent-child hierarchies / Parent-child hierarchies
- translations / Translations
- Writeback / Writeback
N
- 3NF
- named set
- creating, in Excel / Named sets
- creating, steps / Adding calculated members
- named sets / Named sets
O
- objects
- adding, to data source view / Adding objects to the data source view
- deploying, to Analysis Services / Deploying objects to Analysis Services
- processing, in Analysis Services / Processing objects in Analysis Services
- OLAP engines / Understanding data sources
- OLAP model
- OLEDB
- about / Understanding data sources
- ON COLUMNS keyword
- Online Transaction Processing (OLTP)
P
- Panorama
- about / Third-party tools
- parent-child hierarchies
- about / Parent-child hierarchies
- dimensions, adding with / Adding dimensions with parent-child hierarchies
- parent-child hierarchy
- partitions
- adding, to FirstCube cube / Adding partitions to the FirstCube cube
- about / Working with partitions in tabular models
- working with / Working with partitions in tabular models
- performance
- tabular mode, optimizing for / Optimizing the tabular model for performance
- perspective
- about / Adding perspectives to simplify cube browsing
- creating, steps / Adding perspectives to simplify cube browsing
- perspectives
- adding, for cube browsing simplification / Adding perspectives to simplify cube browsing
- about / Creating perspectives
- creating / Creating perspectives
- PivotTable
- creating, in Excel / Time and date calculations
- PivotTables / Understanding the BI semantic model architecture
- PowerPivot
- Power View / Tool support
- proactive caching
- about / Proactive caching
- ProcessClear command / Processing objects in Analysis Services
- ProcessFull command / Processing objects in Analysis Services
- ProcessIndex command / Processing objects in Analysis Services
- processing errors
- troubleshooting / Troubleshooting processing errors
- Product dimension
- project
- selecting, for multidimensional model / Choosing the correct project
- project environment
- navigating / Navigating the project environment
- projects
- deploying, advanced deployment strategies used / Deploying projects using advanced deployment strategies
- Properties window / Properties window
Q
- query axis clause
- about / The query axis clause
R
- .rdl files
- ragged hierarchy / Adding dimensions with parent-child hierarchies
- referenced dimensions
- adding / Adding referenced dimensions
- about / Adding referenced dimensions
- Report Builder
- Reporting Services
- about / Using Reporting Services together with your cube
- using, with cube / Using Reporting Services together with your cube
- used, for querying cube / Using Reporting Services to query your cube
- ROLAP
- about / ROLAP
- ROLAP dimension
- adding, to FirstCube cube / Adding a ROLAP dimension to the FirstCube cube
- role
- role-based security
- role-playing dimension / Understanding dimensions
- rowset action
S
- schedule processing
- about / Scheduling processing
- performing, of cube / Building a SSIS package to control processing
- security
- adding, to in-memory model / Adding security to your in-memory model
- security, Analysis Services
- database security / Securing objects in Analysis Services
- dimension security, adding to FirstCube project / Adding dimension security to the FirstCube project
- measures, securing / Securing measures
- data security, implementing / Implementing data security
- data security, testing / Testing data security
- Visual Totals, enabling / Enable Visual Totals to restrict what a user can see
- testing, when selecting several roles / Understanding security when a user belongs to several roles
- dynamic data security, implementing / Implementing dynamic data security
- SELECT statement
- self-service reporting
- user value, obtaining through / Getting user value through self-service reporting
- self-service tools / Self-service tools
- server
- FirstCube project, deploying to / Deploying the FirstCube project to the server
- set
- about / Sets
- SharePoint
- about / Understanding tabular models
- SharePoint Excel Services
- about / SharePoint Excel Services
- SharePoint PerformancePoint Services / SharePoint PerformancePoint Services
- simple calculated measure
- creating, steps / Simple calculated measures
- simple calculated member
- creating, steps / Adding calculated members
- snowflake schema / Creating a new data source view
- Solution Explorer / Solution Explorer
- SQL Server 2012 SP1 / Deploying objects to Analysis Services
- SQL Server Analysis Services
- SQL Server Data Tools
- SSIS package
- star schema
- storage modes
- configuring, in Analysis Services / Configuring storage modes in Analysis Services
- MOLAP / MOLAP
- ROLAP / ROLAP
- HOLAP / HOLAP
- subscriptions
- surrogate keys / Creating the Date dimension
- Synchronize command / Deploying projects using advanced deployment strategies
T
- T-SQL / Adding objects to the data source view
- tables
- adding, to data model / Adding tables to the data model
- specifying / Specifying other types of tables and columns
- hiding, from end users / Hiding columns and tables from the end users
- tabular mode
- optimizing, for performance / Optimizing the tabular model for performance
- tabular mode instance
- installing / Installing a tabular mode instance
- tabular model
- about / Understanding the BI semantic model architecture
- versus multidimensional model / Choosing the deployment mode
- dstinct count / Distinct count
- parent-child hierarchies / Parent-child hierarchies
- calculated columns, adding to / Adding calculated columns to the tabular model
- calculated measures, creating / Creating calculated measures in the tabular model
- tabular models
- about / Understanding tabular models
- querying / Querying tabular models
- tabular mode project
- creating / Creating a tabular mode project
- time calculations
- using / Time and date calculations
- Time dimension
- Time Intelligence wizard
- about / Time and date calculations
- drawback / Time and date calculations
- tool support, Analysis Services / Tool support
- translations
- about / Translations
- adding, for global implementations support / Adding translations to support global implementations
- creating, steps / Adding translations to support global implementations
- tuples / Tuples
U
- UNIQUENAME function
- about / Functions
- unique names
- about / Unique names
- searching, of objects / Finding unique names of objects
- usage-based optimization
- used, for optimizing cube / Using usage-based optimization to optimize the cube
- users
- adding, to fixed server role / Adding users to the fixed server role
- user value
- obtaining, through self-service reporting / Getting user value through self-service reporting
V
- Visual Totals
W
- WHERE clause / The WHERE clause
- workspace server
- defining / Defining the workspace server
- write-back
- used, for building budget solutions / Building budget solutions using writeback
- about / Building budget solutions using writeback
- Writeback feature
- about / Writeback
X
- XMLA
- about / Deploying objects to Analysis Services
- URL, for info / Deploying objects to Analysis Services
- xVelocity in-memory analytical engine / Understanding tabular models