SQL 2012 Multidimensional Modeling (Adventure Works Tutorial) [推广有奖]

0关注
3粉丝

硕士生

30%

还不是VIP/贵宾

威望: 0 级
论坛币: 1799 个
通用积分: 2.7846
学术水平: 3 点
热心指数: 8 点
信用等级: 5 点
经验: 477 点
帖子: 76
精华: 0
在线时间: 206 小时
注册时间: 2008-3-12
最后登录: 2019-4-12

楼主

cnhyyhu1111 发表于 2012-8-3 01:34:40 |只看作者 |坛友微信交流群|倒序 |AI写论文

相似文件

换一批

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

Summary: This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples.

Category: Step-by-Step

Applies to: SQL Server 2012 Source: SQL Server Books Online (link to source content)

publication date: June 2012

What You Will LearnIn this tutorial, you will learn the following: • How to define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an Analysis Services project within SQL Server Data Tools. • How to view cube and dimension data by deploying the Analysis Services project to an instance of Analysis Services, and how to then process the deployed objects to populate them with data from the underlying data source. • How to modify the measures, dimensions, hierarchies, attributes, and measure groups in the Analysis Services project, and how to then deploy the incremental changes to the deployed cube on the development server. • How to define calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.