Hi, I encountered a problem when I do the following:
1. I deployed the pre-installed project in "C:\Program Files\Microsoft SQL
Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard" to
SQL Server 2005.
2. The AS DB appears in SQL Server Management Studio as "Adventure Works DW
Standard Edition".
3. Right-click the "Geography" dimension and set to ROLAP in "Proactive
Caching".
4. Unchecked "Use default error configuration" and set "ReportAndStop" for
"duplicate key" in "Error configuration".
5. Process fullly the "Geography" dimension and the cube.
6. Open MDX Sample application and run the query:
Query the cube using the following via MDX Sample Application
select {measures.defaultmember} on 0,
{[Geography].[Geography].[City].members} on 1
from [Adventure Works]

I got an error message: Errors in the OLAP storage engine: The attribute key
is a duplicate.

I think the problem is because I enabled the "ReportAndStop". Without
enabling this, things just work fine.
So I guess there must be something happening there that causes the duplicate
error. Can you help me to explain why? A million thanks!

Is there a particular reason that you want to change duplicate key to
ReportAndStop?

ROLAP dimensions do processing of dimension data in a slightly different
manner than MOLAP dimensions -- the duplicate key error configuration is
mostly available for MOLAP dimensions to look for unexpected integrity
violation issues.

In the ROLAP case, this duplicate key issue can occur more naturally and
therefore I suggest that you restore this option to the default value...

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"Felix_Jiang" <FelixJiang (AT) discussions (DOT) microsoft.com> wrote

Hi Akshai,
Thanks for your reply. Is there any resource available on how ROLAP
processs dimension data in terms of duplicate key issue? Thanks!

"Akshai Mirchandani [MS]" wrote:

Duplicates are skipped. The first instance is used...

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Felix_Jiang" <FelixJiang (AT) discussions (DOT) microsoft.com> wrote