Thanks for your reply..SSAS does recognize that it's an integer. Its when I try to sort on dimension attribute in SSRS that it's looks at the data as a string