Hi all,
In a similar post, I described a problem in which I could not programmically select all members of a file picklist in an Impromptu report. As a workaround, I'm looking at setting up a hotfile. I have a hotfile which contains all "approved carriers" for my company. I then want to run a report that shows all shipments carried by a vendor NOT in our approved list. I've added the HotFile column 'Vendor ID' to my catalog. Now in my report filter I want to say something like
... and Carrier ID not in ( Vendor Id ) ...
but it only compares the Carrier ID to the FIRST id in my Vendor ID list. How do I get it to search the entire hotfile for the ID before it goes to the next one? I apologize for the simplicity of this question, I am new to Cognos and HotFiles.
Thanks in advance for any tips.
In a similar post, I described a problem in which I could not programmically select all members of a file picklist in an Impromptu report. As a workaround, I'm looking at setting up a hotfile. I have a hotfile which contains all "approved carriers" for my company. I then want to run a report that shows all shipments carried by a vendor NOT in our approved list. I've added the HotFile column 'Vendor ID' to my catalog. Now in my report filter I want to say something like
... and Carrier ID not in ( Vendor Id ) ...
but it only compares the Carrier ID to the FIRST id in my Vendor ID list. How do I get it to search the entire hotfile for the ID before it goes to the next one? I apologize for the simplicity of this question, I am new to Cognos and HotFiles.
Thanks in advance for any tips.