SYMPTOM:
When a report containing only one attribute is executed, the full list of elements is successfully displayed as shown in the screenshot below.
When the attribute is included in an element list prompt, the list of elements appears to be incomplete with some elements repeated as shown in the screenshot below.
If the missing elements are searched, they can be found and added to the element selection
Browsing trough the element list directly from desktop shows the same behaivor as the prompt.
CAUSE:
Rows with the same ID have inconsistent description forms in the table used as the look up table for the attribute. This is a possible situation if the attribute ID and Description forms are mapped to a fact table as their primary look up table.
When populating a list of elements Strategy first executes a distinct count on the ID keys of the attribute. This returns the amount of elements available for selection. The ID is expected to be unique, by executing a distinct count the number of available elements will be retrieved.
In the example shown above the element list is populated in the background by the following SQL statements:
create table ZZTTP001LNXOT000 (WJXBFS1 LONG) insert into ZZTTP001LNXOT000 select distinct a21. AS WJXBFS1 from a21 select count(*) AS WJXBFS1 from pa21 select a11. AS XXX, a11. AS YYY from a11 order by 1 asc
ACTION:
A description form cannot be different across rows with the same ID. The table must be changed in such a way that the description is always the same for all the rows with the same ID. Strategy does not recommend using a fact table as the look up table of an attribute.
20203
