RE: [nv-l] TDW Blank Reports!!!
2006-05-05 12:10:57
Usman,
1) What version of TDW and Crystal are you using ? What fixpacks
have you applied ? 2) Are all the
components on one machine, or are they distributed ? Please describe the
architecture of your environment. 3) If
the Crystal Enterprise Server and the Data Mart are on different servers, did
you perform this step from the TDW Installation Manual:
To create an ODBC connection from the Crystal Enterprise server to a data
mart on DB2 Universal Database, choose from one of the following options: If the
Crystal Enterprise server is on a stand-alone system and no other Tivoli Data
Warehouse components are installed on the system, use twh_create_datasource to
create an ODBC data source on the Crystal Enterprise server...
Thanks a lot, if i am not mistaken
this script is written to extract data from ITM DWH! will it work for Netview's
DWH as well?? Coz i dont see any of relevant tables in the queries!
Regards,
Usman Taokeer Si3
"Hoang, Michael D CONT
\(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil> Sent by: owner-nv-l AT lists.us.ibm DOT com
05-05-06 08:38 PM
Please respond
to nv-l AT lists.us.ibm DOT com |
|
To
| <nv-l AT lists.us.ibm DOT com>
|
cc
|
|
Subject
| RE: [nv-l] TDW Blank
Reports!!! |
|
Usman, Modify the user name and
password....run this perl script to see if there is data in your TWD_MD
database. %TWH_TOPDIR\tools\perl\bin\perl.exe amy_check_host_data.pl Let me know how this goes.
From: owner-nv-l AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of
usman.taokeer AT s-iii DOT com Sent: Friday, May 05, 2006 11:28
AM To: nv-l AT lists.us.ibm DOT com Cc:
nv-l AT lists.us.ibm DOT com Subject: RE: [nv-l] TDW Blank
Reports!!!
well.. there isn't any
data... what next! -----owner-nv-l AT lists.us.ibm DOT com wrote: -----
To: <nv-l AT lists.us.ibm DOT com> From: "Hoang, Michael D CONT
\(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil> Sent by:
owner-nv-l AT lists.us.ibm DOT com Date: 05/05/2006 08:09PM Subject: RE: [nv-l]
TDW Blank Reports!!!
Usman,
Make sure there is data in the TWH_MD
database.
From: owner-nv-l AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of Colin
Mulkerrins Sent: Friday, May 05, 2006 11:01 AM To:
nv-l AT lists.us.ibm DOT com Subject: RE: [nv-l] TDW Blank
Reports!!!
Hey Usman, Welcome to my
world. Never had any satisfaction from TDW - gave up on it...
Regs
Colin M -----Original
Message----- From: owner-nv-l AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of
usman.taokeer AT s-iii DOT com Sent: 05 May 2006 16:00 To:
nv-l AT lists.us.ibm DOT com Subject: [nv-l] TDW Blank
Reports!!! Importance: High
Hi,
TDW
1.3 WEP ANM 1.2.1 NV FP04 Win2003 std SP1
Installed Tivoli Data
warehouse 1.3 and WEP 1.2, Executed ETL but when check reports on crystal server
there is no data, the ETL processs was successfull, but yet i dont see any data
when i execute any of the reports. Any reason ... what can i check to trouble
shoot this ... the installation went smooth followed all the
steps.
Regards,
Usman Taokeer Si3.
*********************************************************************************
This e-mail and its attachments, is confidential and is intended
for the addressee(s) only. If you are not the intended recipient, disclosure,
distribution or any action taken in reliance on it is prohibited and may be
unlawful. Please note that any information expressed in this message or its
attachments is not given or endorsed by An Post unless otherwise indicated by an
authorised representative independently of this message. An Post does not accept
responsibility for the contents of this message and although it has been scanned
for viruses An Post will not accept responsibility for any damage caused as a
result of a virus being passed on.
*********************************************************************************
|
|
|