I have created a shared dimension on a cube and from time to time I get the
error "A member with key ' ' was found in the fact table but was not found
in the level ' '...." After I reprocess the dimension it is fine. My
problem is that I have a SQL Job that refreshes the cube each night and
when I arrive at work in the morning the cube has refreshed successfully
but my shared dimension has been removed from the cube and I have to add it
back to the cube. Is there a way I can work around this problem? Is the a
script that I can use to process the dimension first and then run the cube
refresh?

Thanks.

Eric

--
Message posted via http://www.sqlmonster.com

back to the cube.
What do you mean by this? If it means literally as it is, it must be a very
very critical bug.

If it means just needs of dimension reprocessing, of course, you may need to
reprocess the related shared dimensions with proper option depending on the
situation before cube processing. For example, if you add new product record
to the product dimension table and new related facts to the fact table, it
needs at least incremental update of the product dimension before cube
processing.

For script, you refer to DSO programming.

Ohjoo Kwon



"Eric Wiltrout via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote