Friday, November 30, 2012 1:06 AM
I have a cube which has a dimension DimReasonCode . Initially when the cube is created the data type length of reason code attribute was 50 as nvarchar(50) , but recently we changed it to 256 as nvarchar(256) . But when i do dsv refresh it is not automatically reflecting the data type length change, and in the dimension it is still showing the length as 50 for ReasonCode attribute of DimReasonCode dimension . Due to which our cube process failed in production for data truncation in dimension ,As the database table of that dimension is having 256 but the in cube it is having 50
So i changed it manually to 256 then did a process . it worked fine.So every time do i need to change the length manually for every change of datatype length in backend . Can't SSAS do it automatically ?.
Please help me .
Friday, November 30, 2012 5:51 AMModerator
SSAS does not automatically flow data type changes from the DSV to attributes and measures. It probably should if the data types at the source are wider than the destination, but it does not do this at the moment.
There is a feature in BIDS Helper http://bidshelper.codeplex.com which will check the data types of your SSAS objects against the DSV.
http://darren.gosbell.com - please mark correct answers