Will Apptio ever have column names of transforms noted in audit logs or does that make the calculations too crazy?  Made several changes and unable to pinpoint which change to undo, so going back into the transform to undo there.  

Jenny,

Right now I haven't seen a plan that will include the column names for the audit log, but I know in the v12 they introduce a new process when doing work in Apptio with a (Check In \ Check Out) process.  With this when checking a document (i.e. Table, Report, Model Object, etc.) we can document all the changes that we're made so when looking at all the checked in stuff we will be able to tell more of what happened vs. just seeing a table transform \ report was saved.  

But as of right now there isn't a way to undo a check-in, but it's on the roadmap for v12 to allow that to happen.  

-Ryan

Copy that - and thank you!

Here's a workaround option to consider.

V11

(top left) Studio > Audit

Filter Description = SaveTableTransform

Locate audit log entries for the edited transform table of interest.

Right-click each entry > View contents

Copy and paste full contents to any text editor (e.g. Notepad++), one file per audit log entry.

V12

(top left) Project > Check in history

Expand Date entries (triangle icon) to view details of a particular check in.

Locate audit log entries for the edited transform table of interest.

Right-click each entry > View contents

Copy and paste full contents to any text editor (e.g. Notepad++), one file per audit log entry.

A text comparison tool (e.g. WinMerge for Windows, XCode/Filemerge for Mac) shows side-by-side versions with differences highlighted.

(Click to enlarge screenshot)

The example above shows two modifications to the table:

1. Data filter added: Fixed Asset Ledger ID Not Equals FA0013

2. IT Resource Sub Tower column formula modified from

="ITRST" && TRIM(Split(IT Resource ID,2))

to

=TRIM(Split(IT Resource ID,2))

Caveat to this approach: the default ("out of the box") version of a transform table has no audit log entry.

So if you're trying to analyze the first modification to the table, you'll have nothing to compare it to (i.e., you'll only have one audit log entry, not two).

I'm pretty sure only Apptio Admin users have the "View Contents" option in v11.

Ah man, Tony's right - I have admin access and can't see it - you have to have special Apptian powers... Boo... Hiss... ;-(

VERY nice - thanks, Chris!

Ah - that makes my workaround much less helpful.

Ah, not all is lost Chris, still a good internal way of troubleshooting that can be shared with everyone  in case someone runs into that situation

Can we add that as an enhancement for a future release so us non-Apptians can have it, too?

Never hurts to ask

Trust me...being an ex-Apptian Jenny, i miss a bunch of my extra buttons. 

I know right - Apptians get all the cool gadgets and toys - no fair