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