Errors in the OLAP storage engine: A duplicate attribute key has been found when processing

When processing a dimension caught the error "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dimension', Column: 'attribute', Value: 'reclamação'. The attribute is 'attribute'.".

Analysing the data source found two records:
1 Reclamação
2 Reclamacão

 The requirement was that these two values are the same. So, the error was because SSAS issued a distinct count for the attribute using the column collation and then used the SSAS collation. The collation of the database was "SQL_Latin1_General_CP1_CI_AI" and the collation for SSAS was "Latin1_General_CI_AI".

The solution was changing the collation of the database column from "SQL_Latin1_General_CP1_CI_AI" to "Latin1_General_CI_AI".

This link help a lot.

 Regards,

RS: Selecting the All Level by defaul

Selecting All the values by default in a Analysis Services parameter:

http://www.codeprof.com/dev-archive/140/19-82-1402720.shtm

(...)
This isn't exactly what you're looking for (default to the "select all" option), but may work for you...

Set the default on your parameter to 'From query' and then point it to the same query that populates the available values. This way, all of the values will be selected.

Hope this helps.

Jarret
(...)

link

link

http://wm.microsoft.com/ms/msdn/office/2007officevisualhowtos/moss2007creatingbusinessdatacatalogs.wmv

link

Isto é mais um bookmark pessoal do que outra coisa.
Utilidades para máquinas windows.

This is more than a personal bookmark than anything else.
Tweaks for windows boxes.

http://www.onecomputerguy.com/windowsxp_tips.htm

1st post

Este blog vai falar de tecnologia. Links, informação e tudo o que considere que possa contribuir com alguma mais valia de conhecimento.
Espero que gostem.

This blog will talk about tecnology. Links, information and everything that I think that can contribute with an added value of knowledge.
Hope you like it.