Hi , all

Here is the attribute key can not found error I am getting while
processing the cube



Errors in the OLAP storage engine: The attribute key cannot be found:
Table: dbo_vw_page_view_archive, Column: keyword_term, Value: ᪷.
Errors in the OLAP storage engine: The record was skipped because the
attribute key was not found. Attribute: Keyword Term of Dimension:
Keyword Term from Database: skenzo_3, Cube: Skenzo_3, Measure Group:
Views, Partition: Vw Page View Archive, Record: 6963730. Errors in the
OLAP storage engine: The process operation ended because the number of
errors encountered during processing reached the defined limit of
allowable errors for the operation. Errors in the OLAP storage engine:
An error occurred while processing the 'Vw Page View Archive' partition
of the 'Views' measure group for the 'Skenzo_3' cube from the skenzo_3
database.



Here in error details in second line it displays keyword_term,
Value: ᪷.

But in Analysis service it display box instead of ?

Can anyone guide me

Thanks

It sounds like you have a record in your fact table which does not have
a corresponding member in your dimension. This is typically handled in
ETL with the dummy handler (-1 surrogate key). In SSAS 2005 it can
handle this for you if the unknown hadler is not implemented in your
ETL.

Go to your dimension property and set the UnknownMember property to
Visible. This will create another member called Unknown. Additionally,
you can go to your measure group and set the ErrorConfiguration to
custom.

On Nov 6, 9:50Â*pm, sqlpr... (AT) gmail (DOT) com wrote: