We run Cognos on desktops and it's using SQL statements to grap data, direct
access to the DB.
Basically the sales order header, detail, Address book, Inventory
master.....SOP related tables. Cognos uses 'joins' to link all these tables
up. If I understand correctly when there's a filter the program fetches all
records joined and then only apply the filter so it makes no difference
whether you are just selecting one order and a range of orders- it takes
about the same amount of time with maybe just some slight difference of time
in formatting it on the screen.
This is unlike the OW tool, I hope - 'fetch next' where there is no
redundancy.
I'm trying to find out if there is also a user group / list like this one
for Cognos or ways to fine-tune if possible SQL statements used. Not too
sure it's worth all the effort or just use ERW for reporting.
Thanks.
Sook Fun
---Original Message-----
From: Kevin Stone [mailto:
[email protected]]
Sent: Friday, November 10, 2000 9:24 PM
To:
[email protected]
Subject: RE: Oracle DB to MS Access ~~755:854
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C04B19.31CE05E8
Content-Type: text/plain;
charset="iso-8859-1"
I am not familiar with Cognos or the Ad-Hoc Query solutions they have. But
if you are having speed problems using the application, you could have a
number of different causes, and putting Access in the middle of it will
compound the problem.
My questions are:
What kind of machine is Cognos on? A server or desktop?
Does Cognos link or import the tables (or use Oracle SQL to grab the data?)?
What tables are you pulling out of Oracle?
How many records do you have in those tables?
Kevin
--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
854
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at
http://www.JDELIST.com
*************************************************************