Dynamic Table Names in DataMart Report 1

[mrdalton]

Is it possible to prompt a user for the name of the table to be created in the context of a DataMart report? Our company has a need to dump the results of reports into our relational database, but having some kind of control over the names of the tables would be very helpful. I assume one would be able to do this via the API, but if it can be done within the report, event better.

Thanks in advance!

Mark

 

[nlim]

you can't prompt the user but there are placeholders in the table name for username, date and report name. They are

!U
!D
!O

respectively...

 

[sgoodman7]

If you use one of the dynamic placeholders, such as U!, do you need to define a table in the warehouse catalog for each user? If this is the case, would you need to define the attributes separately for each of these tables?

Thanks,

 

[nlim]

no these are taken from runtime parameters. !u just uses the userid.