Event listener or tracking changes within cells

[nxw]

Hi All,

Just wondering, are there any event listeners or anything available in the form of when changes are made to cells, I can track these and quantify these?

I'm monitoring changes in a cube where there are writable cells which the data capture team populate but I just need to ensure any changes are always recorded.


Thanks.

Admin Note: Moved to the correct forum. This does not belong in General.

[Alan Kirk]

Just wondering, are there any event listeners or anything available in the form of when changes are made to cells, I can track these and quantify these?

I'm monitoring changes in a cube where there are writable cells which the data capture team populate but I just need to ensure any changes are always recorded.

That's what your transaction log file is for.

If you mean something like a trigger in a relational database that can alert you in real time when a specific change is made, then no, that doesn't exist. But the transaction log still allows you to check and quantify the changes, and track who made them. I find the GUI method of querying the logs to be slow and tedious (and allows queries to be filtered only one value at a time) so I usually load mine up into a SQL Server database for querying and analysis.

[nxw]

Thank you Alan for your input.

I was wondering if there is any way to perhaps also qualify these changes eg.

xx changed Brand name from xx to xxx?
and all the other attributes against the leaf element being (product barcode)?

[Alan Kirk]

Thank you Alan for your input.

I was wondering if there is any way to perhaps also qualify these changes eg.

xx changed Brand name from xx to xxx?
and all the other attributes against the leaf element being (product barcode)?

Metadata changes are also in the transaction log, as long as you have logging on for the attributes cube (which it should be).

[nxw]

Thnx - where can i find this transaction log?

[Alan Kirk]

Thnx - where can i find this transaction log?

Exactly how much of the manuals have you read?

[nxw]

I think i found it?

[nxw]

What about if someone has gone and cleared the data from some cells?

[Alan Kirk]

I think i found it?

That's viewing it through the GUI. You're limited in how well you can query that as already mentioned above.

If you aren't familiar with concepts like your database directory and logging directory (and indeed most of the settings that are in the config file that I pointed you to in the previous post) then you really can't administer a TM1 system effectively. You really should be investing in a proper training course. (Probably one from a consulting firm rather than IBM; you don't need to learn "Just leave everything to Performance Muddler".)

You should have at the very least read the Installation and Configuration Guide cover to cover, with special emphasis on the TM1 Architecture section.

What about if someone has gone and cleared the data from some cells?

That is still a transaction and will therefore be logged, will it not?

[nxw]

Thanks, I'll give that a go.

I've been assigned the role of administrating the systems, ironically I am new to them. Planning ..well "hopefully" I get approved for some training for TM1 with these guys who we sometimes use for consulting work:

http://cubewise.com/

[Alan Kirk]

Thanks, I'll give that a go.

I've been assigned the role of administrating the systems, ironically I am new to them. Planning ..well "hopefully" I get approved for some training for TM1 with these guys who we sometimes use for consulting work:

http://cubewise.com/

I've worked with them from time to time. I have no first hand experience of their training nor do I know anyone who has (well, I may do but not be aware of it), so I can't comment on that. But based on some of their talent that I've worked with I suspect that you could do far worse. It would be a worthwhile investment if your bosses want a system that runs well. You can't do it with one hand tied behind you.