January 2, 2010 at 1:29 am
Greetings everyone 🙂
I am creating a DSV (which I have done a few times before so I know enough to build a cube!) and when i get to the part where I create the relationships, I get an error connecting to certain dimensions because of a datatype conflict between the column on the Fact table to the data type on the Dim table (bit vs int32). The problem is; in the tables themselves both columns are tiny int columns. In the dimensional table there are 6 values (1 through 6) on said key column, whereas the Fact table only is using 2 of these values currently (5 and 6). I do not know why everytime I try to create a CSV that it makes this a byte column, but it is preventing me from being able to build my cube properly! Is there a way to correct this?
Link to my blog http://notyelf.com/
January 4, 2010 at 2:05 pm
Yea, stinks huh. I ran into this same thing a while back. Do you have the IDENTITY property set on that column?
Here's a thread that may help: http://www.sqlservercentral.com/Forums/Topic795889-17-1.aspx?Highlight=rowan+dsv
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply