Forums

Reporting outside of WFC application
Technology Forum
Reporting outside of WFC application
Discuss how to choose system that will yield the best results, as well as how to maintain it, and how to calculate its return on investment.
We are currently implementing a new data mart to store "copies" of several different application databases, one being our Kronos dB. Being a county govt office we have a high demand for cross reportin
0
Cat:Topic ForumsForum:ForumId57
Cat:Topic ForumsForum:ForumId57Discussion:DiscussionId33174

Forums » Topic Forums » Technology Forum » Reporting outside of WFC application

You must be logged in to contribute. Log in | Register
 
Forums  »  Topic Forums  »  Technology Forum  »  Reporting outside of WFC application

Reporting outside of WFC application

posted at 4/19/2007 11:04 AM EDT
Posts: 1
First: 4/19/2007
Last: 4/19/2007
We are currently implementing a new data mart to store "copies" of several different application databases, one being our Kronos dB. Being a county govt office we have a high demand for cross reporting on these databases. Therefore we are developing a reporting portal, which will access the new data mart, instead of the various production databases, to handle all reporting. Basically pulling reporting out of each application directly, to create one universe odbc compliant data source, utilzing one single source/version of reporting technology.

The issue I am having with Kronos is being able to re-create the "metadata" layer to handle the hyperfinds in reporting (i.e. ?Query Name) which uses Kronos user set up security/roles to determine the row level of data allowed to be returned to that user. I have found the access profile table and can see how they are being used in views but I can't seem to figure out how they are linked to the personid = -411 portion of hyperfinds. I know there must be a middle peice that the application sends that info to the report when it's generated out of the WFC directly. I just need to figure out how to re-create that same level of security.

Has anyone experianced reporting off of the WFC database from another method other than directly from the application itself and been able to re-produce the same hyperfinds/security?
New post Reply to this post

Reporting outside of WFC application

posted at 4/23/2007 6:47 AM EDT
Posts: 3
First: 4/23/2007
Last: 7/2/2007
The middle part you are looking for is in the program it's self. I have worked with Kronos for 8 years. We are on 4.3 curently. I don't want to speak for the fourm admins, but a Kronos question to the level of detail is not what this forum covers. The Kronos website does have a users forum which will get your question into a group with more expertise.
New post Reply to this post

Forums » Topic Forums » Technology Forum » Reporting outside of WFC application

Daily Q&A

How to Address Flagging Motivation?

How do I increase motivation levels in the department? How do I brand my business unit as an attractive place to work? I have top-notch IT professionals in my business unit who feel they are "children of a lesser God" because they are non-billable resources and do not get plum postings abroad, nor the glamour that goes with them. As a result, their motivation suffers.

—-- Feeling Their Pain, human resources generalist, software/services, Mumbai, India

Read Answer

Stay Connected

Join our community for unlimited access to the latest tips, news and information in the HR world.

  • Workforce Technology (Bi-weekly)

    Covering the latest technology trends, tools and applications that are shaping the workforce in the 21st century. Delivered the 2nd & 4th Thursday of each month.

  • Dear Workforce (Bi-weekly)

    See what HR professionals are asking, and what Workforce Management experts are saying. Delivered the 1st and 3rd Thursday of each month.

  • Workforce Benefits (Weekly)

    Stay current on all aspects of employee benefits, from health care to retirement issues. Delivered on Wednesdays.

  • Workforce Week (Weekly)

    Free weekly update on the trends in HR and new tools added to Workforce.com. Delivered each Tuesday.

  • Workforce Talent (Monthly)

    See the recruiting, talent development and retention strategies of top companies and get the resources for effective talent management. Delivered the 2nd Monday of each month.

  • Workforce Training (Monthly)

    Stay current on the latest strategies and resources for training and developing your workforce talent. Delivered the 3rd Monday of each month.

HR Jobs

View All Job Listings

Search