Topic
2 replies Latest Post - ‏2013-05-03T17:51:29Z by Rizwan.Kaif
MarcelloV
MarcelloV
1 Post
ACCEPTED ANSWER

Pinned topic Can "cube cell update" trigger a TI process?

‏2013-05-02T08:55:33Z |

Hello,

I would like to trace when a specific user updates a specific cell in a cube, and in that case I would like to run a TI process.

In other words I am wondering if is it possible to trigger a TI process based on cell update.

 

Thanks in advance,

Marcello

  • smcdowell
    smcdowell
    6 Posts
    ACCEPTED ANSWER

    Re: Can "cube cell update" trigger a TI process?

    ‏2013-05-02T15:15:44Z  in response to MarcelloV

    The only way I can think of is to use a chore to run a TI to periodically check the value of that cell to see if it has been updated.

    That will not give you the user name of whoever changed it though.

    That information is stored in the transaction log (tm1s.log) but it is locked by TM1 Server so you can't read it.

  • Rizwan.Kaif
    Rizwan.Kaif
    197 Posts
    ACCEPTED ANSWER

    Re: Can "cube cell update" trigger a TI process?

    ‏2013-05-03T17:51:29Z  in response to MarcelloV

    Other way of doing it is to give a TM1 spredsheet or a websheet to end user in which the do their Data entry (The spreadsheet will have DBRW formulas) and then you can provide an Action Button, clicking on which will run the TI process.