• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Reporting environment question

 1 Replies
 0 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Author
Messages
ehazin
New Member
Posts: 0
New 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
New Poster
New Poster
Congrats on posting!
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).