Marco Russo's Blog posts of 2011

Page 6 of 89 results

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

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