Fact table data type question for multidimentional cube preperation


  • If I have a source data mortgage amount stored in an integer, but if this value is summed nationwide is too big to fit in an integer and will cause an overflow, do I leave this column as integer in fact table instead of bigint to save space and analysis services can take care of overflow or ?

    If I leave the column as integer in fact table do I need to be customizing these type columns that can cause overflow in analysis services ?

    Thank you

    Gokhan Varol

    Tuesday, July 23, 2013 12:54 AM