Re: OT: Validation of end-user reports
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "Maris Elsins" <elmaris@xxxxxxxxx>
- Date: Wed, 19 Feb 2014 11:31:34 -0500
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@xxxxxxxxx> 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
@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@xxxxxxxxx> 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
.
.
Other related posts:
