PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/13/2014 11:31 PM by  Sameera
Reporting Options
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Sameera
Consultant
Next
Advanced Member
(70 points)
Advanced Member
Posts:30


Send Message:

--
12/24/2013 5:16 AM
    What are the reporting options available with LTM, Is it possible to attach crystal reports to application.

    Thanks
    Sameera
    Terry Wier
    Private
    Private
    Basic Member
    (39 points)
    Basic Member
    Posts:13


    Send Message:

    --
    12/26/2013 9:41 AM
    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
    Woozy
    Private
    Private
    Veteran Member
    (3490 points)
    Veteran Member
    Posts:708


    Send Message:

    --
    12/26/2013 10:13 AM
    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
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Sameera
    Consultant
    Next
    Advanced Member
    (70 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    12/29/2013 10:49 PM
    Hi Terry

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

    Best Regards
    Sameera
    Sameera
    Consultant
    Next
    Advanced Member
    (70 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    12/30/2013 1:34 AM
    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

    Terry Wier
    Private
    Private
    Basic Member
    (39 points)
    Basic Member
    Posts:13


    Send Message:

    --
    12/30/2013 8:53 AM

    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

     

    Woozy
    Private
    Private
    Veteran Member
    (3490 points)
    Veteran Member
    Posts:708


    Send Message:

    --
    12/30/2013 10:09 AM
    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.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Sameera
    Consultant
    Next
    Advanced Member
    (70 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    01/13/2014 12:20 AM
    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
    Woozy
    Private
    Private
    Veteran Member
    (3490 points)
    Veteran Member
    Posts:708


    Send Message:

    --
    01/13/2014 9:16 AM

    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
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Attachments
    Woozy
    Private
    Private
    Veteran Member
    (3490 points)
    Veteran Member
    Posts:708


    Send Message:

    --
    01/13/2014 9:23 AM
    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.
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Sameera
    Consultant
    Next
    Advanced Member
    (70 points)
    Advanced Member
    Posts:30


    Send Message:

    --
    01/13/2014 11:31 PM
    Thanks Kelly, It was really helpful.

    Thanks
    Sameera
    You are not authorized to post a reply.