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
|
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? |
|
|
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. |
Forums » Topic Forums » Technology Forum » Reporting outside of WFC application
