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

  • Strange as that would of been my first point to look at, as it seems to be the most logical.

    Have you tried using a calculated column using a cast operator to implicitly change the data types (shouldn't have to if the DSV is correct but might be worth a shot).