Changes in Analysis Services 2008

原创 2007年09月21日 17:43:00

Changes in Analysis Services 2008

AS 2005 was and still is a huge product release. With many people still becoming familiar with all the changes, AS2008 is already on its way. There are a number of great chages to the product which ultimately translate into some very nice scalability enhancements. Some of these changes will only be available in later CTP's and these address the way AS2008 handles "sparse" data.
Right now AS2005 evaluates every cell in order to calculate a result set, thus, if your cube is very sparsely populated, will a lot of unnecessary queries. No matter how good your aggregations or MDX is written, query time will suffer. AS2008 will better manage empty cube space and bringing much needed performance "out the box" without having to rebuild anything.
Another area of improvement is the dimensional design. In AS2008 visualizing strong attribute relationships becomes much easier and new AMO warnings are present everywhere. Think of it as an always on BPA. The warnings are non intrusive thus no annoying pop-ups. Aggregation design will now happen through a single interface and will even allow for aggregations to be merged so managing effctive sets becomes much easier. Still the old principles apply, so designing aggregations can still be a loaded gun.
Those of you using Writeback in the cube will find betterperformance in AS2008, the way writeback is handled has been changed. There are many more changes and this release is pretty exciting so keep downloading those CTP's and provide feedback on what you think. For me what matters most is that without having to rebuild any cubes from AS2005, 2008 will bring better performance right out the box.

Error message when you try to save a table in SQL Server 2008: "Saving changes is not permitted"

SYMPTOMS When you use Data Definition Language (DDL) to modify a table, and then you try to save th...

《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记七:高级维度设计


《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记十:与Cube交互(上)

导读:本文介绍如何与cube交互(Interacting with a Cube)。 本文将包括以下内容: 1、创建URL动作(Create a URL action) 2、创建钻取动作(Create...

《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记一:入门[川北小哥]

导读:本文主要介绍了创建SQL Server Analysis Service项目及数据源、数据源视图的基本过程。  (一)BI基础概念   一个BI(Business intellige...

《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记九:使用帐户智能(下)

导读:本文介绍如何使用账户智能(Account Intelligence。本文将包括以下内容: 4、创建非累加的度量(Create non-additive measures)5、创建一个定制成员汇总...

《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记十九:监视和管理工具进阶(本书完)

SQL Server 2008中SQL应用系列及BI笔记系列--目录索引导读:本文介绍Analysis Services中的监视和管理工具本文将包括以下内容:■1、使用Windows可靠性和性能监视器...

《Microsoft SQL Server 2008 Analysis Services Step By Step》学习笔记

一. 商业智能数据分析的基础初识商业智能何为商业智能(Business Intelligence)? 商业智能:基于客观数据,获得信息,辅助决策。商业智能系统的五个层次: 1. 数据源层:文本文...

《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记五:创建高级度量和计算(中)

导读:本文继续介绍创建高级度量和计算的基本技巧:使用MDX表达式创建计算成员和应用条件格式、理解计算优先权。 本文末尾提供两个项目源码:AdventureWorks_BI_Begin3和Adventu...

《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记十六:管理分区及数据库处理(上)

SQL Server 2008中SQL应用系列--目录索引导读:本文介绍Analysis Services管理分区及数据库处理。本文将包括以下内容:■1、使用ROLAP或MOLAP存储配置维度■2、使...

SQL Server 2008 Analysis Services 入门教案

并下载安装微软实例数据库 一. 创建 Analysis Services 项目 单击“开始”,依此指向...
  • 2012年03月22日 10:36
  • 834
您举报文章:Changes in Analysis Services 2008