Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSAS not reflecting the data type size change

Answered SSAS not reflecting the data type size change

  • Friday, November 30, 2012 1:06 AM
     
     
    Sign In to Vote
    0

    HI all,

     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 .

     

All Replies

  • Friday, November 30, 2012 5:51 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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