dbTalk Databases Forums  

OLAP cube build failed - Project Server 2002

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OLAP cube build failed - Project Server 2002 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Phil_M
 
Posts: n/a

Default OLAP cube build failed - Project Server 2002 - 04-04-2005 , 11:31 AM






I have received the following error message when trying to build an OLAP cube
in MS Project Server 2002:

The cube scheduled to be built on 04/04/2005 at 02:12 failed.
(-2147221384) Detected two sibling members with the same name: (Level 02).

Can anybody shed any light on what this error means.

Thanks

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: OLAP cube build failed - Project Server 2002 - 04-05-2005 , 01:49 AM






I would ask that on the Project Server newsgroups (sorry, I don't know what
they are).
PS uses a very specialized OLAP design for their structures.
However, in general for Analysis Services, that error is returned if the
level uniqueness is set to UniqueNames within a level but the data doesn't
support it.

For example, suppose you had two employees named Bill Smith (a very common
name). You need to set the level member names uniquess to be false. This
means that the system will build a unique name by appending the parents up
the tree. However, you should make level member names unique for
"Products" -- you wouldn't want to have two products called exactly the same
thing. In this case, the level unique names should be true.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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

Quote:
I have received the following error message when trying to build an OLAP
cube
in MS Project Server 2002:

The cube scheduled to be built on 04/04/2005 at 02:12 failed.
(-2147221384) Detected two sibling members with the same name: (Level 02).

Can anybody shed any light on what this error means.

Thanks



Reply With Quote
  #3  
Old   
Phil_M
 
Posts: n/a

Default Re: OLAP cube build failed - Project Server 2002 - 04-05-2005 , 08:45 AM



Thanks for your help, I've found the Project Server newsgroup so I'll ask
there.

"Dave Wickert [MSFT]" wrote:

Quote:
I would ask that on the Project Server newsgroups (sorry, I don't know what
they are).
PS uses a very specialized OLAP design for their structures.
However, in general for Analysis Services, that error is returned if the
level uniqueness is set to UniqueNames within a level but the data doesn't
support it.

For example, suppose you had two employees named Bill Smith (a very common
name). You need to set the level member names uniquess to be false. This
means that the system will build a unique name by appending the parents up
the tree. However, you should make level member names unique for
"Products" -- you wouldn't want to have two products called exactly the same
thing. In this case, the level unique names should be true.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Phil_M" <Phil_M (AT) discussions (DOT) microsoft.com> wrote in message
news:6685D617-3104-4561-9119-C26636F01A3C (AT) microsoft (DOT) com...
I have received the following error message when trying to build an OLAP
cube
in MS Project Server 2002:

The cube scheduled to be built on 04/04/2005 at 02:12 failed.
(-2147221384) Detected two sibling members with the same name: (Level 02).

Can anybody shed any light on what this error means.

Thanks




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.