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

[Joe Boyle]

I am pretty sure that your approach will work if you use a portable subfile
and overwrite the .ps part with your data file. I can't recall why this
works when a standard subfile does not.

You will need to make sure that each record is space padded to the correct
data record length though.

-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
vamsi krishna
Sent: 07 November 2006 19: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.