COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Cognos8 on 10 Jan 2010 02:49:16 AM

Title: Multiple root directory for save report in local share
Post by: Cognos8 on 10 Jan 2010 02:49:16 AM
Hi,

I can store the report in share path using cognos8.4. in configuration could i mention only the single root directory? or can i mention the multiple root directoy ? because my user wants to store in different share path. is it possbile by having single root directory?

ex single root directoy: file://\\servername\directory.
Title: Re: Multiple root directory for save report in local share
Post by: MFGF on 11 Jan 2010 04:06:25 AM
Hi,

Do you mean saving report outputs (HTML, PDF etc rendered versions of the reports) or saving report XML definitions from Report Studio?

MF.
Title: Re: Multiple root directory for save report in local share
Post by: naveen10046 on 11 Jan 2010 07:31:47 AM
Hello guys,

    how can I convert report saved as excel to pdf.......
Is it possible? If so please guide me......
Title: Re: Multiple root directory for save report in local share
Post by: MFGF on 11 Jan 2010 07:33:57 AM
Run the report again and render it as PDF.

Alternatively, you could use a utility such as Primo PDF as a virtual PDF printer.

Regards,

MF.
Title: Re: Multiple root directory for save report in local share
Post by: naveen10046 on 12 Jan 2010 04:06:04 AM
Hi,
Can I drill through a revenue report which is in the form of bar graph...I want to drill down when I click a bar.....guys please guide me....


Thanks & regards
Naveen :)
Title: Re: Multiple root directory for save report in local share
Post by: MFGF on 12 Jan 2010 04:23:02 AM
Do you mean a)drill down within the existing report or b)drill through to another report?

Both can be done, but for a) the report needs to be based on a dimensionally modelled package, which then allows drill-down through the levels of the dimensional hierarchy defined in the package (go to Data -> Drill Behaviour and enable the drill-down option.)  For b) you need to create a target report which filters on the value you want to pass to it ([Item] = ?Param?) then in the source report, select your chart and define the drill-through using the drill-through definitions property.

MF.
Title: Re: Multiple root directory for save report in local share
Post by: Cognos8 on 12 Jan 2010 05:35:42 AM
Hi,

Yes i mean saving report outputs (HTML, PDF etc rendered versions of the reports) in local share
Title: Re: Multiple root directory for save report in local share
Post by: MFGF on 12 Jan 2010 05:57:42 AM
Quote from: Cognos8 on 12 Jan 2010 05:35:42 AM
Hi,

Yes i mean saving report outputs (HTML, PDF etc rendered versions of the reports) in local share

OK.  Only a single root directory can be configured using CM.OutputLocation, but you can also specify that a post-processing script is run each time an output is saved, and the script could in theory move the output to a new location on disk.  The script (batch file, most likely) can be identified to the C8 server using CM.OutputScript.

See the Cognos 8 Administration and Security Guide, chapter 7, and the Cognos 8 Installation and Configuration Guide, chapter 11, for details.

MF.
Title: Re: Multiple root directory for save report in local share
Post by: Cognos8 on 13 Jan 2010 07:34:12 AM
Hi,

CM.OutputLocation helps to store output in CM not in share path. so do you think will it help me ?
Title: Re: Multiple root directory for save report in local share
Post by: MFGF on 13 Jan 2010 08:06:20 AM
Quote from: Cognos8 on 13 Jan 2010 07:34:12 AM
Hi,

CM.OutputLocation helps to store output in CM not in share path.

No, CM.OutputLocation is used to configure saved outputs saved externally to the filesystem.  If CM.OutputLocation is not set, you then only get outputs saved to the Content Store database.  Take a look at the manual chapters mentioned in the previous post - they describe things nicely.

MF.