How to refresh fact table structure?

  • Me again! I've added some columns to my fact table and want to use them as measures. However, they don't appear in the table in the cube editor - any ideas how I can refresh the structure of my fact table?

    Paul Ibison

    Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • Paul,

    In order for the new measures to show up in the fact table, you have to refresh the data source. In Analysis Manager, select the Data Source folder for the database. Right click on the data source and select Refresh. Now you can edit the cube and the new measures should be there.

    Skip Gallagher

    Quest Industries, Inc.

    (501) 685-4546


    Skip Gallagher
    Quest Industries, Inc.
    (479) 366-0789

  • Had assumed it would be somewhere logical like a right-click on the fact table, and the OLAP books I've got mention refreshing of data, not new fields so I was completely stuck, but this works well : thanks Skip.

    Paul Ibison

    Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply