使用SQL Server Analysis Services连接到数据源

For someone new to SQL Server Analysis Services, a decision must be made on whether to use a Multidimensional Cube or Tabular Model. Both types can be installed on the same server, but they must be different instances. That could mean additional license costs. But, with the developer’s edition, both can be installed and reviewed before a production decision is made. Data Source connections are the first step to review with both versions.

对于SQL Server Analysis Services的新用户，必须决定是使用多维多维数据集还是表格模型。 两种类型都可以安装在同一服务器上，但是它们必须是不同的实例。 那可能意味着额外的许可费用。 但是，使用开发人员的版本，可以在做出生产决策之前安装和检查两者。 数据源连接是使用两个版本进行检查的第一步。

Figure 1 shows the option during installation to pick the type of Analysis Service.

图1显示了安装过程中用于选择Analysis Service类型的选项。

The first step with a Cube or Tabular Model is to pick a connection or connections to data sources. The connection properties are very similar, but the retrieval of the data through tables or table-like sources is a little different. Both allow multiple connections. The cube can layout the relationships a little better with Data Source Views. Multidimensional also allows multiple cubes in one project, whereas Tabular has only one model – for now. The Tabular Model does have a relationship view, but you cannot separate different views of the relationships like a Data Source View in a cube.

多维数据集或表格模型的第一步是选择一个或多个数据源连接。 连接属性非常相似，但是通过表或类似表的源检索数据有些不同。 两者都允许多个连接。 多维数据集可以使用数据源视图更好地布局关系。 多维还允许在一个项目中使用多个多维数据集，而Tabular目前只有一个模型。 表格模型确实具有关系视图，但是您不能像多维数据集中的数据源视图那样分离关系的不同视图。

Figure 2 shows Visual Studio creating a Multidimensional Cube project while Figure 3 shows the solution explorer of this new project.

图2显示了Visual Studio创建的多维多维数据集项目，而图3显示了这个新项目的解决方案资源管理器。

To add a connection to the project, right-click the Data Sources folder in the solution explorer and select New Data Source… The Data Source Wizard will step through the needed selections for the connection. This is from where the data mart or data warehouse gets selected. Well-designed dimensional models will have all fact and dimension tables within one database. But, there are times where shared dimensions are in different databases like a Master Data Management System.

要将连接添加到项目，请在解决方案资源管理器中右键单击“数据源”文件夹，然后选择“新建数据源”。“数据源向导”将逐步完成连接所需的选择。 这是从中选择数据集市或数据仓库的位置。 设计良好的维度模型将所有事实和维度表存储在一个数据库中。 但是，有时共享维度位于不同的数据库中，例如主数据管理系统。

After selecting the In