analysis services部署

love__sz 2011-06-10 10:22:33
本人最近在学习MS SQL的analysis services 在数据库部署的时候出现以下问题：


标题: Microsoft Visual Studio
------------------------------

“localhost”服务器上已存在“Analysis Services Tutorial”数据库。如果继续进行部署，将覆盖该数据库。
是否继续?

------------------------------



我使用的是Microsoft的示例数据库：Adventure Works DW

部署到底是什么样的状况？？

我是按照“SQL Server 2008 Analysis Services 多维数据库一步一步从入门到精通.doc”文件进行实验的，他最终
managment studio中出现数据库Analysis Services Tutorial，我的却没有。
...全文
163 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
donkeyvida 2011-08-04
  • 打赏
  • 举报
 回复
我的部署数据库是按照微软教程上填写的 "Analysis Services Tutorial"
我的数据库就没有"Analysis Services Tutorial"这个数据库,但是部署还能成功
而且没有在数据库中创建"Analysis Services Tutorial"数据库

哪位达人回复 谢谢
sz_vcp2007 2011-06-11
  • 打赏
  • 举报
 回复
楼主在部署的属性页里面的数据库填写的是：“Adventure Works DW”吗
love__sz 2011-06-11
  • 打赏
  • 举报
 回复
[Quote=引用 2 楼 kingtiy 的回复:]
已经存在这个数据库了.Analysis Services Tutorial

managment studio 连接的时候选择Analysis Services数据库,就可以连接进去看到了.
但要先开启SSAS服务.
[/Quote]

这个说的 首先要选择服务器类型。


就是怕以后建winform程序时不好办……
cd731107 2011-06-11
  • 打赏
  • 举报
 回复
没什么影响的
kingtiy 2011-06-11
  • 打赏
  • 举报
 回复
已经存在这个数据库了.Analysis Services Tutorial

managment studio 连接的时候选择Analysis Services数据库,就可以连接进去看到了.
但要先开启SSAS服务.
叶子 2011-06-11
  • 打赏
  • 举报
 回复
安装的时候没有完全安装吧?
Analysis Services 项目部署
数据仓库，详细的部署步骤。包括维度的创建等等
Analysis Services Tutorial SQL Server 2012
Analysis Services Tutorial SQL Server 2012
AdventureWorks 2008 Analysis Services Project
《SQL Server 2008 报表服务从入门到精通》一书中相匹配的分析服务所需的工程项目
Analysis Services实验教程-多维建模教程
一步步教你如何进行Analysis Service多维建模，步骤详细完备，很实用。
Microsoft SQL Server 2008 Analysis Services Unleashed
Contents at a Glance Introduction....................................................................................................1 Part 1: Introduction to Analysis Services 1 Introduction to OLAP and Its Role in Business Intelligence.........................7 2 Multidimensional Space...............................................................................17 3 Client/Server Architecture and Multidimensional Databases: An Overview27 Part 2: Creating Multidimensional Models 4 Conceptual Data Model................................................................................37 5 Dimensions in the Conceptual Model.........................................................43 6 Cubes and Multidimensional Analysis.........................................................63 7 Measures and Multidimensional Analysis....................................................75 8 Advanced Modeling......................................................................................91 9 Multidimensional Models and Business Intelligence Development Studio...................................................................................109 Part 3 Using MDX To Analyze Data 10 MDX Concepts............................................................................................139 11 Advanced MDX...........................................................................................161 12 Cube-Based MDX Calculations...................................................................189 13 Dimension-Based MDX Calculations.........................................................221 14 Extending MDX with Stored Procedures....................................................237 15 Key Performance Indicators, Actions, and the DRILLTHROUGH Statement.......................................................................261 16 Writing Data into Analysis Services...........................................................291 Part 4 Creating a Data Warehouse 17 Loading Data from a Relational Database..................................................307 18 DSVs and Object Bindings..........................................................................317 19 Multidimensional Models and Relational Database Schemas...................329Part 5 Bringing Data into Analysis Services 20 The Physical Data Model............................................................................345 21 Dimension and Partition Processing..........................................................377 22 Using SQL Server Integration Services to Load Data.................................407 23 Aggregation Design and Usage-Based Optimization..................................417 24 Proactive Caching and Real-Time Updates................................................435 25 Building Scalable Analysis Services Applications.......................................451 Part 6 Analysis Server Architecture 26 Server Architecture and Command Execution...........................................477 27 Memory Management................................................................................503 28 Thread Management...................................................................................521 29 Architecture of Query Execution—Calculating MDX Expressions............527 30 Architecture of Query Execution—Retrieving Data from Storage.............553 Part 7 Accessing Data in Analysis Services 31 Client/Server Architecture and Data Access...............................................569 32 XML for Analysis........................................................................................579 33 ADOMD.NET...............................................................................................599 34 Analysis Management Objects....................................................................669 Part 8 Security 35 Security Model for Analysis Services..........................................................713 36 Securing Dimension Data...........................................................................731 37 Securing Cell Values....................................................................................751 Part 9 Management 38 Using Trace to Monitor and Audit Analysis Services.................................763 39 Backup and Restore Operations..................................................................787 40 Deployment Strategies................................................................................805 41 Resource Monitoring...................................................................................815 Index...........................................................................................................823
community_281

682

社区成员

253,705

社区内容

发帖
与我相关
我的任务
社区描述
提出问题
其他 技术论坛（原bbs）
社区管理员
  • community_281
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章