stevienova.com

Named Sets in SSAS 2005 (SQL Server Analysis Services 2005) are a good thing. You can set up named sets for things like “Last 3 months” or “Yesterday” which is really nice for end users. The nature of dates is that you can make the MDX dynamic but yet the named set is still “static”.
You [...]

In SSAS (SQL Server Analysis Services), if you have a measure group, with some measures as AggregateFunction of Sum and some of AverageOfChildern, you will see a red squiggly line on the measure group and if you highlight it (or build the cube), you will get this error:
Semi-additive measure requires a time dimension.
The problem starts [...]

If you are deploying/building a cube in SQL Server Analysis Services (SSAS), and you get tons of errors, and littered throughout you see
OLE DB error: OLE DB or ODBC error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.; 28000.
You should take a look at your data sources, and on the impersonation tab, play around with the [...]

So, a while back I fired up Visual Studio 2005, and was making some Reporting Services reports. I need to do some custom MDX, and was getting errors trying to exceute it. WTF right?
Query preparation failed. -> Error in the application. (msmgdsrv)
Nice error, as always. So, did some digging, and actually found a hack around [...]

If you ever have written any Reporting Services reports off a cube (Analysis Services), and want to have a drop down that auto picks a day, this is for you. There is probably a more elegant way to do this, but it works.
=”[Time].[Calendar Date].&["& Year(DateAdd("D",-1,DateTime.Now())) &"-"& IIf(Len(Month(DateAdd("D",-1,DateTime.Now()))) < 2,Month(DateAdd("D",-1,DateTime.Now())),"0"&Month(DateAdd("D",-1,DateTime.Now()))) &"-"& IIf(Len(Day(DateAdd("D",-1,DateTime.Now()))) < 2,"0"&Day(DateAdd("D",-1,DateTime.Now())),Day(DateAdd("D",-1,DateTime.Now()))) &"T00:00:00]”
Remember, months [...]