Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error

Status
Not open for further replies.
Dukester0122

Dukester0122

IS-IT--Management
Mar 18, 2003
587
US
Got this error while processing an OLAP cubes the first time:
A member with key '9' was found in the fact table but was not found in the level 'Month' of the dimension 'Date'.
 
Sort by date Sort by votes
It means you have a fact record that does not have a corresponding dimension element.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
Would a date showing 01/01/1900 result to this error?
 
Upvote 0 Downvote
if you do not have a dimension member for 1/1/1900 then probably yes.

Are you using a physical dimension table or allowing AS to create the time dime for you?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
I'm sorry but since I'm new to AS, can you tell me what's the difference?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
229
edvmat
edvmat
jbluedelta
  • Locked
  • Question
OLAP over HTTP and 503 error and connection time out
Replies
0
Views
185
jbluedelta
jbluedelta
fmasin
  • Locked
  • Question
Error HRESULT E_FAIL has been returned from a call to a COM com
Replies
1
Views
80
Shab
Shab
StitoJunior
  • Locked
  • Question
SSAS Process Cube Error with Oracle
Replies
1
Views
54
RiverGuy
RiverGuy
cs2009
  • Locked
  • Question
MS Excel 2010 and MS Analysis Services 2005 XML Parser Error
Replies
2
Views
86
cs2009
cs2009

Part and Inventory Search

Sponsor

Back
Top