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, [...]
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 on some [...]
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 [...]
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 will [...]
When I was working with a SSIS project at a customer, I got the following error.
Error: Could not get a list of SSIS packages from the project.
I had CreateDeploymentUtility=true.
That error description apparently indicate, that there is an error in the dtproj file.
The solution: Set CreateDeploymentUtility=false, and then build the project again. The you will get [...]
SQL server can be started and stoped from the command line like this:
Start: net start mssqlserver
Stop: net stop mssqlserver
The same goes for Analysis Services.
Start: net start “SQL Server Analysis Services (MSSQLSERVER)”
Stop: net Stop “SQL Server Analysis Services (MSSQLSERVER)”
I just created a new web page.
The site is in Danish, and it is a running site, where you can see statistics about yourself and compare yourself to other runners. You can see the site here:
www.perfmon.dk or here: www.performancemonitor.dk
Since the site is in danish, and don’t cover anything technical, it don’t really fit anything on [...]
After reporting services have been idle for a time, the next hit on it can be extremely slow. This is, as with every other RS problem, an IIS thing.
The problem is that when the IIS is not getting any traffic, it “goes to sleep”, to clear up memory for other applications.
That is nice, in the [...]