[aztechlist] Looking for report generator generator
Tom Vincent
plug-discuss@lists.PLUG.phoenix.az.us
Fri, 24 Aug 2001 18:59:42 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0033_01C12CCE.EEBAF700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Your best choice would be Brio. Beyond that, BusinessObjects.
Tom Vincent
(experienced with both)
----- Original Message -----=20
From: Trent Shipley=20
To: PLUG ; AZTechList=20
Sent: Friday, August 24, 2001 2:40 PM
Subject: [aztechlist] Looking for report generator generator
<PHM Reports>
Then there is the problem of a report generator. This exists and is =
called
Microsoft Access. Microsoft access is too hard to use however. The =
desired
magic tool:
1) Connects to any database and runs on MS.NET / Windows
2) Allows building queries (Access-like graphical query language)
3) Forms
3.1) Must allow any pointy-haired manager (PHM) to parameterize query
3.2) Any parameterized query can be put into pretty GUI form by PHM.
3.3) PHM can combine form with GWC
4) Reports
4.1) PHM can do roll-ups / grouping _post facto_ or interactively
4.2) PHM can use Excel-Like tool to interactively roll-up, pivot, or =
cube
results
4.3) PHM can design report layout suitable for distribution or =
presentation
SHE (silver-haired executives)
5) C-geek friendly (C-geeks program in C, disdain databases as mere =
CIS
scutt work.)
5.1) C-geek can use PHMR to abstract subset of functionality to =
provide
application specific simplified reporting tool.
5.2) C-geek need not work with OS or RDB user, user-group, or roles to
restrict (can) applications developed using PHMR as meta-tool.
5.3) Like PHM, but much less so, C-geek can avoid playing DB developer =
or
DBA.
5.4) C-geek can control snapshotting, commit sizes, etc. to tune the
performance -vs- consistency of any derived reporting tool.
6) Child-proofing.
6.1) Restrictions on DB access can be set in derived applications (per =
5.2)
6.2) PHMR talks to RDBMS to get query plan. PHMR derived applications =
warn
of potentially lethal queries per C-geek specifications. =
Specifications can
be made accessible to administrators of the derived app.
6.3) PHMR derived applications can monitor all queries it dispatches =
and
kill them if they use excessive resources as defined by DBA or C-geek. =
Kill
parameters can be exposed for tuning by derived application =
administrator at
C-geek option.
6.4) PHMR keeps access plans for all killed queries for length of time =
set
by C-geek (or app admin) and denies queries with identical or =
super-set
access plans.
<How would I search for this sort of tool?>
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
Trent Shipley
Work:
(602) 522-7502
mailto:tshipley@symbio-tech.com
http://www.symbio-tech.com
Yahoo! Groups Sponsor=20
ADVERTISEMENT
=20
=20
=20
=
=3D=3DAzTechList=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Unless otherwise noted, list emails are NOT invitations for sales =
calls!
Report list related problems/concerns: =
mailto:listcomment@aztechlist.org
AzTechList
Subscribe: mailto:aztechlist-subscribe@yahoogroups.com
Unsubscribe: mailto:aztechlist-unsubscribe@yahoogroups.com
Put email delivery on hold: mailto:aztechlist-nomail@yahoogroups.com
Change to daily digest mode: =
mailto:aztechlist-digest@yahoogroups.com
Change to individual emails: =
mailto:aztechlist-normal@yahoogroups.com
Searchable archives: =
http://groups.yahoo.com/group/aztechlist/messages
Internet related? Please post it to the AZIPA Discussion List instead.
Neither technology or Internet related? Post it to the Off-Topic list.
Please see http://www.aztechlist.org for full List Info and =
Guidelines.
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DAzTechList=3D=3D=20
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.=20
------=_NextPart_000_0033_01C12CCE.EEBAF700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Your best choice would be Brio. =
Beyond that,=20
BusinessObjects.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tom Vincent</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>(experienced with =
both)</FONT></DIV></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dtshipley@symbio-tech.com =
href=3D"mailto:tshipley@symbio-tech.com">Trent=20
Shipley</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20
title=3Dplug-discuss@lists.PLUG.phoenix.az.us=20
href=3D"mailto:plug-discuss@lists.PLUG.phoenix.az.us">PLUG</A> ; <A=20
title=3Daztechlist@yahoogroups.com=20
href=3D"mailto:aztechlist@yahoogroups.com">AZTechList</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, August 24, 2001 =
2:40=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> [aztechlist] Looking =
for report=20
generator generator</DIV>
<DIV><BR></DIV><TT><PHM Reports><BR><BR>Then there is the =
problem of a=20
report generator. This exists and is called<BR>Microsoft =
Access. =20
Microsoft access is too hard to use however. The =
desired<BR>magic=20
tool:<BR><BR>1) Connects to any database and runs on MS.NET / =
Windows<BR>2)=20
Allows building queries (Access-like graphical query language)<BR>3)=20
Forms<BR>3.1) Must allow any pointy-haired manager (PHM) to =
parameterize=20
query<BR>3.2) Any parameterized query can be put into pretty GUI form =
by=20
PHM.<BR>3.3) PHM can combine form with GWC<BR>4) Reports<BR>4.1) PHM =
can do=20
roll-ups / grouping _post facto_ or interactively<BR>4.2) PHM can use=20
Excel-Like tool to interactively roll-up, pivot, or =
cube<BR>results<BR>4.3)=20
PHM can design report layout suitable for distribution or =
presentation<BR>SHE=20
(silver-haired executives)<BR><BR>5) C-geek friendly (C-geeks program =
in C,=20
disdain databases as mere CIS<BR>scutt work.)<BR>5.1) C-geek can use =
PHMR to=20
abstract subset of functionality to provide<BR>application specific =
simplified=20
reporting tool.<BR>5.2) C-geek need not work with OS or RDB user, =
user-group,=20
or roles to<BR>restrict (can) applications developed using PHMR as=20
meta-tool.<BR>5.3) Like PHM, but much less so, C-geek can avoid =
playing DB=20
developer or<BR>DBA.<BR>5.4) C-geek can control snapshotting, commit =
sizes,=20
etc. to tune the<BR>performance -vs- consistency of any derived =
reporting=20
tool.<BR><BR>6) Child-proofing.<BR>6.1) Restrictions on DB access can =
be set=20
in derived applications (per 5.2)<BR>6.2) PHMR talks to RDBMS to get =
query=20
plan. PHMR derived applications warn<BR>of potentially lethal =
queries=20
per C-geek specifications. Specifications can<BR>be made =
accessible to=20
administrators of the derived app.<BR>6.3) PHMR derived applications =
can=20
monitor all queries it dispatches and<BR>kill them if they use =
excessive=20
resources as defined by DBA or C-geek. Kill<BR>parameters can be =
exposed=20
for tuning by derived application administrator at<BR>C-geek =
option.<BR>6.4)=20
PHMR keeps access plans for all killed queries for length of time =
set<BR>by=20
C-geek (or app admin) and denies queries with identical or =
super-set<BR>access=20
plans.<BR><BR><How would I search for this sort of=20
=
tool?><BR><BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR><BR>Trent=20
Shipley<BR><BR>Work:<BR>(602)=20
522-7502<BR>mailto:tshipley@symbio-tech.com<BR><A=20
=
href=3D"http://www.symbio-tech.com">http://www.symbio-tech.com</A><BR><BR=
></TT><BR><!-- |**|begin egp html banner|**| -->
<TABLE cellSpacing=3D0 cellPadding=3D2 border=3D0>
<TBODY>
<TR bgColor=3D#ffffcc>
<TD align=3Dmiddle><FONT color=3D#003399 size=3D-1><B>Yahoo! =
Groups=20
Sponsor</B></FONT></TD></TR>
<TR bgColor=3D#ffffff>
<TD align=3Dmiddle width=3D470>
<TABLE cellPadding=3D0 border=3D0 cellspacaaing=3D"0">
<TBODY>
<TR>
<TD align=3Dmiddle><FONT face=3Darial=20
size=3D-2>ADVERTISEMENT</FONT><BR><A=20
=
href=3D"http://rd.yahoo.com/M=3D178320.1566800.3122525.1261774/D=3Degroup=
web/S=3D1705043967:HM/A=3D766844/R=3D0/*http://www.fastweb.com/ib/yahoo-5=
7f"><IMG=20
height=3D250 alt=3D""=20
=
src=3D"http://us.a1.yimg.com/us.yimg.com/a/fa/fastweb/300x250.gif"=20
width=3D300 =
border=3D0></A></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD><IMG height=3D1 alt=3D""=20
=
src=3D"http://us.adserver.yahoo.com/l?M=3D178320.1566800.3122525.1261774/=
D=3Degroupmail/S=3D1705043967:HM/A=3D766844/rand=3D147610619"=20
width=3D1></TD></TR></TBODY></TABLE><!-- |**|end egp html =
banner|**| =
--><BR><TT>=3D=3DAzTechList=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>Unless=20
otherwise noted, list emails are NOT invitations for sales =
calls!<BR>Report=20
list related problems/concerns:=20
mailto:listcomment@aztechlist.org<BR>AzTechList<BR> Subscribe:=20
mailto:aztechlist-subscribe@yahoogroups.com<BR> Unsubscribe:=20
mailto:aztechlist-unsubscribe@yahoogroups.com<BR> Put email =
delivery on=20
hold: mailto:aztechlist-nomail@yahoogroups.com<BR> Change to =
daily=20
digest mode: mailto:aztechlist-digest@yahoogroups.com<BR> Change =
to=20
individual emails: mailto:aztechlist-normal@yahoogroups.com<BR> =20
Searchable archives: <A=20
=
href=3D"http://groups.yahoo.com/group/aztechlist/messages">http://groups.=
yahoo.com/group/aztechlist/messages</A><BR>Internet=20
related? Please post it to the AZIPA Discussion List =
instead.<BR>Neither=20
technology or Internet related? Post it to the Off-Topic =
list.<BR>Please see=20
<A href=3D"http://www.aztechlist.org">http://www.aztechlist.org</A> =
for full=20
List Info and=20
=
Guidelines.<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3DAzTechList=3D=3D=20
</TT><BR><BR><TT>Your use of Yahoo! Groups is subject to the <A=20
href=3D"http://docs.yahoo.com/info/terms/">Yahoo! Terms of =
Service</A>.</TT>=20
<BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0033_01C12CCE.EEBAF700--