Yet another irritating error message from reporting services
You will typically get that error, when you try to create a calculated member in the visual designer like so:
IIF( [Measures].[x]=0 , [Measures].[y] , 0,00)
And then use the SUM or another aggregate function on the new measure.
If you create the same calculated member in pure MDX, [...]
In regards to my earlier link to the power pivot blog post, that compared analysis services to power pivot, and discussed when to use what, I also have to throw in a link that compares all the front end BI tools in sharepoint 2010, and discuss when to use what there.
You can find a great [...]
We are in a period in time where MS soon will be releasing a lot of (new) BI technologies, such as sharepoint 2010 which contains among other things: excel services, performance point services and hosting of powerpivot. I guess office 2010 will be released the same date as sharepoint 2010, and here we also have [...]
This is the first part of Introduction to BI.
Before I start with the actual Introduction to BI, I would like to start with an introduction of myself, to clarify what I will be focusing on in this article series.
The last couple of years I have been working with BI on the MS platform, spanning from [...]