November 14, 2001 at 5:41 am
I've removed 90% of the data from one of my shared dimensions in the source database, but it still (annoyingly) shows up after processing the cube. I've tried changing the storage mode and selecting refresh data and full process, with no luck. Apart from recreating the shared dimension, any ideas on how do I refresh it?
Paul Ibison
Paul Ibison
Paul.Ibison@replicationanswers.com
November 14, 2001 at 8:51 am
Paul,
You have to rebuild the dimension structure and then it will reflect the changes in the cube. Under Shared Dimensions right click on the dimension you have changed. Select Process and then select Rebuild the Dimension Structure. Hit OK and it will repopulate your dimension. I don't think you will need to reprocess the cube but always check to make sure it is working right.
Hope this helps you...
Skip Gallagher
Quest Industries, Inc.
(501) 685-4546
Skip Gallagher
Quest Industries, Inc.
(479) 366-0789
November 14, 2001 at 10:41 am
Works perfectly - 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