February 5, 2013 at 7:15 am
Hallo
I needed to change surrogate keys data type from int to char: I updated the DSV and verified that dimensions properties report actual data type.
Now when I deploy the solution I get the "OLE DB was unable to convert a value to the data type requested for column..." error message.
I tried deleting the database but the deployment stops anyway.
Have you got any hint, please?
thanks in advance!
February 5, 2013 at 12:31 pm
If the error says "OLEDB Error", more than likely the problem is in the data source. If you're using named query or view check if the query is working in SSMS.
Also, check data type of the error column in BIDS. Go to properties of the attribute, expand Key column, see data type is updated.
Is there a reason you're using Char for surrogate key? This could cause serious performance problems. Isn't INT data type solving your need?
Sam Vanga
http://SamuelVanga.com
February 5, 2013 at 4:02 pm
Hallo Sam and thank you for you reply.
Actually query was working, data type in Key columns in BIDS were updated and everything else seemed to be fine. At the end I preferred removing and recreating the two dimensions.
Switching to CHAR hasn't be a good deal. Actually, I wanted to keep trace in the surrogate keys of the sources (the Customer dimension is fed by multiple sources and I horribly thought to prefix the INT with a CHAR denoting the source), but actually here is where the surrogate key comes in hand! So I did quite a little (a couple of hours) big mess, as of my first cube.
I'm gonna take the path of a durable super-natural key from this article of the Kimball Group Reader[/url].
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply