InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 24 Nov 2009 14:19:12 GMT20http://www.sqlservercentral.com/Forums/Topic746852-147-1.aspxThanks Yann.Mon, 13 Jul 2009 01:44:53 GMTgareth.hesford-605431http://www.sqlservercentral.com/Forums/Topic746852-147-1.aspxYou could have a look to the Ralph Kimball books or articles if you need a more conceptual approch of dimensions or multidimensionnal modelisation. It's not perhaps the perfect theory but it will fit with the SSAS implementation.Many books ands articles are available:[url=http://www.ralphkimball.com/html/booksMDWT.html]The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset[/url][url=http://www.intelligententerprise.com/showArticle.jhtml;jsessionid=0OOD1MPHH53A0QSNDLOSKH0CJUNN2JVN?articleID=217700810]Kimball University: The 10 Essential Rules of Dimensional Modeling[/url][url=http://www.information-management.com/issues/2007_53/10002149-1.html]Judge Your BI Tool through Your Dimensions[/url][url=http://www.intelligententerprise.com/030101/602warehouse1_1.jhtml]Fact Tables and Dimension Tables[/url]and so on ...Sat, 04 Jul 2009 14:46:22 GMTyann_nguyenhttp://www.sqlservercentral.com/Forums/Topic746852-147-1.aspxDoes anyone have any particular recommendations with regard to the above?I am fairly clued up on basic dimension design but would like to delve deeper and start utilising more of the functionality available in AS. I'm looking for links, articles, books. Anything really. I recently attended a course where the instructor basically poo-poo'd just about every Analysis Services text book available...I'm not looking for something that tells me how to use the wizards. I'm not looking for Books Online (I know where it is!)Am I asking too much?! :crazy:Ta.Fri, 03 Jul 2009 02:02:15 GMTgareth.hesford-605431