dbTalk Databases Forums  

Problem with Parent-Child dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problem with Parent-Child dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jack Oney
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.