Errorr (TR2317)

[adnandocs]

I getting a error TR2317 The Level 'Customer Name & DCN' is designated as unique

[tjohnson3050]

When you specify a level as unique, you are saying that a data value used as the source value will never appear more than once.  For example if you create a level for month, and use the month number itself as the source (10 for October let's say) then mark it as unique, it is not unique if you have more than one year.  The value for October 2010 (10) will be indistinquishable from October 2011 (10). 

You need to either not mark the level source as unique, or pick a different data item for the source that does uniquely specify the level.  In the above example, for month you could use a month id field in the YYYYMM format (201010) thus making each month unique.

This concept is the same in any Dimensional Modeling (OLAP/DMR) effort, whether you use Transformer, Framework Manager, SSAS etc.

[rajasekharbathala]

Hi Johnson,

I am facing the same issue, please guide me
For example
Product Dim
Product Line-->prodline_cd and prodline_desc
Product Type-->prodtype_cd and prodtype_desc
Product-->prod_cd and prod_desc

Sales Fact
prod_cd
..
..
..
Total Sales

I have created a model like all dimensions are coming from FM Package as source and all the facts are coming from RS report (List) as a source.
Duplicate values are there in prod_cd because one child having multiple parents. Please help me how to do in this scenario.

Thanks
Bhaskar.

[tjohnson3050]

If one child has multiple parents, then the members of that level (product), are not unique.  Therefore, do not mark that level as unique.