Check out this new Flipboard article on rules for coding dynamic query looksups for the Data Warehouse: Rules for Including Dynamic Query Lookup Attributes in the Data Warehouse | CA PPM Cookbook
The article is based on a tech tip that was posted here on the community by Kathryn Ellis:
https://communities.ca.com/message/241830996