Analysis Manager

Last Post 22 Apr 2006 06:40 AM by SQLUSA. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
LostFromTheStart
New Member
New Member

--
20 Apr 2006 11:22 AM
Hi All,

I am new to Analysis Services. I have a cube, someone else created. It was working fine for the past 3 years and not it is getting the following errors.

A member with key '20060420' was found in the fact table but was not found in the level 'Day' of the dimension 'Creation Dates'.; Time:4/20/2006 2:52:10 PM
A member with key 'StoreyJames' was found in the fact table but was not found in the level 'Name' of the dimension 'Callers'.; Time:4/20/2006 2:52:10 PM
A member with key 'DenLijuan' was found in the fact table but was not found in the level 'Name' of the dimension 'Callers'.; Time:4/20/2006 2:52:10 PM

Does anyone know what might be causing the error?
Is there a limit in Analysis Server for record count?

Thanks
SQLUSA
New Member
New Member

--
22 Apr 2006 06:40 AM
Yes everything has a limit. It looks like your dimension table missing some rows.

Normally you just reprocess it. If it hit the upperlimit, you have to redesign.

Kalman Toth
http://www.sqlusa.com/datawarehouse/
hmortada3
New Member
New Member

--
29 Apr 2006 10:51 PM
ensure that there is a FK Relation between the fact and dimension tables to ensure the data integrity
rebuild the 'Creation Dates' dimension and Callers Dimension then reporcess the cube
SQLUSA
New Member
New Member

--
02 May 2006 01:43 PM
If the cube processed before, that cannot the the problem.

But who knows. Check everything.


Reprocess (full) each dimension, then cube.

Kalman Toth, Database, Data Warehouse and BI Architect
http://www.sqlusa.com
The Best SQL Server 2005 Training in the World


Acceptable Use Policy
---