If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Author Function - Cognos 10.2.1

Started by Jlloyd666, 13 Oct 2015 07:24:02 AM

Previous topic - Next topic

Jlloyd666

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

Lynn

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

Jlloyd666

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?

Lynn

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.

BigChris

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...

Warborn

Create a new query in your report, add new data item with this in it:

#sq($account.defaultName)#


Add to your page.

Lynn

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.

MFGF

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.
Meep!

BigChris

I believe in the omniscience of the mighty Muppett  ;D