October 27, 2009 at 10:57 am
Hi all,
I've just finished porting a number of SQL 2000 cubes into 2005 and discovered the new implementation of drillthrough, in that you now drill down to the dimension attributes rather than directly to the underlying database table. Mostly this is not a problem, I understand the reasons why the designers have done this and have configured my drillthrough actions to suit.
However, there are a couple of data items that I'd like to expose via drillthrough (client address fields), but without the overhead of making them dimension attributes which will need processing to update (reasonably) regularly.
I don't see the point of making the address part my client dimension as it's not something you can aggregate on and contributes to processing overhead. However, it was useful in 2000 to be able to drillthrough to the underlying table to get the data. Is there an easy way to do this in 2005? I would guess there would be some sort of Action I could write with some embedded SQL in it, but I'm not really sure where to start.
Other than that, SSAS 2005 is fantastic 😀
Cheers
PSB1
December 12, 2009 at 7:37 am
You want to do a rowset action. It's a little more difficult to do in 2005 though. Here's a blog that walks you through it. http://www.bidn.com/blogs/BrianKnight/ssis/68/creating-a-rowset-action
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply