Loading Secure Filter Options On The Fly
Another rather obvious tip but certainly useful.
If you want to load the selections for a secure filter/prompt in a xaction dynamically, then in the editor select a Get Data -> relational
Input the query to retrieve the relevant information and then setup the result-set at the bottom of the page and assign the columns.
The in the Secure Filter/Prompt do the usual just selecting the dynamic result-set. As long as the details are correct you will see the query results next time you run the xaction.