September 30, 2009 at 10:50 am
OK, I'm a bit frusterated with BIDS. I'm working on creating a cube and when I create the Data Source View, it is not pulling the correct data types from the database metadata. Specifically, one of my lookup tables has a tinyint primary key. The DSV shows that value in my fact table as a byte and in the lookup table as int32. I've opened the DSV in the code viewer and tried to edit it manually with no luck.
Am I missing something simple?
October 2, 2009 at 12:10 pm
Really, nobody has seen this before or has any insights into what I'm seeing?
C'mon folks!!
October 2, 2009 at 1:45 pm
OK, so I've found that this is a bug. The bug was reported quite a while back and there appears to not yet be a fix for it.
When you have a tinyint datatype PRIMARY KEY on one of your dimensions and the PK has the IDENTITY property set, the DSV will not properly pick the data type of that column.
My workaround was to remove the IDENTITY property from my dimension. I was able to do that as the dimensions in question held a small # of static lookup data.
October 2, 2009 at 3:09 pm
Good to know. Hopefully when we get thereI'll still remember. 😉
October 2, 2009 at 3:13 pm
An alternate workaround could have been to replace the table in the DSV with a named query and used the CAST funtion inside the query. I chose to change the table because it was easy and I'm building something new from the ground up here anyhow.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply