Search results matching tags 'Analysis Services' and 'Gemini'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Analysis+Services,Gemini&orTags=0Search results matching tags 'Analysis Services' and 'Gemini'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Gemini and SSAS explainedhttp://sqlblog.com/blogs/marco_russo/archive/2008/10/06/gemini-and-ssas-explained.aspxMon, 06 Oct 2008 22:20:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:9300sqlbi<P class=MsoNormal style="MARGIN:0cm 0cm 10pt;"><SPAN style="mso-ansi-language:EN-US;"><FONT face=Calibri size=3>I got some more information about Gemini. As </FONT><A class="" href="http://sqlblog.com/blogs/mosha/archive/2008/10/06/so-what-is-exactly-project-gemini.aspx"><FONT face=Calibri size=3>Mosha said</FONT></A><FONT size=3><FONT face=Calibri>, 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.<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 10pt;"><SPAN style="mso-ansi-language:EN-US;"><FONT face=Calibri size=3>According to </FONT><A href="http://blogs.msdn.com/ashvinis/"><FONT face=Calibri size=3>Ashvini Sharma</FONT></A><FONT size=3><FONT face=Calibri>, 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.<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 10pt;"><SPAN style="mso-ansi-language:EN-US;"><FONT size=3><FONT face=Calibri>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.<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 10pt;"><SPAN style="mso-ansi-language:EN-US;"><FONT size=3><FONT face=Calibri>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.<o:p></o:p></FONT></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN:0cm 0cm 10pt;"><SPAN style="mso-ansi-language:EN-US;"><FONT size=3><FONT face=Calibri>Unfortunately, not all information about internal details can be disclosed now. However, it seems that SSAS will have a bright future.<o:p></o:p></FONT></FONT></SPAN></P>