One of the columns in a dimensional table I use is having the data type
changed from a Small Int to an Int within the next few weeks.

Is this something I should be concerned about in Analysis Services?

Nope.
Internally most storage is done via Int's (or bitmaps) anyway.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Thanks again for the quick response.

The Key Data property type says small int, and remains that way after the
change - should I change this to use Int?

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote