sql server data warehouse: errors processing cube -- sql server data warehouse

Re: errors processing cube

Jacco Schalkwijk
1/7/2005 4:27:00 PM

sql server data warehouse:

You need to reprocess your dimension. When a dimension is processed the data
in it is stored in a different data structure independent of the actual
dimension tables, and additions to the dimension tables won't be included in
the dimension unless you process it again.

--
Jacco Schalkwijk
SQL Server MVP

[quoted text, click to view]

errors processing cube

Nestor
1/7/2005 11:52:42 PM

i'm facing some difficulties in trying to process a 3 dimensional cube.
Everytime i try to process this cube it'll complain that "A member with key
"(something)" was found in the fact table but not found in the level
(dimension level's name) of the dimension (dimension name)

anyone got similar experience in this? i've check that the fact table ids
are all present in the dimension tables.... what could be wrong? please
help...