Foreign key missed

From: "ad" <flying@xxxxxxxxxxxxxxx>
Date: Thu, 6 Dec 2007 10:15:52 +0800

I have a dimension table Schools, and a fact table name Order in a cube

It failed when I manage the cube, the error message is "There are some
foreign in the fact table does not exist in the dimension table"

I can't add the missed record into the dimension table.

How can I solve this problem?

.

Prev by Date: Re: Problem deploying and processing
Next by Date: RE: Analysis Service Shut Down during process - Out of Memory
Previous by thread: Error browsing dimension
Next by thread: RE: Analysis Service Shut Down during process - Out of Memory
Index(es):
- Date
- Thread

Relevant Pages

Re: Analysis Manager Operations extremely slow
... both RDBMS SMO and Analysis Services ... testing domain authentication. ... cube editor slowness if connecting to Oracle. ... Gender dimension to "M" and still browse the Sales cube. ...
(microsoft.public.sqlserver.olap)
Re: Error processing cube with disabled lowest level of shared dimension
... come across the error message you described if the error condition ... SRL wrote: ... Dimension is snow-flaked. ... > When processing the cube, I get a 'member with key '' was found ...
(microsoft.public.sqlserver.olap)
Re: The attribute key cannot be found (a new twist in the story)
... Not sure whether this fits your scenario, but I've seen this error message on ... I have actually solved my problem by deleting the dimension and creating it ... it will cause key errors during cube ... I'd run a trace (if you're using SQL Server RDBMS) to ...
(microsoft.public.sqlserver.olap)
Re: Automatic MOLAP questions
... there is a lock when the polling query is evaluated. ... when you execute a polling query, the result of the query and the previous datetime can be used to do an incremental processing. ... so an incremental process only add content in a cube and can't update the cube. ... SSAS will not try to process the dimension. ...
(microsoft.public.sqlserver.olap)
Re: SSAS2005 - When do partitions need to be processed?
... InsertCubeProcessingLog("Process Dimension All End", 1, 1, BeginTime, Now, ... The actual processing of partitions doesn't appear to be significant here ... Processing Cube 'Sales Current' completed successfully. ... With AS2005 there is a proactive caching option at the dimension level, ...
(microsoft.public.sqlserver.olap)