COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Jlloyd666 on 13 Oct 2015 07:24:02 AM

Title: Report Author Function - Cognos 10.2.1
Post by: Jlloyd666 on 13 Oct 2015 07:24:02 AM
Ladies and Gents,

My apologies if this question has already been answered.

I'm Looking a function that simple returns the report author/creating however I cannot seem to find it, this is a simple function and id expect it to be readily available.

Regards
Title: Re: Report Author Function - Cognos 10.2.1
Post by: Lynn on 13 Oct 2015 09:57:07 AM
Quote from: Jlloyd666 on 13 Oct 2015 07:24:02 AM
Ladies and Gents,

My apologies if this question has already been answered.

I'm Looking a function that simple returns the report author/creating however I cannot seem to find it, this is a simple function and id expect it to be readily available.

Regards

There are a variety of report functions available although I don't see one that identifies the report author. There are third party tools as well as the SDK that would allow you to interrogate the content store to find this information.

http://www-01.ibm.com/support/knowledgecenter/SSRL5J_1.0.1/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.1.1.doc/c_cogrsreportfunctions.html%23cogrsreportfunctions
Title: Re: Report Author Function - Cognos 10.2.1
Post by: Jlloyd666 on 13 Oct 2015 10:53:03 AM
Thanks for the response, ideally im after the report owner in the header (a header I will use as a template for other report). Is there not something that can be referenced in a layout calculation?
Title: Re: Report Author Function - Cognos 10.2.1
Post by: Lynn on 14 Oct 2015 02:06:41 AM
Quote from: Jlloyd666 on 13 Oct 2015 10:53:03 AM
Thanks for the response, ideally im after the report owner in the header (a header I will use as a template for other report). Is there not something that can be referenced in a layout calculation?

The author could use a text item for this purpose. As I already answered, and as you can see from the documentation link I provided, there doesn't appear to be a report function that identifies the author or the owner of a report.

I'm curious why this would even turn up as a requirement. Many organizations direct user questions through a support group rather than to individual authors. It is also common for development work to be deployed to production through a non-expiring service ID which would then become the owner as far as the production content store is concerned. In user self-service reporting the person authoring is responsible for their own content so putting their own name up there seems unnecessary.
Title: Re: Report Author Function - Cognos 10.2.1
Post by: BigChris on 14 Oct 2015 02:16:40 AM
In smaller organisations it can be useful though to know who to ask questions of, for example about the logic used in the report. I tend to do this by adding a systems information page that doesn't render when the report runs, but contains things like report author, who requested the report, change history etc. You could name the report owner field from there and make a layout component reference to put it into the header. Have to admit that I'm with Lynn on the usefulness of that though...
Title: Re: Report Author Function - Cognos 10.2.1
Post by: Warborn on 14 Jun 2016 01:44:27 PM
Create a new query in your report, add new data item with this in it:

#sq($account.defaultName)#


Add to your page.
Title: Re: Report Author Function - Cognos 10.2.1
Post by: Lynn on 15 Jun 2016 02:12:20 AM
Quote from: Warborn on 14 Jun 2016 01:44:27 PM
Create a new query in your report, add new data item with this in it:

#sq($account.defaultName)#


Add to your page.

I believe that returns the name of the person who is running the report which is not necessarily the person who authored it.
Title: Re: Report Author Function - Cognos 10.2.1
Post by: MFGF on 15 Jun 2016 03:27:44 AM
Quote from: Lynn on 15 Jun 2016 02:12:20 AM
I believe that returns the name of the person who is running the report which is not necessarily the person who authored it.

I believe your belief is the correct thing to believe :)

MF.
Title: Re: Report Author Function - Cognos 10.2.1
Post by: BigChris on 15 Jun 2016 03:33:58 AM
I believe in the omniscience of the mighty Muppett  ;D
Title: Re: Report Author Function - Cognos 10.2.1
Post by: bdbits on 15 Jun 2016 05:12:01 PM
https://www.youtube.com/watch?v=TY3omdNwGWA (https://www.youtube.com/watch?v=TY3omdNwGWA)