Hi -
We are getting close to our go-live in GHR and are starting to discuss reporting...and we're learning that the world of history isn't as straight-forward in GHR as it is in S3. Has anyone that has gone live on GHR figured out a way (easy or not) to do history reporting off the audit tables?
Thanks.
Ruth Bellinger Holladay
[NOTE: The below is a direct copy of my response to Ruth's question in Infor Customer Communities at http://www.inforcommuniti...sted=1#p26960. I'm cross-posting the answer because I'm figuring people may want to view the responses in both places).
Hi Ruth,
Reporting history out of Landmark is...challenging..., as I'm sure you've learned.
We do almost all of our reporting using either direct DB-SQL, or from our MS-SQL DataMart. When we were new with Landmark, we went down the path of trying to parse the audit log XML and dump the data into a datamart for reporting. This is very painful.
You basically have two options - you can either pull the audit log xml out of the S$ tables (if you did the split LOB process) or the AuditLog field in the table (if you didn't), or pull the history-by-date data from the S_ tables. I strongly suggest the latter, because trying to deal with the xml (which can change during updates) pretty much sucks.
By "S$" and "S_" tables, I mean the tables that prepend those values to the table prefix.
EMPLOYEE = EMPL S$_EMPL = LOB table - hold the LOB (Large Object) fields from that business class. S_EMPL = History by Date table - all fields, and their values based on BEGIN/END dates.
You will have to join either of these S tables back to the main table based on their indexes - usually by UniqueID, but sometimes by symbolic keys.
I hope this points you in the right direction!