Thursday, March 22, 2012

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

No comments:

Post a Comment