Kaisa's blog

januar 2006 - Posts

• "Anansi boys" by Neil Gaiman

  The first stories I read by Neil Gaiman were the Sandman stories (graphic novels). Then I read "Good Omens" (with Terry Pratchett as co-author). Last year Bernt bought "American Gods" and "Stardust", and I was hooked on Read More posted 31-01-2006 11:14 by kaisa | (Comments Off) Filed Under: Books

• Using Reporting Services Scripter 2.0.0.2

  I think my RS Scripting days are over. At the microsoft.public.sqlserver.reportingsvcs newsgroup I've seen some references to the Reporting Services Scripter. So today I tried it out myself. And hey! It's very user friendly, and seems to give out way Read More posted 25-01-2006 05:43 by kaisa | (Comments Off) Filed Under: Reporting Services

• So, I'm a total geek - according to Yvette's inner geek blog

  I just did a geek test at http://www.innergeek.us/geek-test.html. I scored a nice 29.59%, with 1% added to the score for being a girl. Still haven't lost the touch. ;) Update: I was awarded Geek of the Week. http://www.innergeek.us/geek-week.html Read More posted 22-01-2006 10:28 by kaisa | 1 Comments Filed Under: IT in general

• Padding null values in MDX

  For a OLAP based report I needed to get numbers for an employee for 4 weeks this year and the corresponding 4 weeks last year, and show it in a Reporting Services report based on a matrix. Creating the basic mdx was not the hardest part, but getting Read More posted 19-01-2006 04:48 by kaisa | (Comments Off) Filed Under: Reporting Services, MDX and Analysis Services

• Testing Windows Vista on a TabletPC

  Unfortunately, my home computer has been feeling a bit low lately, and today Bernt brought it over to the repair shop. I probably won't be seeing it before some time next week. I was going to bring my work laptop home, but when I had to leave work today Read More posted 04-01-2006 10:42 by kaisa | (Comments Off) Filed Under: IT in general

• Testing for scope with more than one subtotal

  For a report, I needed to use a matrix with subtotals on both rows and columns. This is basically what I wrote to the newsgroup to get some help: I have one row group (matrix2_DateWeek_Week) and two column groups. One column group is the Static Read More posted 03-01-2006 01:49 by kaisa | (Comments Off) Filed Under: Reporting Services

• Get the last valid date for a measure

  For a report, I needed to find out when employee X last registered an hour. My measure is called Total Hours (hours can be billable or non billable, but the Total hours will calculate both types, and both types are valid in this report.) My Date Read More posted 02-01-2006 11:07 by kaisa | (Comments Off) Filed Under: Reporting Services, MDX and Analysis Services

• Who moved my "Who moved my Blackberry"?

  On our last trip to London, I bought a book called "Who moved my Blackberry?" at Heathrow. It's written by Lucy Kellaway, who writes for The Financial Times. It's built up based on the e-mail outbox of Martin Lukes, Sales Manager at a-b glöbâl. Read More posted 01-01-2006 10:40 by kaisa | 1 Comments Filed Under: Books