O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adjusting the number of columns and rows for OWC and Excel

We started the chapter with calculating the number of rows and columns a query returns. We saw that the correct numbers are not always easy to get. We stopped there and focused ourselves on detecting the axis with measures followed by the opposite case, the axis without them. Once we know how to do that, we can make adjustments to the initial calculation for number of columns and rows, which brings us to this recipe.

Getting ready

Open the Business Intelligence Development Studio (BIDS) and then open the Adventure Works DW 2008 solution. Once it loads, double-click the Adventure Works cube and go to the Calculations tab. Turn on the Script View and navigate to the end of the MDX script. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required