COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: lebronjames on 17 Mar 2009 12:26:35 PM

Title: Non Unique IDs in Data Manager
Post by: lebronjames on 17 Mar 2009 12:26:35 PM
Hey,
I have a hierarchy in DM for Location. Then I have Dim build referencing this hierarchy. But when I execute the build, it says that this hierarchy has 3000 non unique IDs. The the build finishes anyways. All the rows are not processed.

I dont understand what this means or how to fix it. Any insight?

Thanks
Title: Re: Non Unique IDs in Data Manager
Post by: jeamsx on 18 May 2009 12:34:38 PM
You have two options:

1. Configures in the properties of the hierarchy/level to 'leave' this error.

2. The best, find out the solution of that problem. Verify why it's happening, looking for problem in your data (verify the parent members)

DM help has an topic about it.

[]s
Title: Re: Non Unique IDs in Data Manager
Post by: emma on 28 May 2009 03:11:35 PM
Your mapping to the hierarchy is not correct.