Passing MUN from TM1 to DB table

[Imagine_a_Circle]

Hi, thanks for any help!

I am trying to set up Event Studio to run a report with parameters passed from TM1.  I have added a button in TM1 that writes a record to a table with the options users select.  I want to pass the MUN and not the name into the table and then use it to populate the params in my Report Studio report.  I can see in my package that I have the MUN added when I look in RS so it is there somewhere, just how do I pass it from TM1 to the DB table?

Thanks

[MFGF]

Hi, thanks for any help!

I am trying to set up Event Studio to run a report with parameters passed from TM1.  I have added a button in TM1 that writes a record to a table with the options users select.  I want to pass the MUN and not the name into the table and then use it to populate the params in my Report Studio report.  I can see in my package that I have the MUN added when I look in RS so it is there somewhere, just how do I pass it from TM1 to the DB table?

Thanks

Hi,

Firstly, I LOVE your forum name! A blast from the past. :)

As you know, my old friend, I'm not an expert in the dark arts of TM1, but I know a Kipper who is - might be worth reaching out to him directly?

Hope you're keeping well and enjoying all the globe-trotting!

Cheers!

MF.

[Imagine_a_Circle]

Thank you, hope you're keeping busy  :)

[AJAYC]

Hi

What you need to do is pseudo construct the MUN before you pass it to your DB table.

You can do this by identifying the parents of the TM1 element within a particular hierarchy by combining the use of the ELISANC and ELPAR functions. You simply construct the square brackets as string connectors.

HTH
Ajay