• I would make sure that you have processed the dimension first and then try processing the cube. Typically data will get refreshed in the fact table and you will need to make sure that you have updated the dimension first before processing the cube (measures groups and partitions).

    I would also recommend using integer values for the key to the dimension table and also in the fact table. You will get much better performance with processing, look ups, and indexing.

    I would recommend checking out the following site for design tips and practices http://kimballgroup.com. They have a monthly tips newsletter you can sign up for also if you find this type of information helpful.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com