-
Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap: PASS Business Analytics Conference 2014 – May 7-9, 2014 – San Jose,… Read more
-
I recently discovered a few pitfalls on memory configuration of SQL Server Analysis Services 2005: the main problem is that the default configuration (written by setup) doesn’t consider the actual physical resources (mainly RAM) of your server and this can… Read more
-
I recently had some problem with memory configuration of SQL Server Analysis Services 2005 and I’d like to share lessons I got. This post is a replacement for my previous post, that I striked to keep history of some bad… Read more
-
Two days ago I did the 70-445 exam in beta (TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance). I cannot talk about the exam content, but I think I can talk about the exam in general. As… Read more
-
PowerPivot for Excel is an Add-In which uses a local version of Analysis Services (SSAS) to process data and make calculation to respond to user queries made using Excel 2010. The SSAS engine is loaded in-memory in the process of… Read more
-
You know, selecting calculated members in Excel is not an option. I talked about this issue more than three years ago for the first time: http://www.sqlbi.com/blog/marco/2007/01/31/excel-2007-pivottable-with-calculated-members/ http://www.sqlbi.com/blog/marco/2007/03/07/ssas-2005-sp2-breaks-excel-calculated-member-selection/ http://www.sqlbi.com/blog/marco/2008/12/08/ssas-2008-calculated-members-still-don-t-love-excel-2007/ The upcoming new versions of SQL Server 2008 R2 and Office 2010… Read more
-
Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will… Read more
-
After many conferences and travels, this summer I had some time to write and prepare new sessions for the next wave of conferences. In reality I am just doing that, even if I already restarted traveling for consulting and training.… Read more
-
I wrote an article about how to get the Last Process Date in SSAS Tabular. This is a common request and there are many ways to obtain this information. You can use the metadata provided by XMLA or DMV, just… Read more
-
It is available the new edition of the advanced OLAP book, now called “Expert Cube Development with SSAS Multidimensional Models”. The previous edition was titled “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services” and the biggest issue of… Read more