Adding a column to a Fact table in Analysis Services 2000

How do you add a column to a fact table?

I added a column to the SQL table that the cube is based on "FactVoyage". I then went to Analysis Manager refreshed everything, and edited the cube. the table "FactVoyage" shows on the Schema tab, but the new column does not appear. I presume there is some trick apart from deleting the Table and reinserting it?

Thanks

Ignore that! There is something totally dodgey with the datasource so I need to fix that first

Add numeration to a table

Hello.

Whats the easiest way to add a column with a numeration to my table?

I want the users to have an easier life finding on which row they are talking.

I preffer of course doing it in reporting service and not adding a column in my dataset.

Thanks.

I found it:

RowNumber(Scope)

Thanks