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

The attribute key cannot be found when processing dimension

25 views
Skip to first unread message

nimesh

unread,
Nov 9, 2009, 4:15:26 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