COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: kyleb556 on 16 May 2016 01:25:24 PM

Title: Option to Save to the File System not available in Cognos 11
Post by: kyleb556 on 16 May 2016 01:25:24 PM
I'm testing out Cognos Analytics 11.0.2 and I cannot get the "save to the file system" option to show in either the Run As or Scheduled delivery options for reports.
The option should show up under the "Delivery" section but I can't make it appear. There is an option called "Save the report on the system" but this is something different.

I've followed the steps in the Cognos 11 install and admin guides.
1. Made a root directory, make share, add permissions
2. Edit Global Configuration, General tab, add root directory
3. Data Access, Content Manager, "Save report outputs to a file system" = True
4. In Administration, Configuration, Dispatchers, Define file system Locations, created new location.

I need this function for file retention rules. I submitted a PMR to IBM and they said it's "not a defect" and it's "on the developer's radar".... whatever that means.

Has anyone been able to make this function work in Cognos 11? Any help is most welcome as this is a showstopper bug for me.

Cognos Anayltics 11.0.2
Windows Server 2008 R2
IIS 7.5
Content Manager, SQL Server 2012
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: dougp on 16 May 2016 07:27:14 PM
I think you're confusing two different features.

I think you want (1) -- I know I do.  I use it quite a bit in 10.2.1. -- but have followed the instructions for (2).  I haven't found the documentation for (1) in the Cognos Analytics documentation.  I found it in the Cognos 10.2.2 docs (http://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.c8bizos_ig.10.2.2.doc/t_c8zos_optsavereportoutputinsidetheproduct.html?lang=en), but the same changes seem to have no effect in Cognos Analytics.

Please post here if you are actually able to get this working.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: dougp on 16 May 2016 07:31:08 PM
...and this thread may belong in the Administration and Security child board, not in Reporting.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: kyleb556 on 17 May 2016 11:47:45 AM
Thanks dougp, but I'm not confusing the two. I definitely want (1). To set up (2), you would need to set up the CM.OutPutLocation value in the Content Manager service, which will save a copy of all report output to the file system. I only want it when selected in the delivery options.

The instructions for setting up (1) are split between two documents, the first part is on page 171/172 of the Analytics Installation and Configuration guide (Content Manager part). The second part is on page 123 of the Analytics Administration and Security guide (Dispatchers part).

IBM's recommendation to get it to work in Cognos 11 was to make fake events in event studio that triggered reports, since the option to save to the file system shows up in the old interface in event studio. I argued with IBM yesterday because they were adamant it wasn't a defect. They then tried to call it an enhancement, but finally agreed that it is a bug.

I guess my options are to either put the upgrade on hold for a later version, or set up (2) and write scripts to delete all the report outputs that I don't want.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: kyleb556 on 25 May 2016 03:06:59 PM
Just an update, here is the response back from IBM. Looks like this feature won't work for a while.

We have talked to the product manager.
They will treat it as a documentation defect and the functionality will not be able to be added very soon.
I apologize for the inconvenience caused.
The enhancement is still valid and hopefully it will be appear in the next release. However, it will not be fixed in the fix packs.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: dougp on 25 May 2016 03:54:29 PM
Thanks for the update.  Please post back here when you hear they have included this feature.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: kyleb556 on 02 Jun 2016 10:27:39 AM
Very unexpectedly, I received an update from IBM this morning:

To provide better service for customer, we have decided to change the defect to a product defect and it will be officially fixed in the future fix packs in CA11. Here is the defect number PI63047. Please track this defect with this number in 2 weeks.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: cognosjedi on 25 Jul 2016 03:29:32 PM
kyleb556  - Thanks for finding this.  We use this heavily as well!  1 would think this is a feature someone internally should have QA'd or UAT'd previously
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: cadams on 27 Jul 2016 10:35:02 PM
Its targeted for R4.

If I get an update I'll update you, We're pushing for a Hot Site.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: cognosjedi on 05 Aug 2016 03:03:31 PM
We had a recent call with our account rep.  Release 4 is to be by end of year.  Cross our fingers i suppose at this point.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: MFGF on 08 Aug 2016 03:17:56 AM
Quote from: cognosjedi on 05 Aug 2016 03:03:31 PM
We had a recent call with our account rep.  Release 4 is to be by end of year.  Cross our fingers i suppose at this point.

Looking at the release dates we've seen so far, each new release seems to be around two to three months after the previous one. R3 was released on 6th July, so I'd hope to see R4 well before the end of the year. Hope I'm not being optimistic! :)

MF.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: cadams on 09 Aug 2016 08:45:27 PM
I'm working heavily with the Project Management team at IBM at the moment a lot of eyes are on my project at IBM, I've been told that R4 is expected late September.
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: cepete02 on 06 Mar 2018 10:37:33 AM
Just curious if there is any update on this issue?  It seems I'm still experiencing the problem in 11.0.9.
Thanks,
Carl
Title: Re: Option to Save to the File System not available in Cognos 11
Post by: dougp on 06 Mar 2018 01:08:32 PM
This was resolved in 11.0.4.

There was some unclear communication early in this thread.  This is for scheduled reports or reports run in the background using Run as.  It does not apply to the save button when viewing a report in the UI.  For that, the report should be run to the desired output format and saved appropriately.

See the help for Save Report Output Inside IBM Cognos Analytics (http://"https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_savereportoutputinsidecognos8.html#SaveReportOutputInsideCognos8").

The documentation seems to indicate that you can only save outputs to the local machine, but that's not entirely true.  I use Windows which allows me to create symbolic links (or whatever Microsoft calls them - junctions?).  Here's my process: