Cube Build Error

[Database Administrator]

I am encountering an error when building a cube:

Errors in the OLAP storage engine: The attribute key cannot be found: Table:
dbo_TUBE_EVENT, Column: tube, Value: 13734M6811315650.

I have looked at KB922673 but it doesn't make sense because the record
referenced does exist in the table. Any ideas as to what is wrong here?

[Database Administrator]

Do you mean the key exists in both of dimension table and fact table?
If then and some dimension records were added after final dimension
processing,
you should gurantee the dimension is processed again before cube processing.

Ohjoo

"CarolinaKB" wrote in message
news:29ABF4CB-51D4-440D-9558-8EBD51B7C2E6@microsoft.com...
>I am encountering an error when building a cube:
>
> Errors in the OLAP storage engine: The attribute key cannot be found:
> Table:
> dbo_TUBE_EVENT, Column: tube, Value: 13734M6811315650.
>
> I have looked at KB922673 but it doesn't make sense because the record
> referenced does exist in the table. Any ideas as to what is wrong here?

[Database Administrator]

You're right, the key value is not in the fact table. Fundamental
misunderstanding on my part that the key has to exist in both. I was trying
to take advantage of a different relationship to join the records then simply
add the non-key field to the time dimension.

"Ohjoo Kwon" wrote:

> Do you mean the key exists in both of dimension table and fact table?
> If then and some dimension records were added after final dimension
> processing,
> you should gurantee the dimension is processed again before cube processing.
>
> Ohjoo
>
> "CarolinaKB" wrote in message
> news:29ABF4CB-51D4-440D-9558-8EBD51B7C2E6@microsoft.com...
> >I am encountering an error when building a cube:
> >
> > Errors in the OLAP storage engine: The attribute key cannot be found:
> > Table:
> > dbo_TUBE_EVENT, Column: tube, Value: 13734M6811315650.
> >
> > I have looked at KB922673 but it doesn't make sense because the record
> > referenced does exist in the table. Any ideas as to what is wrong here?
>
>
>