![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |