KB8725: Attributes fail to display all expected elements or displays incorrect data when used in a prompt in Microstrategy Developer 9.x and 10.x

SYMPTOM:
The following procedure uses Strategy 9.x and 10.x to illustrate the issue.
 
Create an attribute named Copy_Region based on warehouse table named COPY_LU_REGION. This table contains the following data:
 

 
The attribute Copy_Region contains a form ID which maps to the column COPY_REGION_ID and it contains a form DESC which maps to COPY_REGION_NAME. Configure attribute Copy_Region to display both ID and DESC forms.
 
The attribute Copy_Region results in two issues:
 

• Add Copy_Region to a report. This report returns 12 rows but only displays six of the rows:
  

• Create a prompt based on attribute Copy_Region and add it to report filter of the report created in part one. This prompt displays incorrect elements and fails to display all 12 elements. The prompt is defined as follows:
  
• Choose from an attribute element list.
• Attribute = Copy_Region.
• List all elements (with no restriction).
• A prompt answer is required.

 
CAUSE:
The preceding two issues with attribute Copy_Region occurs because its form ID and form DESC do not have a 1-1 relationship:
 

• The form ID maps to column COPY_REGION_ID.
• The form DESC maps to column COPY_REGION_NAME.
• Distinct IDs in column COPY_REGION_ID are associated with identical DESC's in column COPY_REGION_NAME; this translates to a one-to-many relationship between these two attribute forms.

Strategy requires a one-to-one relationship between an attribute's form ID and each of the other forms that this attribute may have.
 

 
ACTION:
Ensure that an attribute’s ID form has a one-to-one relationship with the other forms of this attribute.