COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: ozzloz on 03 Jul 2009 04:26:47 AM

Title: Save Query in CSV format to a network drive
Post by: ozzloz on 03 Jul 2009 04:26:47 AM
Hello,
       I a have a Query that generates a CSV file which is too large to be sent by email, is there a way to configure Query Studi so it saves the Query to a Network Drive so all users can access it without going to the Portal to download it? I am using Cognos 8.3.

Thanks,
Title: Re: Save Query in CSV format to a network drive
Post by: DustPanMan on 06 Jul 2009 10:15:05 AM
In Cognos 8v3 and beyond, an administrator can set up a network directory in Cognos Configuration.  Once this is set up and services are restarted, when you try to schedule a report to run, you will have a new option "Save to Directory".  You can set parameters to add a date/time stamp as well.  All of the precise details on setting this up can be found in your admin guide.

Best of luck.
Title: Re: Save Query in CSV format to a network drive
Post by: UseCog on 08 Jul 2009 04:11:31 AM
Hi DustPanMan,

Are you mentioning about the NTLM? can you please make this a little more clear

Thanks in advance
Title: Re: Save Query in CSV format to a network drive
Post by: DustPanMan on 09 Jul 2009 11:01:12 AM
NTLM?
Title: Re: Save Query in CSV format to a network drive
Post by: UseCog on 09 Jul 2009 11:46:10 AM
oooops...my mistake.

can you please tell us how to create a network directory in Cognos Configuration in 8.3/8.4
Title: Re: Save Query in CSV format to a network drive
Post by: ozzloz on 10 Jul 2009 05:12:49 AM
Thanks for your reply,

I've tried to set this up following the instructions in the administration guides but I haven't been successful.

I added the folder where I want the reports to be saved to the global configuration in Cognos configuration and I tested it successfully.

I activated the option in cognos configuration to allow reports to be saved in a file system.

I created a in cognos administration --> cognos configuration a location where I want the reports to be saved (a sub-folder of the folder setup as the root folder in cognos configuration)

I now have the option to save the report in a file system but when I run the report I get a message

CNC-DS-0023 Impossible to create the directory to save the report version

Have forgotten something?

Thanks
Title: Re: Save Query in CSV format to a network drive
Post by: DustPanMan on 10 Jul 2009 10:34:46 AM
Ozzloz,

You're almost there.  All you have to do is create the sub folder under the base folder.  Cognos will not create new folders for you during this.  You should alos make sure that the security on the File Directory server is set appropriately... let me know when you get it.

Best,

Dustin