<< CPU percent limit in .Net | Home | adding a fact table to a SSAS 2005 cube >>

SSAS cube: "attribute key not found" error

I just spent over an hour trying to figure out why my data tables were correct but I was getting an error about an attribute key not being found (i.e. an unlinkable foreign key).   I finally figured out that processing one dimension at a time before processing the cube can get fix whatever is out of sync.  [Right-click on the dimension in Solution Explorer to process it separately.]

Print | posted on Wednesday, February 06, 2008 11:05 AM

Comments on this post

# re: SSAS cube: "attribute key not found" error

Requesting Gravatar...
Try processing all of the dimensions in parallel instead of serially. The following is an example of the XMLA query (replace the dbid and dimension id's with yours):

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<Object>
<DatabaseID>CubeDB</DatabaseID>
<DimensionID>Dimension2</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<Object>
<DatabaseID>CubeDB</DatabaseID>
<DimensionID>Dimension2</DimensionID>
</Object>
<Type>ProcessUpdate</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Left by ManicArchitect on Apr 09, 2008 2:34 PM

Your comment:

 (will show your gravatar)
 
Please add 6 and 5 and type the answer here: