TM1 Drill to SQL - Can you add extra data to the result set?

[stex2727]

I have a great drill through process working and fetching my transactional detail. On my result set there is a field saying which module the transaction comes from (10,11,15 etc). Rather than ferret around someone elses database I'd like to convert this result set into something more friendly using an attribute or lookup cube to convert the codes into text. The result set to look something like

Trans # Source Value
1001 HR (10 in database) 1000
1002 GL (12 in database) 1242
1003 GL (12 in database) 1300

Is this possible within the drill process?

Steve

[rkaif]

In your source database do you have this description somewhere? If yes, then the easiest way will be using that Description Table in the Drill SQL.

OR

I am not sure how many Modules you have got but if they are just a few of them then you can use DECODE (Oracle) or CASE (SQL server) function in the SQL to translate the codes with the description.

OR

I have not tested this but I think you can create a Dimension for the Modules and add Descriptions as Attributes. Then in the Drill TI Process you can use the ATTRS() to get the Descriptions of the elements and then in the Drill SQL you can use '?parameter?' variables.