[INUG-Users] Any good tool instead of reporter?

[brad.bueche at wachovia.com]

You can also roll your own in PHP.   If you are going to do canned reports 
this is very easy.  Creating a front by which to query takes a little 
longer.

I have set up a front end that allows users to query any field (or set of 
fields) for any value (or set of values)  using any valid oracle operator 
(including regex, and IN, NULL, all case independent --- except regex) and 
this then generates a table in html that can be copied and pasted right 
into excel with no changes.  It also does counts (with drilldown), handles 
class conversions (for english names) , and displays and allows searching 
of the journal fields as well.  And I can put in the frigging partition 
(!) so my reports are a heck of a lot faster (I also can queue records so 
I'm not sending them to the brower 1 at a time).  Query time to the db is 
displayed. Render time is displayed. And you can hit either our production 
data or test data by choosing the target db from a drop down.  And you can 
sort your drill down top level reports by count (if you want)! (Reporter 
cant). It also has canned report options with sql that duplicates all the 
webtop entity filters.  So customer can get reports for the webtop buckets 
that they are working  (all the way back to 1/1/2007) and see who closed 
what and when, and who ack'd what and when. 

Its actually my fist web app/page/anything.   PHP and HTML have to be the 
most well documented technologies on the net. (doh!) So dont think you 
cant do it! (Admittedly, I'm currently on version 61of this app now!)

The total code was up to about 15k lines but I've cut it back to about 3k 
now as I have learned more. In the begining, I had no concept of 
generating anything dynamically.  Eventually, I'm going to have the entire 
thing generated dynamically by just pointing to a db then letting the user 
create the query interface they want.  It will however be geared toward 
netcool archives.  (And of course that means I still have to create user 
logins, work with a db for user data, start using sessions, etc 
...........as soon as I have time to learn all that stuff).

Additionally, I've already started incorporating flex so that I can do 
charting as well.  And I'll probably eventually re-do the whole front end 
in flex/flash.  Flash is soooooooooo much better than java on the client 
side.   Nice, small, very fast, and adobe provides the code to check and 
see if the user has the correct version of flash and if not downloads it 
for them.   (For those of you sick and tired of troubleshooting java 
runtime configuration issues on the client side this is a dream come 
true!).  Did I say its fast? Flash actually incorporates a little web 
engine so your server is on the client. No need for ajax. Its RIA from the 
get go. Responsive! Drag and drop, stateful, lots of security built in, 
etc.  I'm setting up the engine to read xml so that, really, it can chart 
any data that meets the format. But it will be geared toward doing event 
reporting for command centers.  Yes, xml is larger than binary but this is 
internal on 100mb connections.  I'm watching the amf3 and blazeds stuff 
though. I dont think they will be as open for input though..........vs. 
just saying make your data look like this xml and the charts will work.

$750 for Crystal reports may get you there faster though!!  ;) 

brad




"Hubbard, Greg L" <greg.hubbard at eds.com> 
Sent by: users-bounces at netcoolusers.org
01/24/2008 03:29 PM

Please respond to
users at netcoolusers.org


To
<users at netcoolusers.org>
cc

Subject
Re: [INUG-Users] Any good tool instead of reporter?






You might Google "Oracle reporting" and see what you get.

I have looked at the Oracle Business Intelligence product, which is a
reporting system from Oracle.  You also might look at Crystal Reports
from Business Objects.  There might even be a way to use Windows tools
against a remote Oracle server via ODBC driver.

I've found that Reporter stacks up fairly well against these other
products if you just look at features, and these other products are not
much different in price.

If you have some flexibility, you MIGHT consider switch Reporter from
Oracle to Microsoft SQL Server, and then you can use some of the
Microsoft reporting tools.  But the last time I tried to use the MS SQL
reporter gateway it did not work very well.

GLH 

-----Original Message-----
From: users-bounces at netcoolusers.org
[mailto:users-bounces at netcoolusers.org] On Behalf Of olga NN
Sent: Thursday, January 24, 2008 2:13 PM
To: users at netcoolusers.org
Subject: Re: [INUG-Users] Any good tool instead of reporter?

Good ideaThank you .But I am looking for GUI interface against ORACLE
-alarms are stored in ORACLE database,i need to build graphs

--- Jason Shamroski <jason.shamroski at gulfsoft.com>
wrote:

> I've used InfoVista in the past for device performance reporting. It's

> expensive - typically for larger enterprises, but it's nice. Very 
> customizable reports, provided you know what you want.
> 
> jason
> 
> 
> On 1/24/08, olga NN <al3457 at yahoo.com> wrote:
> >
> > All,
> > I am looking for a good tool to change
> Reporter,can
> > you recommend something?
> > Thank you in advance
> >
> >
> >
> >
> > 
>
________________________________________________________________________
____________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
> >
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >
> > _______________________________________________
> > Sent by the netcoolusers.org "users" mailing list
> > Post: users at netcoolusers.org
> > Unsubscribe: users-unsubscribe at netcoolusers.org
> > Search:
> http://lists.netcoolusers.org/archives/users/
> >
> 
> 
> 
> --
> Jason Shamroski
> Gulf Breeze Software
> www.gulfsoft.com
> 
> Stand by for Tivoli Conference Announcement...
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search:
> http://lists.netcoolusers.org/archives/users/
> 



 
________________________________________________________________________
____________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

ForwardSourceID:NT0004798E