November 15, 2001 at 4:06 am
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
Paul.Ibison@replicationanswers.com
November 15, 2001 at 8:35 am
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
November 15, 2001 at 9:53 am
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
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