Re: OT: Validation of end-user reports

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 19 Feb 2014 11:31:34 -0500
Message-Id: <530496160200000B0051B2C4_at_groupwise.gcrta.org>

I am referring to the validity of the data being reported. In a report developed by IT, results are checked for accuracy. For an end-user developed report, what are some ways to force the user to verify the information they are getting is accurate. We do not want decisions being made from bad reporting.

>>> Maris Elsins <elmaris_at_gmail.com> 2/19/14 10:41 AM >>>
Hi Jeffrey,

What do you mean with "the integrity of the user's reports"? If you're referencing to performance impact (to make sure users don't kill the system by running huge reports that never complete) We have partially addressed this by implementing the resource manager plan to limit the number of total active sessions for users connection, the degree of parallelism and max amount of CPU % they can utilize. And I say "partially" because we're not able to control how much IO they cause. no Exadata here ;(

---
Maris Elsins
_at_MarisElsins
( https://twitter.com/MarisElsins) 
www.facebook.com/maris.elsins
( https://www.facebook.com/maris.elsins) 




On Wed, Feb 19, 2014 at 3:54 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:


For those of you that allow your users to create their own reports, what procedure is followed to validate the integrity of the user's reports? 


Jeffrey Beckstrom
Database Administrator
Information Systems
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
.




.



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 19 2014 - 17:31:34 CET