I looked thru the manual for this, but couldn't find it
User prompts. The tool we're coming from allows $var in the query and prompts the user for runtime value substituting that value for the variable in the query string. Would provide a lot of value.
I've tried the macro's with $SELECTION$ and find that feature very useful.
Doug Little
Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741