Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayDatabase Objects (Analysis Services - Multidimensional Data)
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
A Microsoft SQL Server SQL Server Analysis Services instance contains database objects and assemblies for use with online analytical processing (OLAP) and data mining.
Databases contain OLAP and data mining objects, such as data sources, data source views, cubes, measures, measure groups, dimensions, attributes, hierarchies, mining structures, mining models and roles.
Assemblies contain user-defined functions that extend the functionality of the intrinsic functions provided with the Multidimensional Expressions (MDX) and Data Mining Extensions (DMX) languages.
The Database object is the container for all data objects that are needed for a business intelligence project (such as OLAP cubes, dimensions, and data mining structures), and their supporting objects (such as DataSource, Account, and Role).
A Database object provides access to objects and attributes that include the following:
All cubes that you can access, as a collection.
All dimensions that you can access, as a collection.
All mining structures that you can access, as a collection.
All data sources and data source views, as two collections.
All roles and database permissions, as two collections.
The collation value for the database.
The estimated size of the database.
The language value of the database.
The visible setting for the database.
The following topics describe objects shared by both OLAP and data mining features in SQL Server Analysis Services.
| Topic | Description |
|---|---|
| Data Sources in Multidimensional Models | Describes a data source in SQL Server Analysis Services. |
| Data Source Views in Multidimensional Models | Describes a logical data model based on one or more data sources, in SQL Server Analysis Services. |
| Cubes in Multidimensional Models | Describes cubes and cube objects, including measures, measure groups, dimension usage relationships, calculations, key performance indicators, actions, translations, partitions, and perspectives. |
| Dimensions (Analysis Services - Multidimensional Data) | Describes dimensions and dimension objects, including attributes, attribute relationships, hierarchies, levels, and members. |
| Mining Structures (Analysis Services - Data Mining) | Describes mining structures and mining objects, including mining models. |
| Security Roles (Analysis Services - Multidimensional Data) | Describes a role, the security mechanism used to control access to objects in SQL Server Analysis Services. |
| Multidimensional Model Assemblies Management | Describes an assembly, a collection of user-defined functions used to extend the MDX and DMX languages, in SQL Server Analysis Services. |
Supported Data Sources (SSAS - Multidimensional)
Data Mining Solutions
Additional resources
Training
Module
Analyze data in a relational data warehouse - Training
Relational data warehouses are a core element of most enterprise Business Intelligence (BI) solutions, and are used as the basis for data models, reports, and analysis.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.