As you may have noted, I started using hashtag in titles of my blog posts. The reason is pretty simple: every post is automatically twitted through my account ( @marcorus ) and in this way they can be easily reached also by people monitoring particular  Read more

If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you: it appears  Read more

I’ve been at SQL Pass and it has been a really great conference. I will write soon more technical content, there are a few notes about the good and the bad of the overall experience that I’d like to share. The keynote of David J. Dewitt has been great.  Read more

Thomas Kejser and Denny Lee released the new Analysis Services 2008 R2 Performance Guide . This is an absolutely must read for any SSAS developer. Remember that many of the optimizations are obtained by doing a proper cube design. Thus, the paper has  Read more

Boyan Penev announced the availability of DateStream project on CodePlex: it is a data feed that can be consumed by PowerPivot but also to generate a calendar table for any type of usage. Yes, Analysis Services has a wizard, but when you are in a hurry  Read more

I just returned from my second SQLBits , this time in Liverpool, and I have to say it is a really great conference. Everything can be improved, but I have to say that it’s hard to find a conference where you can have more networking opportunities than  Read more

SQLCAT team just announced the first SSAS Maestros and I’m happy to be part of them! I already know many of them and I’m more than happy to see that also Alberto and Chris, who co-authered the Expert Cube Development with Microsoft SQL Server 2008 Analysis  Read more

Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be applied  Read more

link In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago . The sad answer is that this feature is not supported  Read more

As I already announced on this blog some weeks ago, there will be a PowerPivot Workshop in Lisbon (Portugal) on September 19-20, 2011. The evening of September 19 there will be also a free community event in Lisbon where Alberto will speak: you can find  Read more