Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

The attribute key cannot be found when processing a dimension

1 view
Skip to first unread message

nimesh

unread,
Nov 9, 2009, 4:06:41 AM11/9/09
to
Hello Everyone

I have a dimension called DIM_REFERER_MASTER with following columns

referer_id bigint
referer nvarchar(2048)
referring_term nvarchar(1024)

Here referer_id is the key column and referer is the name column.
referring_term is an attribute.
referring_term is a substring extracted from referer

For eg: If referer is
http://www.google.com/search?q=travel
then referring_term = travel.

Now the dimension table has millions of rows in which the referer and
referring_term contain unicode characters.

Whenever I process the dimension, I get following error:

Errors in the OLAP storage engine: The attribute key cannot be found
when processing: Table: 'dbo_DIM_REFERER_MASTER', Column:
'referring_term', Value: 'དངུལ་ཆུ་ཡབ་སྲས་ དངུལ་ཆུ་ཡབ་སྲས་ དངུལ་ཆུ་ཡབ་
སྲས་ དངུལ་ཆུ་ཡབ་སྲས་'. The attribute is 'Referring Term'. Errors in
the OLAP storage engine: An error occurred while the 'Http Referer Id'
attribute of the 'DIM REFERER MASTER' dimension from the 'Test_Cube_1'
database was being processed.

If I remove the referring_term attribute, the dimension processes
successfully.
Also when i create a dimension consisting of only referring_term and
process that, It gets processed successfully.

Can someone please help me.

Thanks
Nimesh

0 new messages