November 2006 Entries

SSAS: Beware of measure data types
There was a thread today on the Analysis Services forum where someone appeared to be having an issue with a data type overflow. Multiple large, positive, integer values were aggregating up to a negative amount. If you are interested the full thread is here: Re- negative values on a measure Basically the database and the DSV were increased to a bigint data type, but the issue was still occurring. What I believe is happening here is that the measure in the cube was set with an int data type. To fix ......

Posted On Monday, November 27, 2006 1:26 PM | Comments (4)

SSAS: Office 2007 - breaks the calculation tab in BIDS
This probably does not apply to many people yet, but If you have installed the RTM of Office 2007 and don't yet have SP2 of SQL 2005 installed, then your calculation tab in the cube designer is probably broken. This issue may manifest itself in other ways too, its just that I knew this had been an issue during the beta cycle of office thanks to Reed at the Hitachi Consulting blog. There are details here http://sqlug.be/forums/339/... on how to fix this issue. Basically it looks like ......

Posted On Friday, November 17, 2006 2:35 PM | Comments (5)

SSAS: Why can't I pass a Dimension as a parameter to a stored procedure?
The group of us that worked on the Analysis Services Stored Procedure project were having a discussion via email recently and one of the guys lamented the fact that you cannot pass a dimension object as a strongly typed parameter into an SSAS stored procedure. After pondering on this for a little while it occurred to me that, in the change to the attribute based model in AS2k5, dimensions now appear to have become little more than logical containers for attributes and hierarchies. This is in real ......

Posted On Wednesday, November 8, 2006 9:20 PM | Comments (1)

Building Connection Strings the easy way
Chris Webb recently blogged about a conversation that a group of us were having where the topic of the Timeout connection string property came up. Chris asked how I found out about this property. The technique I used is handy for exploring all types of connection string properties, so I thought I would share it here. Create a new text document on your desktop. Rename it to test.udl (its the extension that matters, the name can be anything you like) double click on this file and it brings up a "Data ......

Posted On Sunday, November 5, 2006 9:39 PM | Comments (6)