• I just realised that when you create a new dimension using the wizard there are two options.

    When using the first option, (Build dimensions using data source) it assigns the name of the table (view) to the ID of the newly created dimension.

    When using the second option (without using data source) it creates New Dimension, New Dimension 1 etc.

    how can you:

    1. Force it to use a particular name upon creation as ID

    2. Change the ID after the creation?

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM