THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

Gemini and SSAS explained

I got some more information about Gemini. As Mosha said, it is Analysis Services. As you know, SSAS has always been available also as a client tool, using the same engine of the server product to create local cubes. The Kilimanjaro release will add several features to this engine that, integrated with the client part of Gemini (which allows end users to define their own model), will give high speed performance to cubes which are stored in-memory and without any pre-calculated aggregation.

According to Ashvini Sharma, these new features might not be available to traditional SSAS developers in the Kilimanjaro release. However, cubes created from end-users will expose all SSAS metadata as usual. For this reason, these cubes will be immediately available to any SSAS-enabled client.

Now, it is questionable to call these entities cubes, since (but this is my speculation) they could have a design very unusual if compared to traditional cubes.

Anyway, in the long term, all these new features (which have still not be disclosed in detail) will be available at any level. Just in the first release, the server instance of SSAS will be used by Excel Services. When you create a model into Excel, the local engine will be used. When the same spreadsheet will be published to SharePoint, the Excel Services engine will use an instance of SSAS (but may be more than one instance on more servers) to make the calculation on these data.

Unfortunately, not all information about internal details can be disclosed now. However, it seems that SSAS will have a bright future.

Published Tuesday, October 07, 2008 1:20 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

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement