COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rockytopmark on 15 Mar 2012 10:12:43 AM

Title: Overriding Cognos Configuration settings in a report definition
Post by: rockytopmark on 15 Mar 2012 10:12:43 AM
Is there a way to override (or just set) a Cognos Configuration setting in the report definition, say, using an HTML Item?  I have one setting that needs to be flipped for just 1 report.

Any info is appreciated!

Thanks, M
Title: Re: Overriding Cognos Configuration settings in a report definition
Post by: Grim on 15 Mar 2012 01:01:56 PM
I've never heard of this. Kind of an odd request...

What setting do you need to flip? There's probably another way to get around it.
Title: Re: Overriding Cognos Configuration settings in a report definition
Post by: rockytopmark on 15 Mar 2012 01:23:52 PM
The configuration setting is the one to eliminate the _n from being appended to the sheet names in Excel output.
RSVP.EXCEL.NUMBEREDSHEETNAMES=FALSE

as Lynn will attest, this and similar requests to have the page named after a data item have been asked a "zillion" times and there is no other way to do it.

I work at a very large company with not quite a zillion projects (but close), so an enterprise-wide configuration change is not possible, so I don't think my request is odd at all, but actually opens the door to many other possibilities here, where the enterprise's configuration is not the best desired for a given project or report.
Title: Re: Overriding Cognos Configuration settings in a report definition
Post by: RobsWalker68 on 16 Mar 2012 04:09:21 AM
Hi,

A possible solution might be to set up another dispatcher which doesn't have the setting and then use advanced dispatcher routing, based on the package or user group to route the report to the appropriate dispatcher.  Not a perfect solution and not exactly what you were looking for but I couldn't think of another way to change the configuration at run time.

Cheers

Rob

Title: Re: Overriding Cognos Configuration settings in a report definition
Post by: rockytopmark on 19 Mar 2012 09:32:06 AM
Rob - Thanks... I actually got this same suggestion from a former colleague I pinged on this subject.   I think it is a viable solution and I will be considering it for sure.

Thank you, M