Problem with Parent-Child dimension -
08-02-2004
, 09:01 AM
I am having extreme difficulty trying to process a cube
in Analysis Services. The version that I am working with
is Version: 8.00.382
I have 4 dimension tables and 1 fact table. When I try
and run a full process on the cube that I built using the
cube wizard, I get the following confusing error message:
A member with key '3' was found in the fact table but was
not found in the set of leaf members of
dimension 'Account'.; Time:7/30/2004 3:03:03 PM
I use the term confusing error message due to the fact
that I have verified the existance of the member with
key '3' in the 'Account' dimension table which is a
parent-child dimension type.
I have removed the Account dimension and reprocessed the
cube with the other 3 dimensions and the cube processes
fine.
Is there a problem with parent-child dimensions that I am
overlooking?
Regards
Jack |