November 30, 2007
Though I didn't do it alone…The slogan for Ikea is "dreams to take home with you". For me it was a bit of a dread. It started just by going there after having heard about how crowded it gets there on the weekend. Don't know if it's because we arrived in the evening, but it was actually a lot less crowded than it was last time I went there in the middle of the week! I went there with my boyfriend to pick up a kitchen trolley. We waited about a month for the local branch it to get...
November 21, 2007
Well I guess congratulations are in order because I finally got around to using a report builder in my project. Turns out that building a report model based on a cube is as easy as 1-2-3. Still I had a problem, as for some unknown reason the translations were showing for my dimension names and my measures, but not for the dimension's attributes... At first I thought maybe this is a problem solved by Service Pack 2 (as my tests were done on a Server with Service Pack 1). Alas, no. So, a further look in the MSDN library,...
November 20, 2007
Yes, it's true, it's finally here! The latest version of Microsoft SQL Server 2008 CTP just got released and it includes all sorts of goodies – especially for us developing on SSAS. The general highlights include:
T – SQL intellisense
Analysis Services MDX Query Optimizer - Block Computation
Analysis Services Aggregation Design
Lookup Enhancements for SSIS
Robust Report Server Platform
Microsoft is urging you to download it and send them feedback so as to refine and enhance product features. The CTP will automatically expire after 180 days. The download is available here. The CTP version of SQL Server 2008 Express Edition is...
November 12, 2007
Just in case you were also looking for the SQL Server 2005 Sample Database, then you should know Microsoft has chosen to move it to the CodePlex site. SQL Server 2008 July 2007 CTP Samples are also available on the same site. I recommend downloading the versions which are marked in the end with CI as they enable a Case Insensitive search within them. The LT version is also CI.
I really love the way Adventure Works gives you an entire look on the abilities of SQL Server.
Well I guess we could all see that one coming: IBM has just announced that it intends to acquire Cognos. News of the intentions themselves surfaced some time ago, and I guess the latest news in the area helped make the final budge. The amount of independent BI companies is again slimming down.
November 9, 2007
Continuing my theme of looking at things in the appropriate place, I thought I'd add another story. I was just building a report in Reporting Service, and defined the TextAlign property of the line to be "right". For some reason, when I previewed the report in the Visual Studio on my pc, in some cells the alignment was left and in some it was right.
I found in a few occasions, that when it comes to viewing your report in SSRS, you should define all of your needs in the report and then deploy it to the server. It's...