Marco Russo's Blog posts of 2011
Community Events in Paris and Brussels after PowerPivot Workshop #ppws
Next week I will be in Paris and Brussels for two editions of the PowerPivot Workshop . The evening after the first day of the workshop is always a good chance to meet people from local communities and I am happy there will be two community events, too! Read more
Some more comments about XLCubed
Some weeks after my blog post about Bonavista Dimensions I’ve been able to look at a comprehensive demo of XLCubed , but since then I’ve been too busy to write about that (and in general to blog – I have several topics I will blog about as soon as the Read more
Recursive calculations in MDX #ssas #mdx
Jeffrey Wang wrote a very detailed blog post about recursive calculations in MDX with Analysis Services. In these days I’m doing some comparison between DAX and MDX (well, between Vertipaq/PowerPivot and OLAP/SSAS engines) and I’m discovering that MDX Read more
PowerPivot Workshop in Sweden, France and Belgium #powerpivot #ppws
April has been a month full of conferences and May will be full of workshops! I’m also working on other things and I hope to be able to publish more technical content in my blog very soon! In the meantime, we just announced an edition of the PowerPivot Read more
#powerpivot workshop in France and Belgium and other conferences #ppws #sqlbits #mstc11
As I blogged last month , the spring is a season full of events and this is a reason why I’m not writing technical articles in these weeks. But I promise I’ll write again in a few weeks, there are a lot of interesting ideas that need to be written down. Read more
The #sharepoint 2010 developer reference book
As you might know, I wrote three books about LINQ with Paolo Pialorsi. He’s an expert in SharePoint development and after one year of tough writing it is finally available its Microsoft SharePoint 2010 Developer Reference book. If you want to write code Read more
SQL Pass meeting in Zurich after #powerpivot workshop #ppws
These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up! Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and Alberto Ferrari will present Read more
More on importing Measures from SSAS cube in #PowerPivot
Several months ago I wrote about the issue importing measures from an Analysis Services cube in PowerPivot. The short story is that, when you define the MDX query, all columns are imported as Text. Of course, this is not a good thing for the numeric measures. Read more
The Last Ever Non Empty calculation in MDX
Chris Webb posted a wonderful solution to the Last “ever” non empty calculation in MDX . I never thought to this solution and it is really a nice approach. I think that DAX might be faster in this scenario – a similar calculation has been shown in this Read more
Import briefing book from ProClarity
A common feature request for PerformancePoint is importing a briefing book from ProClarity. As far as I know, this is not available. Today (thanks to a tweet from @denglishbi ) I discovered a product, Pyramid Analytics bioXL , which has a specific feature Read more