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?
Time of creation of an element
-
- 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
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.ram123 wrote:Is there any way to know on which date and time an element was added to a dimension?
-
- 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
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.
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.
-
- 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
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.
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.