Strategy fetches the list of values to be displayed in an Attribute Element Prompt by executing two passes of SQL as seen below:
Pass 0
select distinct a11. AS CUSTOMER_ID, from a11
Pass 1
select distinct a11. AS CUSTOMER_ID,
a11. AS CUST_LAST_NAME,
a11. AS CUST_FIRST_NAME,
a11. AS ADDRESS
from a11
where a11. in (1, 4459, 4593, 1210, 1866, 3888, 1167, 6078)
Pass 0: Counts the distinct elements (i.e. all unique elements of an attribute.) This is to support incremental fetch in the prompt and/or Data Explorer Display. This pass also ensures that enough memory is allotted to store the results.
Pass 1: This pass selects the attributes ID's and DESC's that will be displayed in the prompt.
Essentially, pass 1 checks how much memory is needed to support all the elements in the chosen hierarchy/attribute. The second pass selects their ID and DESC to be displayed in the prompt selection window.
