Home Forums Data Warehousing Analysis Services Change to Dimension ID and Fact ID from Varchar to Int. Need to sort in Analysis Services RE: Change to Dimension ID and Fact ID from Varchar to Int. Need to sort in Analysis Services

  • January 11, 2013 at 6:55 am

    #1576262

    You'll need to alter the datatype of the attribute

    Edit the dimension and go to properties of the offending attribute. KeyColumns --> DataType needs to be changed from WChar to Integer

    Mack