-
MS, seriously!!! SSIS and System.Runtime.InteropServices.COMException (0x800A03EC)
Let me describe my problem. Maybe you have the same, if you have googled for the error code, and found this page. So, I’m downloading an old Excel file from a German webpage. The Excel file is in a spreadsheetML format, which is impossible to read from SSIS. No worries, I can easily with a… Continue reading
-
OLE DB error: OLE DB or ODBC error: Invalid column name ‘x’.; 42S22.
After spending time debugging my analysis services cube for the second time having this error, I guess it will be a good idea to blog about it, so I can remember it to another time 🙂 I got the above error after I had modified a dimension, so used it three fields for the key,… Continue reading
-
Warning: Null value is eliminated by an aggregate or other SET operation
I just had a SSIS package that had been running every day for the last couple of years without any problems, which failed on me with the following error message: Warning: Null value is eliminated by an aggregate or other SET operation The SQL source had a group by, where I was taking a minimum… Continue reading
-
[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
-
SharePoint 2010 Public Beta is finally available for download – oh yeah 🙂
Try it here: http://www.microsoft.com/2010/en/ For more info and guides, read the article on the MS SharePoint Team Blog: http://blogs.msdn.com/sharepoint/archive/2009/11/18/sharepoint-2010-public-beta-is-now-available-for-download.aspx Continue reading
-
Why I don’t think powerpivot will be a success
Just returned from the sharepoint 2009 conference, I’m really excited about all the new BI stuff. One of the things I’m really excited about is powerpivot. As you might have guessed from the title, I’m going to elaborate on why I don’t think powerpivot will be a success, in the sense I don’t think it… Continue reading
