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

vamsi krishna vamsi.coe at gmail.com
Tue Nov 7 13:03:51 CST 2006


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"


More information about the powerh-l mailing list