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