I use the following technique:

1) make SQL Select string in which arguments (eg. ":rs_id", ":rdt_start_date") are
replaced with some constant value (eg. " ' ' ", "SYSDATE") which would be
successfully interpreted by the DBMS for which DW is to be created. This way
Select statement won't contain any arguments.
2) use SyntaxFromSQL to create DW syntax for this SQL Select statement
3) parse the generated syntax string and locate "table(" section in it.
4) replace "retrieve=" part of this "table(" section with the original SQL Select
statement (with the arguments).
5) add new tag "arguments=" within the "table(" section, after "retrieve=" part
with description of argument names and types. For the exact syntax you can
investigate some DWs exported to SRD-files.
6) pass the modified syntax string (with replaced SQL Select and added arguments
definitions) to the final Create statement.

Of course these steps require some programming and experiments, but it works in
our commercial products! So programmers, you have a serious material for the long
nights :-)

There are additional issues regarding object naming in dynamically generated
DWs - sometimes header text objects' names don't match the corresponding
column names below them (plus suffix "_t"). This happens with some (not all)
SQL Select statements containing selection of equally named columns more
than 1 times. So additional modification of the names in the syntax string can be
performed in order to clean this mess.

I hope that this gives some light on the topic.

Wish you good luck!

Ivaylo Ivanov
Senior Software Developer
BULGARIA