{"id":28,"date":"2007-07-26T21:56:40","date_gmt":"2007-07-27T02:56:40","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/28_ssas-2008-katmai-upcoming-changes-in-the-next-ctp"},"modified":"2008-03-17T21:07:11","modified_gmt":"2008-03-18T02:07:11","slug":"ssas-2008-katmai-upcoming-changes-in-the-next-ctp","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/28_ssas-2008-katmai-upcoming-changes-in-the-next-ctp","title":{"rendered":"SSAS 2008 Katmai – upcoming changes in the next CTP"},"content":{"rendered":"

Today I participated in the Microsoft webcast “TechNet Webcast: Data Warehousing Enhancements in Microsoft SQL Server 2008<\/a>” (Event Code: 1032344497) by Torsten Grabs. Some information in this webcast was about upcoming changes in SSAS 2008.<\/p>\n

In SSAS 2008 we should expect MDX query performance improvement as now Analysis Services will be able to deal better with\u00a0cube sparsity. Cube space is generally “sparse” – values only exists for small number of dimension intersections. SSAS 2005 evaluates expressions on complete space. With SP2 SSAS 2005 does some subspace computation, but in SSAS 2008 this is improved a lot. SSAS 2008 divides the space to separate calculated members, regular members and empty space. Then it can better evaluate cells that needs to be included in calculations.<\/p>\n

\u00a0There was interesting information presented about SSAS backups.\u00a0I did not know that that for SSAS 2005 backup time grows exponentially for databases over 20GB in size. This is fixed in SSAS 2008 and backup time growth now is linear. Also in SSAS 2008 Analysis Services\u00a0backup storage subsystem will be replaced and all limitations on backup size\u00a0will be\u00a0removed.<\/p>\n

\u00a0\"Backup<\/p>\n

Presenter also\u00a0listed other\u00a0upcoming SSAS improvements, but because of time shortage did not elaborate more:<\/p>\n