dbTalk Databases Forums  

dimension key error

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


Discuss dimension key error in the microsoft.public.sqlserver.olap forum.



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

Default dimension key error - 09-26-2004 , 04:21 AM






I have a problem processing a cube (dimension key error)

The fact table has a column "measureId" which is joined with the "id"
column
from a dimension "measure dimension"

I get the following error
"A member with key '0' was found in the fact table but was not found
in the level 'Id' of the dimension 'Measure'.; Time:26 / 09 / 2004
12:19:23 PM"

the "measure" table already has an "id" entry = 0

Thanks,
Taghreed.

Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: dimension key error - 09-26-2004 , 03:53 PM






have you optimized your cube?
This type of error, generally, doesn't appear if the cube is NOT optimized.

double check if your dimension really contain the ID 0 also do a full
process of the dimension.


"Taghreed" <tssamak (AT) gmail (DOT) com> a écrit dans le message de news:
4100369b.0409260121.43fc80ee (AT) po...OT) google.com...
Quote:
I have a problem processing a cube (dimension key error)

The fact table has a column "measureId" which is joined with the "id"
column
from a dimension "measure dimension"

I get the following error
"A member with key '0' was found in the fact table but was not found
in the level 'Id' of the dimension 'Measure'.; Time:26 / 09 / 2004
12:19:23 PM"

the "measure" table already has an "id" entry = 0

Thanks,
Taghreed.



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.