- name: SQL Server ++

href: ../sql-server/sql-server-technical-documentation.md?toc=..%2ftoc%2ftoc.json

- name: About SQL Server Analysis Services

href: ../analysis-services/analysis-services.md

- name: Overview

items:

- name: What's new in SQL Server Analysis Services 2016

href: ../analysis-services/what-s-new-in-analysis-services.md

- name: What's new in SQL Server Analysis Services 2017

href: ../analysis-services/what-s-new-in-sql-server-analysis-services-2017.md

- name: Tools and applications

href: ../analysis-services/tools-and-applications-used-in-analysis-services.md

- name: Comparing Tabular and Multidimensional solutions

href: ../analysis-services/comparing-tabular-and-multidimensional-solutions-ssas.md

- name: Analysis Services Features and Tasks

href: ../analysis-services/analysis-services-features-and-tasks.md

- name: Analysis Services features supported by SQL Server editions

href: ../analysis-services/analysis-services-features-supported-by-the-editions-of-sql-server-2016.md

- name: Backward compatibility (SQL Server 2016 Analysis Services)

href: ../analysis-services/analysis-services-backward-compatibility.md

- name: Backward compatibility (SQL Server 2017 Analysis Services)

href: ../analysis-services/analysis-services-backward-compatibility-sql2017.md

- name: Globalization and translation

href: ../analysis-services/globalization-scenarios-for-analysis-services.md

items:

- name: Languages and collations

href: ../analysis-services/languages-and-collations-analysis-services.md

- name: Translations

href: ../analysis-services/translation-support-in-analysis-services.md

- name: Currency conversions

href: ../analysis-services/currency-conversions-analysis-services.md

- name: Tips and best practices

href: ../analysis-services/globalization-tips-and-best-practices-analysis-services.md

- name: Tutorials

items:

- name: Analysis Services tutorials overview

href: ../analysis-services/analysis-services-tutorials-ssas.md

- name: Tabular modeling (1400 compatibility level)

href: ../analysis-services/tutorial-tabular-1400/as-adventure-works-tutorial.md

items:

- name: 1 - Create a tabular model project

href: ../analysis-services/tutorial-tabular-1400/as-lesson-1-create-a-new-tabular-model-project.md

- name: 2 - Get data

href: ../analysis-services/tutorial-tabular-1400/as-lesson-2-get-data.md

- name: 3 - Mark as Date Table

href: ../analysis-services/tutorial-tabular-1400/as-lesson-3-mark-as-date-table.md

- name: 4 - Create relationships

href: ../analysis-services/tutorial-tabular-1400/as-lesson-4-create-relationships.md

- name: 5 - Create calculated columns

href: ../analysis-services/tutorial-tabular-1400/as-lesson-5-create-calculated-columns.md

- name: 6 - Create measures

href: ../analysis-services/tutorial-tabular-1400/as-lesson-6-create-measures.md

- name: 7 - Create Key Performance Indicators

href: ../analysis-services/tutorial-tabular-1400/as-lesson-7-create-key-performance-indicators.md

- name: 8 - Create perspectives

href: ../analysis-services/tutorial-tabular-1400/as-lesson-8-create-perspectives.md

- name: 9 - Create hierarchies

href: ../analysis-services/tutorial-tabular-1400/as-lesson-9-create-hierarchies.md

- name: 10 - Create partitions

href: ../analysis-services/tutorial-tabular-1400/as-lesson-10-create-partitions.md

- name: 11 - Create roles

href: ../analysis-services/tutorial-tabular-1400/as-lesson-11-create-roles.md

- name: 12 - Analyze in Excel

href: ../analysis-services/tutorial-tabular-1400/as-lesson-12-analyze-in-excel.md

- name: 13 - Deploy

href: ../analysis-services/tutorial-tabular-1400/as-lesson-13-deploy.md

- name: Supplemental lesson - Detail Rows

href: ../analysis-services/tutorial-tabular-1400/as-supplemental-lesson-detail-rows.md

- name: Supplemental lesson - Dynamic security

href: ../analysis-services/tutorial-tabular-1400/as-supplemental-lesson-dynamic-security.md

- name: Supplemental lesson - Ragged hierarchies

href: ../analysis-services/tutorial-tabular-1400/as-supplemental-lesson-ragged-hierarchies.md

- name: Tabular modeling (1200 compatibility level)

href: ../analysis-services/tabular-modeling-adventure-works-tutorial.md

items:

- name: 1 - Create a New Tabular Model Project

href: ../analysis-services/lesson-1-create-a-new-tabular-model-project.md

- name: 2 - Add Data

href: ../analysis-services/lesson-2-add-data.md

- name: 3 - Mark as Date Table

href: ../analysis-services/lesson-3-mark-as-date-table.md

- name: 4 - Create relationships

href: ../analysis-services/lesson-4-create-relationships.md

- name: 5 - Create calculated columns

href: ../analysis-services/lesson-5-create-calculated-columns.md

- name: 6 - Create measures

href: ../analysis-services/lesson-6-create-measures.md

- name: 7 - Create Key Performance Indicators

href: ../analysis-services/lesson-7-create-key-performance-indicators.md

- name: 8 - Create perspectives

href: ../analysis-services/lesson-8-create-perspectives.md

- name: 9 - Create hierarchies

href: ../analysis-services/lesson-9-create-hierarchies.md

- name: 10 - Create partitions

href: ../analysis-services/lesson-10-create-partitions.md

- name: 11 - Create roles

href: ../analysis-services/lesson-11-create-roles.md

- name: 12 - Analyze in Excel

href: ../analysis-services/lesson-12-analyze-in-excel.md

- name: 13 - Deploy

href: ../analysis-services/lesson-13-deploy.md

- name: Supplemental Lesson - Implement dynamic security by using row filters

href: ../analysis-services/supplemental-lesson-implement-dynamic-security-by-using-row-filters.md

- name: Supplemental Lesson - Configure reporting properties for Power View reports

href: ../analysis-services/supplemental-lesson-configure-reporting-properties-for-power-view-reports.md

- name: Multidimensional modeling

href: ../analysis-services/multidimensional-modeling-adventure-works-tutorial.md

items:

- name: Tutorial scenario

href: ../analysis-services/analysis-services-tutorial-scenario.md

- name: Install sample data and projects for the Analysis Services Multidimensional modeling tutorial

href: ../analysis-services/install-sample-data-and-projects.md

- name: "Lesson 1: Defining a data source view within an Analysis Services project"

href: ../analysis-services/lesson-1-defining-a-data-source-view-within-an-analysis-services-project.md

items:

- name: Lesson 1-1 - Creating an Analysis Services project

href: ../analysis-services/lesson-1-1-creating-an-analysis-services-project.md

- name: Lesson 1-2 - Defining a data source

href: ../analysis-services/lesson-1-2-defining-a-data-source.md

- name: Lesson 1-3 - Defining a data source view

href: ../analysis-services/lesson-1-3-defining-a-data-source-view.md

- name: Lesson 1-4 - Modifying default table names

href: ../analysis-services/lesson-1-4-modifying-default-table-names.md

- name: "Lesson 2: Defining and deploying a cube"

href: ../analysis-services/lesson-2-defining-and-deploying-a-cube.md

items:

- name: Lesson 2-1 - Defining a dimension

href: ../analysis-services/lesson-2-1-defining-a-dimension.md

- name: Lesson 2-2 - Defining a cube

href: ../analysis-services/lesson-2-2-defining-a-cube.md

- name: Lesson 2-3 - Adding attributes to dimensions

href: ../analysis-services/lesson-2-3-adding-attributes-to-dimensions.md

- name: Lesson 2-4 - Reviewing cube and dimension properties

href: ../analysis-services/lesson-2-4-reviewing-cube-and-dimension-properties.md

- name: Lesson 2-5 - Deploying an Analysis Services project

href: ../analysis-services/lesson-2-5-deploying-an-analysis-services-project.md

- name: Lesson 2-6 - Browsing the cube

href: ../analysis-services/lesson-2-6-browsing-the-cube.md

- name: "Lesson 3: Modifying measures, attributes and hierarchies"

href: ../analysis-services/lesson-3-modifying-measures-attributes-and-hierarchies.md

items:

- name: Lesson 3-1 - Modifying measures

href: ../analysis-services/lesson-3-1-modifying-measures.md

- name: Lesson 3-2 - Modifying the customer dimension

href: ../analysis-services/lesson-3-2-modifying-the-customer-dimension.md

- name: Lesson 3-3 - Modifying the product dimension

href: ../analysis-services/lesson-3-3-modifying-the-product-dimension.md

- name: Lesson 3-4 - Modifying the date dimension

href: ../analysis-services/lesson-3-4-modifying-the-date-dimension.md

- name: Lesson 3-5 - Browsing the deployed cube

href: ../analysis-services/lesson-3-5-browsing-the-deployed-cube.md

- name: "Lesson 4: Defining advanced attribute and dimension properties"

href: ../analysis-services/lesson-4-defining-advanced-attribute-and-dimension-properties.md

items:

- name: Lesson 4-1 - Using a modified version of the Analysis Services tutorial project

href: ../analysis-services/lesson-4-1-using-a-modified-version-of-the-analysis-services-tutorial-project.md

- name: Lesson 4-2 - Defining parent attribute properties in a parent-child hierarchy

href: ../analysis-services/lesson-4-2-defining-parent-attribute-properties-in-a-parent-child-hierarchy.md

- name: Lesson 4-3 - Automatically grouping attribute members

href: ../analysis-services/lesson-4-3-automatically-grouping-attribute-members.md

- name: Lesson 4-4 - Hiding and disabling attribute hierarchies

href: ../analysis-services/lesson-4-4-hiding-and-disabling-attribute-hierarchies.md

- name: Lesson 4-5 - Sorting attribute members based on a secondary attribute

href: ../analysis-services/lesson-4-5-sorting-attribute-members-based-on-a-secondary-attribute.md

- name: Lesson 4-6 - Specifying attribute relationships between attributes in a user-defined hierarchy

href: ../analysis-services/lesson-4-6-specifying-attribute-relationships-in-user-defined-hierarchy.md

- name: Lesson 4-7 - Defining the unknown member and null processing properties

href: ../analysis-services/lesson-4-7-defining-the-unknown-member-and-null-processing-properties.md

- name: "Lesson 5: Defining relationships between dimensions and measure groups"

href: ../analysis-services/lesson-5-defining-relationships-between-dimensions-and-measure-groups.md

items:

- name: Lesson 5-1 - Defining a referenced relationship

href: ../analysis-services/lesson-5-1-defining-a-referenced-relationship.md

- name: Lesson 5-2 - Defining a fact relationship

href: ../analysis-services/lesson-5-2-defining-a-fact-relationship.md

- name: Lesson 5-3 - Defining a many-to-many relationship

href: ../analysis-services/lesson-5-3-defining-a-many-to-many-relationship.md

- name: Lesson 5-4 - Defining dimension granularity within a measure group

href: ../analysis-services/lesson-5-4-defining-dimension-granularity-within-a-measure-group.md

- name: "Lesson 6: Defining calculations"

href: ../analysis-services/lesson-6-defining-calculations.md

items:

- name: Lesson 6-1 - Defining calculated members

href: ../analysis-services/lesson-6-1-defining-calculated-members.md

- name: Lesson 6-2 - Defining named sets

href: ../analysis-services/lesson-6-2-defining-named-sets.md

- name: "Lesson 7: Defining Key Performance Indicators (KPIs)"

href: ../analysis-services/lesson-7-defining-key-performance-indicators-kpis.md

items:

- name: Lesson 7-1 - Defining and browsing KPIs

href: ../analysis-services/lesson-7-1-defining-and-browsing-kpis.md

- name: "Lesson 8: Defining actions"

href: ../analysis-services/lesson-8-defining-actions.md

items:

- name: Lesson 8-1 - Defining and using a drillthrough action

href: ../analysis-services/lesson-8-1-defining-and-using-a-drillthrough-action.md

- name: "Lesson 9: Defining perspectives and translations"

href: ../analysis-services/lesson-9-defining-perspectives-and-translations.md

items:

- name: Lesson 9-1 - Defining and browsing perspectives

href: ../analysis-services/lesson-9-1-defining-and-browsing-perspectives.md

- name: Lesson 9-2 - Defining and browsing translations

href: ../analysis-services/lesson-9-2-defining-and-browsing-translations.md

- name: "Lesson 10: Defining administrative roles"

href: ../analysis-services/lesson-10-defining-administrative-roles.md

items:

- name: Lesson 10 - Granting process database permissions

href: ../analysis-services/lesson-10-granting-process-database-permissions.md

- name: Data Mining

href: ../analysis-services/data-mining-tutorials-analysis-services.md

- name: How-to

items:

- name: Install and configure

items:

- name: Overview

href: ../analysis-services/instances/install-windows/install-analysis-services.md

- name: Install Analysis Services in Power Pivot Mode

href: ../analysis-services/instances/install-windows/install-analysis-services-in-power-pivot-mode.md

items:

- name: Verify a Power Pivot for SharePoint Installation

href: ../analysis-services/instances/install-windows/verify-a-power-pivot-for-sharepoint-installation.md

- name: Example of a Minimum-Privilege Configuration for Power Pivot for SharePoint 2016

href: ../analysis-services/instances/install-windows/power-pivot-minimum-privilege-example-sharepoint-2016.md

- name: Example of a Minimum-Privilege Configuration for Power Pivot for SharePoint 2013

href: ../analysis-services/instances/install-windows/power-pivot-minimum-privilege-example-sharepoint-2013.md

- name: Install or Uninstall the Power Pivot for SharePoint Add-in (SharePoint 2016)

href: ../analysis-services/instances/install-windows/install-or-uninstall-the-power-pivot-for-sharepoint-add-in-sharepoint-2016.md

- name: Install or Uninstall the Power Pivot for SharePoint Add-in (SharePoint 2013)

href: ../analysis-services/instances/install-windows/install-or-uninstall-the-power-pivot-for-sharepoint-add-in-sharepoint-2013.md

- name: Configure Power Pivot and Deploy Solutions (SharePoint 2016)

href: ../analysis-services/instances/install-windows/configure-power-pivot-and-deploy-solutions-sharepoint-2016.md

- name: Configure Power Pivot and Deploy Solutions (SharePoint 2013)

href: ../analysis-services/instances/install-windows/configure-power-pivot-and-deploy-solutions-sharepoint-2013.md

- name: Migrate Power Pivot to SharePoint 2013

href: ../analysis-services/instances/install-windows/migrate-power-pivot-to-sharepoint-2013.md

- name: Upgrade Workbooks and Scheduled Data Refresh (SharePoint 2013)

href: ../analysis-services/instances/install-windows/upgrade-workbooks-and-scheduled-data-refresh-sharepoint-2013.md

- name: Configure Analysis Services and Kerberos Constrained Delegation (KCD)

href: ../analysis-services/instances/install-windows/configure-analysis-services-and-kerberos-constrained-delegation-kcd.md

- name: "CheckList: Use PowerShell to Verify Power Pivot for SharePoint"

href: ../analysis-services/instances/install-windows/checklist-use-powershell-to-verify-power-pivot-for-sharepoint.md

- name: Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016

href: ../analysis-services/instances/install-windows/deploying-sql-server-2016-powerpivot-and-power-view-in-sharepoint-2016.md

- name: Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm

href: ../analysis-services/instances/install-windows/deploy-powerpivot-and-power-view-multi-tier-sharepoint-2016-farm.md

- name: Verify cumulative update build version

href: ../analysis-services/instances/analysis-services-component-version.md

- name: Post-install configuration

items:

- name: Post install and configuration overview

href: ../analysis-services/instances/post-install-configuration-analysis-services.md

- name: Configure the Windows Firewall

href: ../analysis-services/instances/configure-the-windows-firewall-to-allow-analysis-services-access.md

- name: Configure the service account

href: ../analysis-services/instances/configure-service-accounts-analysis-services.md

- name: Add administrators

href: ../analysis-services/instances/grant-server-admin-rights-to-an-analysis-services-instance.md

- name: Features off by default

href: ../analysis-services/instances/features-off-by-default-analysis-services.md

- name: Server groups in SSMS

href: ../analysis-services/instances/register-an-analysis-services-instance-in-a-server-group.md

- name: Determine the Server Mode

href: ../analysis-services/instances/determine-the-server-mode-of-an-analysis-services-instance.md

- name: Rename an Analysis Services Instance

href: ../analysis-services/instances/rename-an-analysis-services-instance.md

- name: Tabular modeling

items:

- name: Tabular modeling overview

href: ../analysis-services/tabular-models/tabular-models-ssas.md

- name: Compatibility level

href: ../analysis-services/tabular-models/compatibility-level-for-tabular-models-in-analysis-services.md

- name: Create Tabular Models

items:

- name: Tabular model designer

href: ../analysis-services/tabular-models/tabular-model-designer-ssas.md

- name: Workspace database

href: ../analysis-services/tabular-models/workspace-database-ssas-tabular.md

- name: Tabular Model Projects

href: ../analysis-services/tabular-models/tabular-model-projects-ssas-tabular.md

items:

- name: Create a New Tabular Model Project

href: ../analysis-services/tabular-models/create-a-new-tabular-model-project-analysis-services.md

- name: Import from Analysis Services

href: ../analysis-services/tabular-models/import-from-analysis-services-ssas-tabular.md

- name: Import from Power Pivot

href: ../analysis-services/tabular-models/import-from-power-pivot-ssas-tabular.md

- name: Properties

items:

- name: Power View - Reporting Properties

href: ../analysis-services/tabular-models/power-view-reporting-properties-ssas-tabular.md

- name: Power View - Configure Default Field Set

href: ../analysis-services/tabular-models/power-view-configure-default-field-set-for-reports.md

- name: Power View - Configure Table Behavior Properties

href: ../analysis-services/tabular-models/power-view-configure-table-behavior-properties-for-reports.md

- name: Project properties

href: ../analysis-services/tabular-models/project-properties-ssas-tabular.md

- name: Model properties

href: ../analysis-services/tabular-models/model-properties-ssas-tabular.md

- name: Table Properties

href: ../analysis-services/tabular-models/table-properties-ssas-tabular.md

- name: Column Properties

href: ../analysis-services/tabular-models/column-properties-ssas-tabular.md

- name: Configure default data modeling and deployment properties

href: ../analysis-services/tabular-models/configure-default-data-modeling-and-deployment-properties-ssas-tabular.md

- name: Import Data

items:

- name: Data sources supported in tabular 1400 models

href: ../analysis-services/tabular-models/data-sources-supported-ssas-tabular-1400.md

- name: Data sources supported in tabular 1200 models

href: ../analysis-services/tabular-models/data-sources-supported-ssas-tabular.md

- name: Data types supported

href: ../analysis-services/tabular-models/data-types-supported-ssas-tabular.md

- name: Impersonation

href: ../analysis-services/tabular-models/impersonation-ssas-tabular.md

- name: Import data by using a native query

href: ../analysis-services/tabular-models/ssas-import-query.md

- name: DirectQuery Mode

href: ../analysis-services/tabular-models/directquery-mode-ssas-tabular.md

items:

- name: Enable DirectQuery mode in SSDT

href: ../analysis-services/tabular-models/enable-directquery-mode-in-ssdt.md

- name: Enable DirectQuery mode in SSMS

href: ../analysis-services/tabular-models/enable-directquery-mode-in-ssms.md

- name: Add sample data to DirectQuery models

href: ../analysis-services/tabular-models/add-sample-data-to-a-directquery-model-in-design-mode.md

- name: Define partitions in DirectQuery models

href: ../analysis-services/tabular-models/define-partitions-in-directquery-models-ssas-tabular.md

- name: Test a model in DirectQuery mode

href: ../analysis-services/tabular-models/test-a-model-in-directquery-mode.md

- name: DAX formula compatibility in DirectQuery mode (SSAS 2016)

href: ../analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016.md

- name: Tables and Columns

href: ../analysis-services/tabular-models/tables-and-columns-ssas-tabular.md

items:

- name: Add columns to a table

href: ../analysis-services/tabular-models/add-columns-to-a-table-ssas-tabular.md

- name: Delete a Column

href: ../analysis-services/tabular-models/delete-a-column-ssas-tabular.md

- name: Change table, column, or row filter mappings

href: ../analysis-services/tabular-models/change-table-column-or-row-filter-mappings-ssas-tabular.md

- name: Specify Mark as Date Table for use with Time Intelligence

href: ../analysis-services/tabular-models/specify-mark-as-date-table-for-use-with-time-intelligence-ssas-tabular.md

- name: Add a table

href: ../analysis-services/tabular-models/add-a-table-ssas-tabular.md

- name: Delete a Table

href: ../analysis-services/tabular-models/delete-a-table-ssas-tabular.md

- name: Create a Calculated Table

href: ../analysis-services/tabular-models/create-a-calculated-table-ssas-tabular.md

- name: Rename a Table or Column

href: ../analysis-services/tabular-models/rename-a-table-or-column-ssas-tabular.md

- name: Set the Data Type of a Column

href: ../analysis-services/tabular-models/set-the-data-type-of-a-column-ssas-tabular.md

- name: Hide or freeze columns

href: ../analysis-services/tabular-models/hide-or-freeze-columns-ssas-tabular.md

- name: Calculated Columns

href: ../analysis-services/tabular-models/ssas-calculated-columns.md

- name: Create a Calculated Column

href: ../analysis-services/tabular-models/ssas-calculated-columns-create-a-calculated-column.md

- name: Sort Data in a Table

href: ../analysis-services/tabular-models/sort-data-in-a-table-ssas-tabular.md

- name: Filter Data in a Table

href: ../analysis-services/tabular-models/filter-data-in-a-table-ssas-tabular.md

- name: Relationships

href: ../analysis-services/tabular-models/relationships-ssas-tabular.md

items:

- name: Create a Relationship Between Two Tables

href: ../analysis-services/tabular-models/create-a-relationship-between-two-tables-ssas-tabular.md

- name: Delete Relationships

href: ../analysis-services/tabular-models/delete-relationships-ssas-tabular.md

- name: Bi-directional cross filters

href: ../analysis-services/tabular-models/bi-directional-cross-filters-tabular-models-analysis-services.md

- name: Calculations

href: ../analysis-services/tabular-models/calculations-ssas-tabular.md

items:

- name: Understanding DAX in Tabular Models

href: ../analysis-services/tabular-models/understanding-dax-in-tabular-models-ssas-tabular.md

- name: Measures

href: ../analysis-services/tabular-models/measures-ssas-tabular.md

items:

- name: Create and Manage Measures

href: ../analysis-services/tabular-models/create-and-manage-measures-ssas-tabular.md

- name: KPIs

href: ../analysis-services/tabular-models/kpis-ssas-tabular.md

items:

- name: Create and Manage KPIs

href: ../analysis-services/tabular-models/create-and-manage-kpis-ssas-tabular.md

- name: Hierarchies

href: ../analysis-services/tabular-models/hierarchies-ssas-tabular.md

items:

- name: Create and Manage Hierarchies

href: ../analysis-services/tabular-models/create-and-manage-hierarchies-ssas-tabular.md

- name: Partitions

href: ../analysis-services/tabular-models/partitions-ssas-tabular.md

items:

- name: Create and Manage Partitions in the Workspace Database

href: ../analysis-services/tabular-models/create-and-manage-partitions-in-the-workspace-database-ssas-tabular.md

- name: Process Partitions in the Workspace Database

href: ../analysis-services/tabular-models/process-partitions-in-the-workspace-database-ssas-tabular.md

- name: Perspectives

href: ../analysis-services/tabular-models/perspectives-ssas-tabular.md

items:

- name: Create and Manage Perspectives

href: ../analysis-services/tabular-models/create-and-manage-perspectives-ssas-tabular.md

- name: Translations

href: ../analysis-services/tabular-models/translations-in-tabular-models-analysis-services.md

- name: Roles

href: ../analysis-services/tabular-models/roles-ssas-tabular.md

items:

- name: Create and Manage Roles

href: ../analysis-services/tabular-models/create-and-manage-roles-ssas-tabular.md

- name: Object-level security

href: ../analysis-services/tabular-models/object-level-security.md

- name: Analyze in Excel

href: ../analysis-services/tabular-models/analyze-in-excel-ssas-tabular.md

items:

- name: Analyze a tabular model in Excel

href: ../analysis-services/tabular-models/analyze-a-tabular-model-in-excel-ssas-tabular.md

- name: String storage and collation in tabular models

href: ../analysis-services/tabular-models/string-storage-and-collation-in-tabular-models.md

- name: Deploy tabular model solutions

href: ../analysis-services/tabular-models/tabular-model-solution-deployment-ssas-tabular.md

items:

- name: Deploy from SQL Server Data Tools

href: ../analysis-services/tabular-models/deploy-from-sql-server-data-tools-ssas-tabular.md

- name: Manage Tabular Model Databases

href: ../analysis-services/tabular-models/tabular-model-databases-ssas-tabular.md

items:

- name: Process Database, Table, or Partition

href: ../analysis-services/tabular-models/process-database-table-or-partition-analysis-services.md

- name: Tabular Model Roles

href: ../analysis-services/tabular-models/tabular-model-roles-ssas-tabular.md

items:

- name: Manage Roles by using SSMS

href: ../analysis-services/tabular-models/manage-roles-by-using-ssms-ssas-tabular.md

- name: Tabular Model Partitions

href: ../analysis-services/tabular-models/tabular-model-partitions-ssas-tabular.md

items:

- name: Create and Manage Tabular Model Partitions

href: ../analysis-services/tabular-models/create-and-manage-tabular-model-partitions-ssas-tabular.md

- name: Process Tabular Model Partitions

href: ../analysis-services/tabular-models/process-tabular-model-partitions-ssas-tabular.md

- name: Connect to a tabular model database

href: ../analysis-services/tabular-models/connect-to-a-tabular-model-database-ssas.md

- name: Restore from Power Pivot

href: ../analysis-services/tabular-models/restore-from-power-pivot.md

- name: Multidimensional modeling

items:

- name: Multidimensional modeling overview

href: ../analysis-services/multidimensional-models/multidimensional-models-ssas.md

- name: Multidimensional Solutions

href: ../analysis-services/multidimensional-models/multidimensional-model-solutions-ssas.md

items:

- name: Creating Multidimensional Models Using SQL Server Data Tools (SSDT)

href: ../analysis-services/multidimensional-models/creating-multidimensional-models-using-sql-server-data-tools-ssdt.md

items:

- name: Create an Analysis Services Project (SSDT)

href: ../analysis-services/multidimensional-models/create-an-analysis-services-project-ssdt.md

- name: Configure Analysis Services Project Properties (SSDT)

href: ../analysis-services/multidimensional-models/configure-analysis-services-project-properties-ssdt.md

- name: Build Analysis Services Projects (SSDT)

href: ../analysis-services/multidimensional-models/build-analysis-services-projects-ssdt.md

- name: Deploy Analysis Services Projects (SSDT)

href: ../analysis-services/multidimensional-models/deploy-analysis-services-projects-ssdt.md

- name: Create and Run an MDX Script (SSDT)

href: ../analysis-services/multidimensional-models/create-and-run-an-mdx-script-in-sql-server-data-tools.md

- name: View the XML for an Analysis Services Project (SSDT)

href: ../analysis-services/multidimensional-models/view-the-xml-for-an-analysis-services-project-ssdt.md

- name: Connect in Online Mode to an Analysis Services Database

href: ../analysis-services/multidimensional-models/connect-in-online-mode-to-an-analysis-services-database.md

- name: Working with Analysis Services Projects and Databases During the Development Phase

href: ../analysis-services/multidimensional-models/work-with-analysis-services-projects-and-databases-in-development.md

- name: Working with Analysis Services Projects and Databases in a Production Environment

href: ../analysis-services/multidimensional-models/work-with-analysis-services-projects-and-databases-in-production.md

- name: Data Sources

href: ../analysis-services/multidimensional-models/data-sources-in-multidimensional-models.md

items:

- name: Supported Data Sources

href: ../analysis-services/multidimensional-models/supported-data-sources-ssas-multidimensional.md

- name: Create a Data Source

href: ../analysis-services/multidimensional-models/create-a-data-source-ssas-multidimensional.md

- name: Delete a Data Source

href: ../analysis-services/multidimensional-models/delete-a-data-source-in-solution-explorer-ssas-multidimensional.md

- name: Set Data Source Properties

href: ../analysis-services/multidimensional-models/set-data-source-properties-ssas-multidimensional.md

- name: Set Impersonation Options for a Data Source Connection

href: ../analysis-services/multidimensional-models/set-impersonation-options-ssas-multidimensional.md

- name: Data Source Views

href: ../analysis-services/multidimensional-models/data-source-views-in-multidimensional-models.md

items:

- name: Data Sources and Bindings

href: ../analysis-services/multidimensional-models/data-sources-and-bindings-ssas-multidimensional.md

- name: Define a Data Source View

href: ../analysis-services/multidimensional-models/defining-a-data-source-view-analysis-services.md

- name: Add or Remove Tables or Views in a Data Source View

href: ../analysis-services/multidimensional-models/adding-or-removing-tables-or-views-in-a-data-source-view-analysis-services.md

- name: Explore Data in a Data Source View

href: ../analysis-services/multidimensional-models/explore-data-in-a-data-source-view-analysis-services.md

- name: Work with Diagrams in Data Source View Designer

href: ../analysis-services/multidimensional-models/work-with-diagrams-in-data-source-view-designer-analysis-services.md

- name: Refresh the Schema in a Data Source View

href: ../analysis-services/multidimensional-models/refresh-the-schema-in-a-data-source-view-analysis-services.md

- name: Replace a Table or a Named Query in a Data Source View

href: ../analysis-services/multidimensional-models/replace-a-table-or-a-named-query-in-a-data-source-view-analysis-services.md

- name: Define Logical Relationships in a Data Source View

href: ../analysis-services/multidimensional-models/define-logical-relationships-in-a-data-source-view-analysis-services.md

- name: Define Logical Primary Keys in a Data Source View

href: ../analysis-services/multidimensional-models/define-logical-primary-keys-in-a-data-source-view-analysis-services.md

- name: Define Named Calculations in a Data Source View

href: ../analysis-services/multidimensional-models/define-named-calculations-in-a-data-source-view-analysis-services.md

- name: Define Named Queries in a Data Source View

href: ../analysis-services/multidimensional-models/define-named-queries-in-a-data-source-view-analysis-services.md

- name: Delete a Data Source View

href: ../analysis-services/multidimensional-models/delete-a-data-source-view-analysis-services.md

- name: Change Properties in a Data Source View

href: ../analysis-services/multidimensional-models/change-properties-in-a-data-source-view-analysis-services.md

- name: Schema Generation Wizard

href: ../analysis-services/multidimensional-models/schema-generation-wizard-analysis-services.md

items:

- name: Use the Schema Generation Wizard

href: ../analysis-services/multidimensional-models/use-the-schema-generation-wizard-analysis-services.md

- name: Understanding the Database Schemas

href: ../analysis-services/multidimensional-models/understanding-the-database-schemas.md

- name: Understanding Incremental Generation

href: ../analysis-services/multidimensional-models/understanding-incremental-generation.md

- name: Manage Changes to Data Source Views and Data Sources

href: ../analysis-services/multidimensional-models/manage-changes-to-data-source-views-and-data-sources.md

- name: Dimensions

href: ../analysis-services/multidimensional-models/dimensions-in-multidimensional-models.md

items:

- name: Create a Dimension Using the Dimension Wizard

href: ../analysis-services/multidimensional-models/create-a-dimension-using-the-dimension-wizard.md

- name: Create a Dimension by Using an Existing Table

href: ../analysis-services/multidimensional-models/create-a-dimension-by-using-an-existing-table.md

- name: Create a Time Dimension by Generating a Time Table

href: ../analysis-services/multidimensional-models/create-a-time-dimension-by-generating-a-time-table.md

- name: Create a Dimension by Generating a Non-Time Table in the Data Source

href: ../analysis-services/multidimensional-models/create-a-dimension-by-generating-a-non-time-table-in-the-data-source.md

- name: Database Dimensions

href: ../analysis-services/multidimensional-models/define-database-dimensions.md

- name: Database Dimensions - Configure the (All) Level for Attribute Hierarchies

href: ../analysis-services/multidimensional-models/database-dimensions-configure-the-all-level-for-attribute-hierarchies.md

- name: Database Dimensions - Modify or Delete in Solution Explorer

href: ../analysis-services/multidimensional-models/database-dimensions-modify-or-delete-a-database-dimension-in-solution-explorer.md

- name: Database Dimensions - Browse Data in Designer

href: ../analysis-services/multidimensional-models/database-dimensions-browse-dimension-data-in-dimension-designer.md

- name: Database Dimensions - BI Wizard in Designer

href: ../analysis-services/multidimensional-models/database-dimensions-bi-wizard-in-dimension-designer.md

- name: Database Dimensions - Create a Date type

href: ../analysis-services/multidimensional-models/database-dimensions-create-a-date-type-dimension.md

- name: Database Dimensions - Finance Account of parent-child

href: ../analysis-services/multidimensional-models/database-dimensions-finance-account-of-parent-child-type.md

- name: Database Dimensions - Currency type

href: ../analysis-services/multidimensional-models/database-dimensions-create-a-currency-type-dimension.md

- name: Dimension Attribute Properties Reference

href: ../analysis-services/multidimensional-models/dimension-attribute-properties-reference.md

items:

- name: Attribute Properties - Rename an Attribute

href: ../analysis-services/multidimensional-models/attribute-properties-rename-an-attribute.md

- name: Attribute Properties - Add an Attribute to a Dimension

href: ../analysis-services/multidimensional-models/attribute-properties-add-an-attribute-to-a-dimension.md

- name: Attribute Properties - Remove an Attribute from a Dimension

href: ../analysis-services/multidimensional-models/attribute-properties-remove-an-attribute-from-a-dimension.md

- name: Attribute Properties - Configure Attribute Types

href: ../analysis-services/multidimensional-models/attribute-properties-configure-attribute-types.md

- name: Attribute Properties - Group Attribute Members

href: ../analysis-services/multidimensional-models/attribute-properties-group-attribute-members.md

- name: Attribute Properties - Define Custom Member Formulas

href: ../analysis-services/multidimensional-models/attribute-properties-define-custom-member-formulas.md

- name: Attribute Properties - Define a Default Member

href: ../analysis-services/multidimensional-models/attribute-properties-define-a-default-member.md

- name: Attribute Properties - View Attributes in Dimension Designer

href: ../analysis-services/multidimensional-models/attribute-properties-view-attributes-in-dimension-designer.md

- name: Attribute Properties - Define a New Attribute Automatically

href: ../analysis-services/multidimensional-models/attribute-properties-define-a-new-attribute-automatically.md

- name: Attribute Properties - View Attributes in Dimension Designer

href: ../analysis-services/multidimensional-models/view-attributes-in-dimension-designer.md

- name: Attribute Properties - Modify the KeyColumn Property

href: ../analysis-services/multidimensional-models/attribute-properties-modify-the-keycolumn-property.md

- name: Attribute Properties - Bind an Attribute to a Key Column

href: ../analysis-services/multidimensional-models/attribute-properties-bind-an-attribute-to-a-key-column.md

- name: Attribute Properties - Bind an Attribute to a Name Column

href: ../analysis-services/multidimensional-models/attribute-properties-bind-an-attribute-to-a-name-column.md

- name: Attribute Properties - Set Usage Property

href: ../analysis-services/multidimensional-models/attribute-properties-set-usage-property.md

- name: Attribute Properties - Define Member Groups

href: ../analysis-services/multidimensional-models/attribute-properties-define-member-groups.md

- name: Parent-Child Dimension

href: ../analysis-services/multidimensional-models/parent-child-dimension.md

- name: Parent-Child Dimension Attributes

href: ../analysis-services/multidimensional-models/parent-child-dimension-attributes.md

- name: Parent-Child Dimension Attributes - Custom Rollup Operators

href: ../analysis-services/multidimensional-models/parent-child-dimension-attributes-custom-rollup-operators.md

- name: Parent-Child Dimension Attributes - Unary Operators

href: ../analysis-services/multidimensional-models/parent-child-dimension-attributes-unary-operators.md

- name: User-Defined Hierarchies - Create

href: ../analysis-services/multidimensional-models/user-defined-hierarchies-create.md

- name: User-Defined Hierarchies - Ragged Hierarchies

href: ../analysis-services/multidimensional-models/user-defined-hierarchies-ragged-hierarchies.md

- name: User-Defined Hierarchies - Add or Delete a User-Defined Hierarchy

href: ../analysis-services/multidimensional-models/user-defined-hierarchies-add-or-delete-a-user-defined-hierarchy.md

- name: Attribute Relationships - Define

href: ../analysis-services/multidimensional-models/attribute-relationships-define.md

- name: Attribute Relationships - Configure Attribute Properties

href: ../analysis-services/multidimensional-models/attribute-relationships-configure-attribute-properties.md

- name: Attribute Relationships - Create, Modify, or Delete Relationship

href: ../analysis-services/multidimensional-models/attribute-relationships-create-modify-or-delete-relationship.md

- name: Attribute Relationships - Define the Relationship Type

href: ../analysis-services/multidimensional-models/attribute-relationships-define-the-relationship-type.md

- name: Attribute Relationships - Arrange Shapes in the Diagram

href: ../analysis-services/multidimensional-models/attribute-relationships-arrange-shapes-in-the-diagram.md

- name: BI Wizard - Add Account Intelligence to a Dimension

href: ../analysis-services/multidimensional-models/bi-wizard-add-account-intelligence-to-a-dimension.md

- name: BI Wizard - Add Dimension Intelligence to a Dimension

href: ../analysis-services/multidimensional-models/bi-wizard-add-dimension-intelligence-to-a-dimension.md

- name: BI Wizard - Add a Custom Aggregation to a Dimension

href: ../analysis-services/multidimensional-models/bi-wizard-add-a-custom-aggregation-to-a-dimension.md

- name: BI Wizard - Custom Member Formulas for Attributes in a Dimension

href: ../analysis-services/multidimensional-models/bi-wizard-custom-member-formulas-for-attributes-in-a-dimension.md

- name: BI Wizard - Define the Ordering for a Dimension

href: ../analysis-services/multidimensional-models/bi-wizard-define-the-ordering-for-a-dimension.md

- name: BI Wizard - Enable Dimension Writeback

href: ../analysis-services/multidimensional-models/bi-wizard-enable-dimension-writeback.md

- name: Configure String Storage for Dimensions and Partitions

href: ../analysis-services/multidimensional-models/configure-string-storage-for-dimensions-and-partitions.md

- name: Define Linked Dimensions

href: ../analysis-services/multidimensional-models/define-linked-dimensions.md

- name: Cubes

href: ../analysis-services/multidimensional-models/cubes-in-multidimensional-models.md

items:

- name: Create a Cube Using the Cube Wizard

href: ../analysis-services/multidimensional-models/create-a-cube-using-the-cube-wizard.md

- name: Create a Cube from a template without using a Data Source View

href: ../analysis-services/multidimensional-models/create-a-cube-from-a-template-without-using-a-data-source-view.md

- name: Create a Cube using a Data Source View

href: ../analysis-services/multidimensional-models/create-a-cube-using-a-data-source-view.md

- name: Browse data and metadata in Cube

href: ../analysis-services/multidimensional-models/browse-data-and-metadata-in-cube.md

- name: View the Cube Schema

href: ../analysis-services/multidimensional-models/view-the-cube-schema.md

- name: Define Cube Dimension Properties

href: ../analysis-services/multidimensional-models/define-cube-dimension-properties.md

- name: Define Cube Hierarchy Properties

href: ../analysis-services/multidimensional-models/define-cube-hierarchy-properties.md

- name: Define Cube Attribute Properties

href: ../analysis-services/multidimensional-models/define-cube-attribute-properties.md

- name: Define a Regular Relationship and Regular Relationship Properties

href: ../analysis-services/multidimensional-models/define-a-regular-relationship-and-regular-relationship-properties.md

- name: Define a Referenced Relationship and Referenced Relationship Properties

href: ../analysis-services/multidimensional-models/define-a-referenced-relationship-and-referenced-relationship-properties.md

- name: Define a Fact Relationship and Fact Relationship Properties

href: ../analysis-services/multidimensional-models/define-a-fact-relationship-and-fact-relationship-properties.md

- name: Define a Many-to-Many Relationship and Many-to-Many Relationship Properties

href: ../analysis-services/multidimensional-models/define-a-many-to-many-relationship-and-many-to-many-relationship-properties.md

- name: Measures and Measure Groups

href: ../analysis-services/multidimensional-models/measures-and-measure-groups.md

items:

- name: Create Measures and Measure Groups

href: ../analysis-services/multidimensional-models/create-measures-and-measure-groups-in-multidimensional-models.md

- name: Configure Measure Group Properties

href: ../analysis-services/multidimensional-models/configure-measure-group-properties.md

- name: Configure Measure Properties

href: ../analysis-services/multidimensional-models/configure-measure-properties.md

- name: Use Aggregate Functions

href: ../analysis-services/multidimensional-models/use-aggregate-functions.md

- name: Define Semiadditive Behavior

href: ../analysis-services/multidimensional-models/define-semiadditive-behavior.md

- name: Defined Linked Measure Groups

href: ../analysis-services/multidimensional-models/linked-measure-groups.md

- name: Partitions

href: ../analysis-services/multidimensional-models/partitions-in-multidimensional-models.md

items:

- name: Create Local Partitions

href: ../analysis-services/multidimensional-models/create-and-manage-a-local-partition-analysis-services.md

- name: Create Remote Partitions

href: ../analysis-services/multidimensional-models/create-and-manage-a-remote-partition-analysis-services.md

- name: Change a Partition Source

href: ../analysis-services/multidimensional-models/change-a-partition-source-to-use-a-different-fact-table.md

- name: Designing Aggregations

href: ../analysis-services/multidimensional-models/designing-aggregations-analysis-services-multidimensional.md

- name: Edit or Delete Partitions

href: ../analysis-services/multidimensional-models/edit-or-delete-partitions-analyisis-services-multidimensional.md

- name: Merge Partitions

href: ../analysis-services/multidimensional-models/merge-partitions-in-analysis-services-ssas-multidimensional.md

- name: Set Partition Storage

href: ../analysis-services/multidimensional-models/set-partition-storage-analysis-services-multidimensional.md

- name: Set Partition Slice

href: ../analysis-services/multidimensional-models/set-the-partition-slice-property-analysis-services.md

- name: Set Partition Writeback

href: ../analysis-services/multidimensional-models/set-partition-writeback.md

- name: Calculations

href: ../analysis-services/multidimensional-models/calculations-in-multidimensional-models.md

items:

- name: Create Calculated Members

href: ../analysis-services/multidimensional-models/create-calculated-members.md

- name: Create Named Sets

href: ../analysis-services/multidimensional-models/create-named-sets.md

- name: Define Assignments and Other Script Commands

href: ../analysis-services/multidimensional-models/define-assignments-and-other-script-commands.md

- name: Define Time Intelligence Calculations using the Business Intelligence Wizard

href: ../analysis-services/multidimensional-models/define-time-intelligence-calculations-using-the-business-intelligence-wizard.md

- name: KPIs

href: ../analysis-services/multidimensional-models/key-performance-indicators-kpis-in-multidimensional-models.md

- name: Actions overview

href: ../analysis-services/multidimensional-models/actions-in-multidimensional-models.md

items:

- name: Actions

href: ../analysis-services/multidimensional-models/actions-analysis-services-multidimensional-data.md

- name: Add a Standard Action

href: ../analysis-services/multidimensional-models/add-a-standard-action.md

- name: Test an Action

href: ../analysis-services/multidimensional-models/test-an-action.md

- name: Use a Template to Create an Action

href: ../analysis-services/multidimensional-models/use-a-template-to-create-an-action.md

- name: Perspectives

href: ../analysis-services/multidimensional-models/perspectives-in-multidimensional-models.md

- name: Translations

href: ../analysis-services/multidimensional-models/translations-in-multidimensional-models-analysis-services.md

- name: Solution Deployment

href: ../analysis-services/multidimensional-models/multidimensional-model-solution-deployment.md

items:

- name: Requirements and Considerations for Analysis Services Deployment

href: ../analysis-services/multidimensional-models/requirements-and-considerations-for-analysis-services-deployment.md

- name: Deploy Model Solutions Using XMLA

href: ../analysis-services/multidimensional-models/deploy-model-solutions-using-xmla.md

- name: Deploy Model Solutions Using the Deployment Wizard

href: ../analysis-services/multidimensional-models/deploy-model-solutions-using-the-deployment-wizard.md

items:

- name: Running the Analysis Services Deployment Wizard

href: ../analysis-services/multidimensional-models/running-the-analysis-services-deployment-wizard.md

- name: Deployment Script Files - Input to Create Script

href: ../analysis-services/multidimensional-models/deployment-script-files-input-used-to-create-deployment-script.md

- name: Deployment Script Files - Specify the Install Target

href: ../analysis-services/multidimensional-models/deployment-script-files-specifying-the-installation-target.md

- name: Deployment Script Files - Partition and Role Deployment Options

href: ../analysis-services/multidimensional-models/deployment-script-files-partition-and-role-deployment-options.md

- name: Deployment Script Files - Solution Deployment Config Settings

href: ../analysis-services/multidimensional-models/deployment-script-files-solution-deployment-config-settings.md

- name: Deployment Script Files - Specify Processing Options

href: ../analysis-services/multidimensional-models/deployment-script-files-specifying-processing-options.md

- name: Understanding the Analysis Services Deployment Script

href: ../analysis-services/multidimensional-models/understanding-the-analysis-services-deployment-script.md

- name: Deploy Model Solutions with the Deployment Utility

href: ../analysis-services/multidimensional-models/deploy-model-solutions-with-the-deployment-utility.md

- name: Multidimensional Databases

href: ../analysis-services/multidimensional-models/multidimensional-model-databases-ssas.md

items:

- name: Attach and Detach Analysis Services Databases

href: ../analysis-services/multidimensional-models/attach-and-detach-analysis-services-databases.md

- name: Backup and Restore of Analysis Services Databases

href: ../analysis-services/multidimensional-models/backup-and-restore-of-analysis-services-databases.md

items:

- name: Backup Options

href: ../analysis-services/multidimensional-models/backup-options.md

- name: Restore Options

href: ../analysis-services/multidimensional-models/restore-options.md

- name: Document and Script an Analysis Services Database

href: ../analysis-services/multidimensional-models/document-and-script-an-analysis-services-database.md

- name: Modify or Delete an Analysis Services Database

href: ../analysis-services/multidimensional-models/modify-or-delete-an-analysis-services-database.md

- name: Move an Analysis Services Database

href: ../analysis-services/multidimensional-models/move-an-analysis-services-database.md

- name: Rename a Multidimensional Database

href: ../analysis-services/multidimensional-models/rename-a-multidimensional-database-analysis-services.md

- name: Compatibility Level

href: ../analysis-services/multidimensional-models/compatibility-level-of-a-multidimensional-database-analysis-services.md

- name: Set Multidimensional Database Properties

href: ../analysis-services/multidimensional-models/set-multidimensional-database-properties-analysis-services.md

items:

- name: Database Storage Location

href: ../analysis-services/multidimensional-models/database-storage-location.md

- name: Database ReadWriteModes

href: ../analysis-services/multidimensional-models/database-readwritemodes.md

- name: Synchronize Analysis Services Databases

href: ../analysis-services/multidimensional-models/synchronize-analysis-services-databases.md

- name: Switch ReadOnly and ReadWrite modes

href: ../analysis-services/multidimensional-models/switch-an-analysis-services-database-between-readonly-and-readwrite-modes.md

- name: Processing a multidimensional model

href: ../analysis-services/multidimensional-models/processing-a-multidimensional-model-analysis-services.md

items:

- name: Processing Options and Settings

href: ../analysis-services/multidimensional-models/processing-options-and-settings-analysis-services.md

- name: Processing Databases, Dimensions and Partitions

href: ../analysis-services/multidimensional-models/processing-analysis-services-objects.md

- name: Tools and Approaches for Processing

href: ../analysis-services/multidimensional-models/tools-and-approaches-for-processing-analysis-services.md

- name: Batch Processing

href: ../analysis-services/multidimensional-models/batch-processing-analysis-services.md

- name: Remote Processing

href: ../analysis-services/multidimensional-models/remote-processing-analysis-services.md

- name: Error Configuration

href: ../analysis-services/multidimensional-models/error-configuration-for-cube-partition-and-dimension-processing.md

- name: Roles and Permissions

href: ../analysis-services/multidimensional-models/roles-and-permissions-analysis-services.md

items:

- name: Authorizing access to objects and operations

href: ../analysis-services/multidimensional-models/authorizing-access-to-objects-and-operations-analysis-services.md

- name: Database permissions

href: ../analysis-services/multidimensional-models/grant-database-permissions-analysis-services.md

- name: Cube or model permissions

href: ../analysis-services/multidimensional-models/grant-cube-or-model-permissions-analysis-services.md

- name: Process permissions

href: ../analysis-services/multidimensional-models/grant-process-permissions-analysis-services.md

- name: Read Definition permissions

href: ../analysis-services/multidimensional-models/grant-read-definition-permissions-on-object-metadata-analysis-services.md

- name: Dimension permissions

href: ../analysis-services/multidimensional-models/grant-permissions-on-a-dimension-analysis-services.md

- name: Custom access to dimension data

href: ../analysis-services/multidimensional-models/grant-custom-access-to-dimension-data-analysis-services.md

- name: Custom access to cell data

href: ../analysis-services/multidimensional-models/grant-custom-access-to-cell-data-analysis-services.md

- name: Data Source object permissions

href: ../analysis-services/multidimensional-models/grant-permissions-on-a-data-source-object-analysis-services.md

- name: Data Mining permissions

href: ../analysis-services/multidimensional-models/grant-permissions-on-data-mining-structures-and-models-analysis-services.md

- name: Power View for Multidimensional Models

href: ../analysis-services/multidimensional-models/power-view-for-multidimensional-models.md

items:

- name: Understanding Power View for Multidimensional Models

href: ../analysis-services/multidimensional-models/understanding-power-view-for-multidimensional-models.md

- name: Create a Report Data Source

href: ../analysis-services/multidimensional-models/create-a-report-data-source.md

- name: Create a Power View Report

href: ../analysis-services/multidimensional-models/create-a-power-view-report-with-a-multidimensional-data-source.md

- name: ADOMD.NET Server Functionality +

href: /bi-reference/adomd/multidimensional-models-adomd-net-server/adomd-net-server-functionality

- name: ADOMD.NET Server Object Architecture +

href: /bi-reference/adomd/multidimensional-models-adomd-net-server/adomd-net-server-object-architecture

- name: ADOMD.NET Server Programming +

href: /bi-reference/adomd/multidimensional-models-adomd-net-server/adomd-net-server-programming

- name: User Defined Functions and Stored Procedures +

href: /bi-reference/adomd/multidimensional-models-adomd-net-server/user-defined-functions-and-stored-procedures

- name: Assemblies Management

href: ../analysis-services/multidimensional-models/multidimensional-model-assemblies-management.md

- name: Data Mining

items:

- name: Data Mining overview

href: ../analysis-services/data-mining/data-mining-ssas.md

- name: Data Mining concepts

href: ../analysis-services/data-mining/data-mining-concepts.md

- name: Algorithms

href: ../analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining.md

items:

- name: Microsoft Association

href: ../analysis-services/data-mining/microsoft-association-algorithm.md

items:

- name: Microsoft Association Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-association-algorithm-technical-reference.md

- name: Mining Model Content for Association Models

href: ../analysis-services/data-mining/mining-model-content-for-association-models-analysis-services-data-mining.md

- name: Association Model Query Examples

href: ../analysis-services/data-mining/association-model-query-examples.md

- name: Microsoft Clustering

href: ../analysis-services/data-mining/microsoft-clustering-algorithm.md

items:

- name: Microsoft Clustering Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-clustering-algorithm-technical-reference.md

- name: Mining Model Content for Clustering Models

href: ../analysis-services/data-mining/mining-model-content-for-clustering-models-analysis-services-data-mining.md

- name: Clustering Model Query Examples

href: ../analysis-services/data-mining/clustering-model-query-examples.md

- name: Microsoft Decision Trees

href: ../analysis-services/data-mining/microsoft-decision-trees-algorithm.md

items:

- name: Microsoft Decision Trees Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-decision-trees-algorithm-technical-reference.md

- name: Mining Model Content for Decision Tree Models

href: ../analysis-services/data-mining/mining-model-content-for-decision-tree-models-analysis-services-data-mining.md

- name: Decision Trees Model Query Examples

href: ../analysis-services/data-mining/decision-trees-model-query-examples.md

- name: Microsoft Linear Regression

href: ../analysis-services/data-mining/microsoft-linear-regression-algorithm.md

items:

- name: Microsoft Linear Regression Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-linear-regression-algorithm-technical-reference.md

- name: Mining Model Content for Linear Regression Models

href: ../analysis-services/data-mining/mining-model-content-for-linear-regression-models-analysis-services-data-mining.md

- name: Linear Regression Model Query Examples

href: ../analysis-services/data-mining/linear-regression-model-query-examples.md

- name: Microsoft Logistic Regression

href: ../analysis-services/data-mining/microsoft-logistic-regression-algorithm.md

items:

- name: Microsoft Logistic Regression Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-logistic-regression-algorithm-technical-reference.md

- name: Mining Model Content for Logistic Regression Models

href: ../analysis-services/data-mining/mining-model-content-for-logistic-regression-models.md

- name: Logistic Regression Model Query Examples

href: ../analysis-services/data-mining/logistic-regression-model-query-examples.md

- name: Microsoft Naive Bayes

href: ../analysis-services/data-mining/microsoft-naive-bayes-algorithm.md

items:

- name: Microsoft Naive Bayes Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-naive-bayes-algorithm-technical-reference.md

- name: Mining Model Content for Naive Bayes Models

href: ../analysis-services/data-mining/mining-model-content-for-naive-bayes-models-analysis-services-data-mining.md

- name: Naive Bayes Model Query Examples

href: ../analysis-services/data-mining/naive-bayes-model-query-examples.md

- name: Microsoft Neural Network

href: ../analysis-services/data-mining/microsoft-neural-network-algorithm.md

items:

- name: Microsoft Neural Network Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-neural-network-algorithm-technical-reference.md

- name: Mining Model Content for Neural Network Models

href: ../analysis-services/data-mining/mining-model-content-for-neural-network-models-analysis-services-data-mining.md

- name: Neural Network Model Query Examples

href: ../analysis-services/data-mining/neural-network-model-query-examples.md

- name: Microsoft Sequence Clustering

href: ../analysis-services/data-mining/microsoft-sequence-clustering-algorithm.md

items:

- name: Microsoft Sequence Clustering Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-sequence-clustering-algorithm-technical-reference.md

- name: Mining Model Content for Sequence Clustering Models

href: ../analysis-services/data-mining/mining-model-content-for-sequence-clustering-models.md

- name: Sequence Clustering Model Query Examples

href: ../analysis-services/data-mining/sequence-clustering-model-query-examples.md

- name: Microsoft Time Series

href: ../analysis-services/data-mining/microsoft-time-series-algorithm.md

items:

- name: Microsoft Time Series Algorithm Technical Reference

href: ../analysis-services/data-mining/microsoft-time-series-algorithm-technical-reference.md

- name: Mining Model Content for Time Series Models

href: ../analysis-services/data-mining/mining-model-content-for-time-series-models-analysis-services-data-mining.md

- name: Time Series Model Query Examples

href: ../analysis-services/data-mining/time-series-model-query-examples.md

- name: Plugin Algorithms

href: ../analysis-services/data-mining/plugin-algorithms.md

- name: Structures

href: ../analysis-services/data-mining/mining-structures-analysis-services-data-mining.md

items:

- name: Mining Structure Columns

href: ../analysis-services/data-mining/mining-structure-columns.md

items:

- name: Data Types (Data Mining)

href: ../analysis-services/data-mining/data-types-data-mining.md

- name: Nested Tables

href: ../analysis-services/data-mining/nested-tables-analysis-services-data-mining.md

- name: Column Distributions

href: ../analysis-services/data-mining/column-distributions-data-mining.md

- name: Discretization Methods

href: ../analysis-services/data-mining/discretization-methods-data-mining.md

- name: Classified Columns

href: ../analysis-services/data-mining/classified-columns-data-mining.md

- name: Drillthrough on Mining Structures

href: ../analysis-services/data-mining/drillthrough-on-mining-structures.md

- name: Properties for Mining Structure and Structure Columns

href: ../analysis-services/data-mining/properties-for-mining-structure-and-structure-columns.md

- name: Mining Structure Tasks and How-tos

href: ../analysis-services/data-mining/mining-structure-tasks-and-how-tos.md

items:

- name: Create a New Relational Mining Structure

href: ../analysis-services/data-mining/create-a-new-relational-mining-structure.md

- name: Create a New OLAP Mining Structure

href: ../analysis-services/data-mining/create-a-new-olap-mining-structure.md

- name: Add Columns to a Mining Structure

href: ../analysis-services/data-mining/add-columns-to-a-mining-structure.md

- name: Remove Columns from a Mining Structure

href: ../analysis-services/data-mining/remove-columns-from-a-mining-structure.md

- name: Add a Nested Table to a Mining Structure

href: ../analysis-services/data-mining/add-a-nested-table-to-a-mining-structure.md

- name: Change the Properties of a Mining Structure

href: ../analysis-services/data-mining/change-the-properties-of-a-mining-structure.md

- name: Edit the Data Source View used for a Mining Structure

href: ../analysis-services/data-mining/edit-the-data-source-view-used-for-a-mining-structure.md

- name: Process a Mining Structure

href: ../analysis-services/data-mining/process-a-mining-structure.md

- name: Models

href: ../analysis-services/data-mining/mining-models-analysis-services-data-mining.md

items:

- name: Mining Model Columns

href: ../analysis-services/data-mining/mining-model-columns.md

- name: Content Types (Data Mining)

href: ../analysis-services/data-mining/content-types-data-mining.md

- name: Mining Model Properties

href: ../analysis-services/data-mining/mining-model-properties.md

- name: Missing Values

href: ../analysis-services/data-mining/missing-values-analysis-services-data-mining.md

- name: Feature Selection (Data Mining)

href: ../analysis-services/data-mining/feature-selection-data-mining.md

- name: Modeling Flags (Data Mining)

href: ../analysis-services/data-mining/modeling-flags-data-mining.md

- name: Mining Model Content

href: ../analysis-services/data-mining/mining-model-content-analysis-services-data-mining.md

- name: Drillthrough on Mining Models

href: ../analysis-services/data-mining/drillthrough-on-mining-models.md

- name: Filters for Mining Models

href: ../analysis-services/data-mining/filters-for-mining-models-analysis-services-data-mining.md

items:

- name: Model Filter Syntax and Examples

href: ../analysis-services/data-mining/model-filter-syntax-and-examples-analysis-services-data-mining.md

- name: Mining Model Tasks and How-tos

href: ../analysis-services/data-mining/mining-model-tasks-and-how-tos.md

items:

- name: Add a Mining Model to an Existing Mining Structure

href: ../analysis-services/data-mining/add-a-mining-model-to-an-existing-mining-structure.md

- name: Delete a Mining Model from a Mining Structure

href: ../analysis-services/data-mining/delete-a-mining-model-from-a-mining-structure.md

- name: Exclude a Column from a Mining Model

href: ../analysis-services/data-mining/exclude-a-column-from-a-mining-model.md

- name: Create an Alias for a Model Column

href: ../analysis-services/data-mining/create-an-alias-for-a-model-column.md