Reporting Options

Hello, this is Terry Wier from Dashboard Gear.

Dashboard Gear has incorporated all LTM data into our off-the-shelf Lawson HCM reporting data mart. We initially did this for the one of the larger states using Lawson HCM. If you are curious how easy reporting on historical information can be to include LTM data please click on the link below.

HR Recorded Demo

http://www.screencast.com/t/8sV96iXUVUPa

Terry Wier
Dashboard Gear
763-208-9937

Hi Sameera,

You may use Crystal to report current TM data via SQL, but it will require a pretty good understanding of the tables and relationships.  All the relationships are defined in the application rather than the database.  LTM uses derived fields extensively, so understanding the relationships is critical.  One thing you can't report against using SQL is any audit log data (i.e. history).  This is the biggest glaring hole in TM.  The turnover tables are ok for some data, but true full point-in-time employee data is not accessible via SQL, as far as I've been able to determine.

The only other reporting options are Spreadsheet Designer (Excel Add-In) and Infor Process Automation (IPA).  The former is OK for one-off reporting, but is quite slow and isn't reasonable for scheduled reporting.  IPA is also slow, and really doesn't handle batch processing very efficiently, though it can do it.  Both of these options provide much easier access to the derived fields.

I hope this helps.

Kelly

Hi Terry

Thanks for the reply. Can't open the video, can you share some screenshots ?

Best Regards
Sameera

Hi Kelly

Thanks for the detail reply. Appreciate if you can explain how to do reporting through IPA, is it via 'Email' node ?

Best Regards
Sameera

Sameera,

 

Here is a screen shot but it does not give you much appreciation for the solution. Make sure you have Flash on your PC or try the demo on another PC..

 

Terry

 

Hi Sameera,

Using IPA you can query the data using a Landmark node and then write the data to a flat file, email, or whatever.  There really isn't a way to do pull reporting using IPA.  It really isn't a good reporting solution, but it is an option in some cases.

One possibility is to have and IPA flow that runs on a regular schedule that builds a flat-file on  that is written to a specific location.  Then have Crystal (or whatever) use the flat file as the source for reporting purposes.  This would be a bit kludge, but it may be an option in some situations. 

SQL is much better for this type of thing, if you can figure out the correct logic.

Hi Kelly

Thanks for the reply. Is it possible to design an email notification to send data in table format using IPD.

Eg : Employee Master Data

Emp Name    |    Emp No  |  Date of Join | Birthday

001
002
003

Thanks
Sameera

Yes. The best way to do this is by creating an html email and using a messagebuilder to create the table details.

Here an example:









I've also attached a PDF, in case the screenshots above are hard to read.


I hope this is helpful.

Kelly

I should also note that I almost always use html styles to get the emails to look the way I want them to. I just include the stylesheet in the email node as well.

Thanks Kelly, It was really helpful.

Thanks
Sameera