MS SQL Server OLAP - The attribute key is a duplicate

Author

The attribute key is a duplicate

Felix_Jiang

2006-01-24, 7:23 am

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\Samp
les\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!

Akshai Mirchandani [MS]

2006-01-24, 8:24 pm

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@discussio
ns.microsoft.com> wrote in message
news:6AD11628-981E-4418-83BB- C3B12E8CC9D2@microso
ft.com...
> 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\Samp
les\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!

Felix_Jiang

2006-01-24, 8:24 pm

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:

> 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@discussio
ns.microsoft.com> wrote in message
> news:6AD11628-981E-4418-83BB- C3B12E8CC9D2@microso
ft.com...
>
>
>

Akshai Mirchandani [MS]

2006-01-26, 4:58 pm

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@discussio
ns.microsoft.com> wrote in message
news:A5A7A352-2609-4DFE-B2F9- A018385E1E38@microso
ft.com...[color=darkred]
> 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:
>

Sponsored Links