教程:从门户添加示例模型Tutorial: Add a sample model from the portal
在本教程中,将向服务器添加示例 Adventure Works 表格模型数据库。In this tutorial, you add a sample Adventure Works tabular model database to your server. 此示例模型是 Adventure Works Internet Sales (1200) 示例数据模型的完整版本。The sample model is a completed version of the Adventure Works Internet Sales (1200) sample data model. 示例模型可用于测试模型管理、与工具和客户端应用程序进行连接,以及查询模型数据。A sample model is useful for testing model management, connecting with tools and client applications, and querying model data. 本教程使用 Azure 门户和 SQL Server Management Studio (SSMS) 执行以下操作:This tutorial uses the Azure portal and SQL Server Management Studio (SSMS) to:
- 将已完成的示例表格数据模型添加到服务器Add a completed sample tabular data model to a server
- 使用 SSMS 连接到模型Connect to the model with SSMS
如果没有 Azure 订阅,请在开始前创建一个试用版订阅。If you don't have an Azure subscription, create a Trial Subscription before you begin.
先决条件Prerequisites
要完成本教程,需要:To complete this tutorial, you need:
- Azure Analysis Services 服务器。An Azure Analysis Services server. 若要了解更多信息,请参阅创建服务器 - 门户。To learn more, see Create a server - portal.
- 服务器管理员权限Server administrator permissions
- SQL Server Management StudioSQL Server Management Studio
登录到 Azure 门户Sign in to the Azure portal
添加示例模型Add a sample model
在服务器“概述”中,单击“新建模型”。In server Overview, click New model.
在“新建模型” > “选择数据源”中,确认已选中“示例数据”,然后单击“添加”。 In New model > Choose a data source, verify Sample data is selected, and then click Add.
在“概述”中,确认是否添加了
adventureworks
示例模型。In Overview, verify theadventureworks
sample model is added.
清理资源Clean up resources
示例模型使用了缓存内存资源。Your sample model is using cache memory resources. 如果不使用示例模型进行测试,则应将其从服务器中删除。If you are not using your sample model for testing, you should remove it from your server.
下面的步骤介绍了如何使用 SSMS 从服务器中删除模型。These steps describe how to delete a model from a server by using SSMS.
在 SSMS >“对象资源管理器”中,单击“连接” > “Analysis Services”。In SSMS > Object Explorer, click Connect > Analysis Services.
在“连接到服务器”中,粘贴服务器名称,然后在“身份验证”中选择“Active Directory - 支持 MFA 的通用身份验证”,输入你的用户名,然后单击“连接”。In Connect to Server, paste in the server name, then in Authentication, choose Active Directory - Universal with MFA support, enter your username, and then click Connect.
在“对象资源管理器”中,右键单击
adventureworks
示例数据库,然后单击“删除”。 In Object Explorer, right-click theadventureworks
sample database, and then click Delete.
后续步骤Next steps
本教程介绍了如何将基本示例模型添加到服务器。In this tutorial, you learned how to add a basic, sample model to your server. 现在,已有模型数据库,可以从 SQL Server Management Studio 连接到它,并添加用户角色。Now that you have a model database, you can connect to it from SQL Server Management Studio and add user roles. 若要了解详细信息,请继续阅读下一个教程。To learn more, continue with the next tutorial.