-
[rsAggregateOfMixedDataTypes] The Value expression for ‘x’ uses an aggregate function on data of varying data types. Aggregate functions other than First, Last, Previous, Count, and CountDistinct can only aggregate data of a single data type
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… Continue reading
-
What BI frontend tool in Sharepoint 2010 should I use?
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… Continue reading
-
Comparing Analysis Services and Power Pivot
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… Continue reading
-
Introduction to Business Intelligence from a developer point of view – part 0
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,… Continue reading
