Oracle 10g Graphics question

#1

Hi

I hope I am not sending this to the wrong group, but I need some help
solving a problem.

I'm supposed to create a graph which combines two sets of data, and I
can't figure out how to do it, or if it's at all possible.

The graph has to show actual time intervals for specific transaccions,
as bars (different series possible for every transaccion), as well as
overlap those bars with a line indicating the desired time intervall
for the respective transaccion.

A simple bar/line combination graph is eassy to make, but in this case
there's under-elements in the real time-intervals, and no such for the
desired time-intervalls, and whatever I try, the resulting graph is -
to say it mildly - a mess.

I'd be gratefull for any help solving this.

Regards
Agnes

#2

Agnes wrote:

Quote:

Hi

I hope I am not sending this to the wrong group, but I need some help
solving a problem.

I'm supposed to create a graph which combines two sets of data, and I
can't figure out how to do it, or if it's at all possible.

The graph has to show actual time intervals for specific transaccions,
as bars (different series possible for every transaccion), as well as
overlap those bars with a line indicating the desired time intervall
for the respective transaccion.

A simple bar/line combination graph is eassy to make, but in this case
there's under-elements in the real time-intervals, and no such for the
desired time-intervalls, and whatever I try, the resulting graph is -
to say it mildly - a mess.

I'd be gratefull for any help solving this.

Regards
Agnes

Oracle 10g is a database not a report writing tool. What front-end
product do you intend to use to create the graph? Might I suggest
Oracle Discoverer, the Hyperion line of products, Oracle Reports,
Business Objects and Crystal Reports, etc.?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#3

DA Morgan wrote:

Quote:

Agnes wrote:
Hi

I hope I am not sending this to the wrong group, but I need some help
solving a problem.

I'm supposed to create a graph which combines two sets of data, and I
can't figure out how to do it, or if it's at all possible.

The graph has to show actual time intervals for specific transaccions,
as bars (different series possible for every transaccion), as well as
overlap those bars with a line indicating the desired time intervall
for the respective transaccion.

A simple bar/line combination graph is eassy to make, but in this case
there's under-elements in the real time-intervals, and no such for the
desired time-intervalls, and whatever I try, the resulting graph is -
to say it mildly - a mess.

I'd be gratefull for any help solving this.

Regards
Agnes

Oracle 10g is a database not a report writing tool. What front-end
product do you intend to use to create the graph? Might I suggest
Oracle Discoverer, the Hyperion line of products, Oracle Reports,
Business Objects and Crystal Reports, etc.?

Daniel! Read up on the product guide, and find Oracle Graphics!
It's been a member of the Developer Suite since RPT/RPF, or thereabout.
Didn't it replace OMA, or OPA back in the 80's

I have not seen it so long I dare not just respond to the OP with
a mere "goo luck" - I think knowledge of the product is hard, very
hard to find.
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

#4

Frank van Bortel wrote:

Quote:

DA Morgan wrote:
Agnes wrote:
Hi

I hope I am not sending this to the wrong group, but I need some help
solving a problem.

I'm supposed to create a graph which combines two sets of data, and I
can't figure out how to do it, or if it's at all possible.

The graph has to show actual time intervals for specific transaccions,
as bars (different series possible for every transaccion), as well as
overlap those bars with a line indicating the desired time intervall
for the respective transaccion.

A simple bar/line combination graph is eassy to make, but in this case
there's under-elements in the real time-intervals, and no such for the
desired time-intervalls, and whatever I try, the resulting graph is -
to say it mildly - a mess.

I'd be gratefull for any help solving this.

Regards
Agnes
Oracle 10g is a database not a report writing tool. What front-end
product do you intend to use to create the graph? Might I suggest
Oracle Discoverer, the Hyperion line of products, Oracle Reports,
Business Objects and Crystal Reports, etc.?

Daniel! Read up on the product guide, and find Oracle Graphics!
It's been a member of the Developer Suite since RPT/RPF, or thereabout.
Didn't it replace OMA, or OPA back in the 80's

I have not seen it so long I dare not just respond to the OP with
a mere "goo luck" - I think knowledge of the product is hard, very
hard to find.

If ever Oracle had a synapse-free brain-dead product that deserved
to be buried in an unmarked grave ... Oracle Graphics was it. I built
one application using it back in the 90's and after treatment for
post-traumatic stress and a 12 step program gave it up.

Oracle's newer reporting products are a huge improvement. Heck almost
everybody's reporting tools are a huge improvement.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#5

Daniel,
Oracle reports is not what I would call a great product. It seems to
resemble a DOS or early windows product they never really enhanced other
than moving the product up in every version of the database..

I hate to compare it to ... Crystal Reports, but the development interface
is a lot better in Crystal Reports than Oracle Reports..

However, where I am at now, we are moving Crystal Reports to a custom APEX
application and BI Publisher... However, the powers that be are looking at
Hyperion....

Thank you,

Tony Miller
UTMB/EHN
"DA Morgan" <damorgan (AT) psoug (DOT) org> wrote

Quote:

Frank van Bortel wrote:
DA Morgan wrote:
Agnes wrote:
Hi

I hope I am not sending this to the wrong group, but I need some help
solving a problem.

I'm supposed to create a graph which combines two sets of data, and I
can't figure out how to do it, or if it's at all possible.

The graph has to show actual time intervals for specific transaccions,
as bars (different series possible for every transaccion), as well as
overlap those bars with a line indicating the desired time intervall
for the respective transaccion.

A simple bar/line combination graph is eassy to make, but in this case
there's under-elements in the real time-intervals, and no such for the
desired time-intervalls, and whatever I try, the resulting graph is -
to say it mildly - a mess.

I'd be gratefull for any help solving this.

Regards
Agnes
Oracle 10g is a database not a report writing tool. What front-end
product do you intend to use to create the graph? Might I suggest
Oracle Discoverer, the Hyperion line of products, Oracle Reports,
Business Objects and Crystal Reports, etc.?

Daniel! Read up on the product guide, and find Oracle Graphics!
It's been a member of the Developer Suite since RPT/RPF, or thereabout.
Didn't it replace OMA, or OPA back in the 80's

I have not seen it so long I dare not just respond to the OP with
a mere "goo luck" - I think knowledge of the product is hard, very
hard to find.

If ever Oracle had a synapse-free brain-dead product that deserved
to be buried in an unmarked grave ... Oracle Graphics was it. I built
one application using it back in the 90's and after treatment for
post-traumatic stress and a 12 step program gave it up.

Oracle's newer reporting products are a huge improvement. Heck almost
everybody's reporting tools are a huge improvement.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#6

Tony_Miller wrote:

Quote:

Daniel,
Oracle reports is not what I would call a great product.

I didn't either.

Quote:

However, the powers that be are looking at Hyperion....

Thank you,

Tony Miller

I would look at Hyperion too. Also Siebel Analytics.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#7

Well, as much as I feel like agreeing with you guys any day (and I've
used Reports since the days it was just Report Writer, talk of a dumb
tool!), it won't help me solve my problem. I can't go to the client
and tell them to switch to Crystal Reports, they won't listen, so I
have to live with Repots+Graphics. Reports is fine, but
Graphics....... is giving me a headache <sigh>

Any idea where I could go looking for a solution? The graphics wizard
is sure no help at all! And no web-search has yielded results... I'm
getting desperate here.
--
Agnes

On Nov 22, 4:17 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:

Quote:

Tony_Miller wrote:
Daniel,
Oracle reports is not what I would call a great product.

I didn't either.

However, the powers that be are looking at Hyperion....

Thank you,

Tony Miller

I would look at Hyperion too. Also Siebel Analytics.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damor...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org

#8

Agnes wrote:

Quote:

Well, as much as I feel like agreeing with you guys any day (and I've
used Reports since the days it was just Report Writer, talk of a dumb
tool!), it won't help me solve my problem. I can't go to the client
and tell them to switch to Crystal Reports, they won't listen, so I
have to live with Repots+Graphics. Reports is fine, but
Graphics....... is giving me a headache <sigh

Any idea where I could go looking for a solution? The graphics wizard
is sure no help at all! And no web-search has yielded results... I'm
getting desperate here.
--
Agnes

Large quantities of alcohol often help. <g>

I wouldn't advise you to go to the client and ask them to buy Crystal.
But I do think you can go to them and inform them that Graphics is an
obsolete tool unsupported by Oracle during the current millennium and
incompatible with supported versions of the database.

Question, in a polite manner of course, the wisdom of investing money
into developing something that is unsupported, obsolete, and has no
future.

Never make a technology argument when a financial argument will suffice.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#9

Quote:

Large quantities of alcohol often help. <g

Yep, that I know. I have them waiting at home for me :-)

Quote:

I wouldn't advise you to go to the client and ask them to buy Crystal.
But I do think you can go to them and inform them that Graphics is an
obsolete tool unsupported by Oracle during the current millennium and
incompatible with supported versions of the database.

Question, in a polite manner of course, the wisdom of investing money
into developing something that is unsupported, obsolete, and has no
future.

Never make a technology argument when a financial argument will suffice.

I don't think ANY type of argument coming from a temporary worker in a
third or fourth level branch of a multinational company will make ANY
impression on anyone, especially not the ones in charge of deciding
which software may be used and which one not. Graphics has just been
completely incorporated in Reports instead of being a separate tool,
so the 'unsupported' argument won't really work, not here..... I see
dark times ahead.

Guess the users will have to live with a partial graph, then. Or else
I'll have to work out a way of having the picture create as jpeg and
the added to the Report, all during RunTime.

Where's that whisky?!?

Agnes

#10

Agnes wrote:

Quote:

Where's that whisky?!?

Agnes

Single Malt. On the table in front of me. Bring your own ice.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org