SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus
Alberto Ferrari posted an interesting article that show how you can use a continuous value in a group of values in PowerPivot. I think this is a feature that many users would like to get in a standard Analysis Services cube, but that unfortunately requires to change the cube structure on the server, something that an end user is not allowed to do.
Having such a flexibility in PowerPivot is one of the reasons it should be adopted by data analysts and advanced Excel users to do advanced analysis in a more autonomous way. The same topic is covered in more details in the Microsoft® PowerPivot for Excel® 2010: Give Your Data Meaning book (which is finally in stock – I just received my hard copy a few days ago and I’m happy it is now on my shelf, too) and will be of course discussed in the PowerPivot Workshop on Dec. 1-2, 2010.
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Marco Russo (SQLBI)
Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.