THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

BizTalk 2004 and Analysis Services: bad cubes?

In these last busy two months I've seen many things that deserves to blog, but until now I hadn't time to do it. But today I have 5 minutes to talk about the current BizTalk 2004 integration with Analysis Services 2000: this time I have some critics to do.

There is a database with two cubes (MessageMetrics and ServiceMetrics) and I don't know if it really give to a user what he really needs, but for sure this cube doesn't follow the actual best practices, but instead it follows what I would call "worst practices". Let's see:

  • All dimension are private
  • Possible "shared" dimension are private, so there is no easy way to have a virtual cube to relate measures from different cubes
  • It seems there are no designed aggregations
  • The missing of shared dimensions causes the inability to optimize the cube process

I don't know if this should be considered only as a "demo of possible integration" or if it is sold as an example of products integration. In both cases it fails the target, because I sincerely can't see the added value of a such poor designed olap cube. It doesn't scale. It requires "another service" (Analysis Services) only to give you what is available with SQL aggregation (if you have a lot of data, cube design is really bad) but with an added latency (the cube needs to be processed).

 I just checked here: it has to be considered as a BizTalk feature. I'm curious to see BizTalk 2006 advances here.

Uhm... someone has some fact to convince me that I'm wrong?

Published Friday, July 29, 2005 8:13 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement