Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Reporting environment question

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
ehazin
Basic Member
Posts: 7
Basic Member
6/30/2006 3:27 PM
    Im am using a host of tools (Report Writer, Crystal, Access) to report data against Lawson HR and Financials. However, as I get more and more complex requests, I find myself massaging the data alot in the MS Access enviroment to meet some of my reporting requirements.

    Id like to understand how other practitioners have their reporting environments setup. Do you use Lawson's data mart solutions? Or have you built a custom DW? What are the challenges you still face with your solution?

    Thanks!
    Chris Martin
    Veteran Member
    Posts: 277
    Veteran Member
    7/8/2006 8:53 PM
      One of the things I've done that's specific to HR personnel action/history changes, is create a datamart to simplify reporting history/change reporting (ie job changes, supervisor changes, dept changes, etc). Essentially, this was an overnight ETL process using pl/sql. The fact that the data was not "real-time" never proved to be an issue due to the nature of HR (as opposed to, say, Supply Chain).