Time of creation of an element

Post Reply
ram123
Posts: 38
Joined: Sun May 19, 2013 10:06 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Time of creation of an element

Post by ram123 »

Is there any way to know on which date and time an element was added to a dimension?
I am assuming we can get to know using Transaction log.. but is there any way to filter out a particular dimension? I can approximately set the range of date to a week or 10 days as thats what I'm assuming..
Any other suggestions?
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Time of creation of an element

Post by tomok »

ram123 wrote:Is there any way to know on which date and time an element was added to a dimension?
This is not going to be logged. There should be a log entry telling you the dimension was updated but you can't tie it to a specific element. The only way I know of to track this would be is to add an attribute to the dimension and update it yourself with a timestamp value immediately after the element is added. Of course, this will only really work if you are adding the element via a TI. If you are doing it with an XDI sheet, or the Dimension Editor, you'll have to rely on the user to manually update the timestamp attribute.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Time of creation of an element

Post by BrianL »

The transaction log is only tracking data changes.

For anything else, you're pretty much limited to whatever TM1 will spit out into the audit logs. I don't recall off the top of my head if specific element edits are captured.
lotsaram
MVP
Posts: 3701
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Time of creation of an element

Post by lotsaram »

The audit logs for TM1 will tell you that a dimension was updated, by whom and with a timestamp but element insertions and deletions aren't identified.

If you want to identify element creation & deletion, hierarchy moves, etc for manually maintained dimensions this is available in Pulse provided that the full source control monitoring option is selected for the dimension.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply