Help Needed: Cognos Powerhouse. Accessing Flat File in Power House

[Brett Greiner]

Hi Vamsi

We create a record structure of DIRECT that represents the flat file and
rebuild the Powerhouse dictionary.
You must allow a for the CR and NL characters in the flat file.


You can use QUIZ to verify the layout to data is correct, then use QTP
or QUIZ to create your subfile.

Brett Greiner
Synoptix Group Ltd
New Plymouth
New Zealand
p +64 6 759 1929
f +64 6 759 1928
e brett.greiner at synoptix.co.nz 

-----Original Message-----
From: powerh-l-bounces+brett.greiner=synoptix.co.nz at lists.sowder.com
[mailto:powerh-l-bounces+brett.greiner=synoptix.co.nz at lists.sowder.com]
On Behalf Of vamsi krishna
Sent: Wednesday, 8 November 2006 08:04
To: powerh-l at lists.sowder.com
Subject: Help Needed: Cognos Powerhouse. Accessing Flat File in Power
House

Hi ,
I need your help in Powerhouse. Actually i am very new to this
technology.
I work on a Unix system on which Cognos Powerhouse is installed.
I have a text file( flat file) which contains a list of records with
single item(call SRC). I need to access this data, and for that i need
to put this data in a subfile and access through Powerhouse. I created a
empty subfile with required structure and replaced the subfile with the
text file mv VENDORS.txt DUNS_EXTRACT.sf

 and tried to access it using quiz, and results were ambiguous(one
record was split in two lines).
For eg if the record SRC was EA3F446
while doing i got the results in two lines:
EA3
F446
Which is
please tell me how to convert this txt file to a subfile.

I'd be really grateful to you if you can help me in this

Thanks and Regards,
Vamsi
--
"Nothing is impossible as impossible itself says i m possible"
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.