Author Topic: Cognos Analysis Studio Report Sharing  (Read 221 times)

Offline GeethaKL

  • Senior Member
  • ****
  • Join Date: Apr 2015
  • Posts: 67
  • Forum Citizenship: +1/-0
Cognos Analysis Studio Report Sharing
« on: 15 Oct 2018 09:00:17 pm »
Hello All,

I have got  a requirement from my user that he wants to know the procedure to share the Analysis Studio report url listed in 'My Folders' to other users.

I tried o share the Url from report 'Set properties' -> Veiw the search path, ID and URL'. But its throwing error 'An unexpected error occurred'.

Is it possible to share the Url? If Yes, Please let me know the procedure. Thank you

Regards
Geetha


Offline sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 476
  • Forum Citizenship: +3/-0
Re: Cognos Analysis Studio Report Sharing
« Reply #1 on: 16 Oct 2018 07:12:35 am »
put the analysis/report in a public location.

shirish.dawane

  • Guest
Re: Cognos Analysis Studio Report Sharing
« Reply #2 on: 16 Oct 2018 07:39:55 am »
Hello All,

I have got  a requirement from my user that he wants to know the procedure to share the Analysis Studio report url listed in 'My Folders' to other users.

I tried o share the Url from report 'Set properties' -> Veiw the search path, ID and URL'. But its throwing error 'An unexpected error occurred'.

Is it possible to share the Url? If Yes, Please let me know the procedure. Thank you

Regards
Geetha

"My Folders" is user specific location which can be accessible only to that user and Administrator. Other user can't access that user specific location.

You can copy those reports to "Public Folders" by creating folder in it and give permission to required user(s).

Hope this helps.

Regards,
S.G.D.

Offline GeethaKL

  • Senior Member
  • ****
  • Join Date: Apr 2015
  • Posts: 67
  • Forum Citizenship: +1/-0
Re: Cognos Analysis Studio Report Sharing
« Reply #3 on: 29 Oct 2018 06:39:20 pm »
Thanks Sdf and Shirish Dawane.

I have informed the tech team that the user have to copy the reports from 'My Folders' and paste it in the Shard Content(  a folder created in Public Folders). The other users can copy those reports and put it in his or her My Folders.

Now the teach team wanted to check whether I can create any cognos job so that Shared content folder reports can be deleted once in a day or a week.
Is it possible to CREATE A JOB in cognos portal under SHARED CONTENt FOLDER so as to schedule and delete the reports every 24 hours automatically? If yes, please let me know the procedure.
Else if there is any alternative, please let me know...

Thanks in advance

Regards
Geetha

Offline sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 476
  • Forum Citizenship: +3/-0
Re: Cognos Analysis Studio Report Sharing
« Reply #4 on: 30 Oct 2018 07:09:24 am »
There's a Content Removal in the Content Maintenance Tasks in Cognos Administration console.
That might help you with this. Though, I have not tried this myself.

I believe there are documentations regarding this so better to read them first before doing anything.

Offline GeethaKL

  • Senior Member
  • ****
  • Join Date: Apr 2015
  • Posts: 67
  • Forum Citizenship: +1/-0
Re: Cognos Analysis Studio Report Sharing
« Reply #5 on: 02 Nov 2018 01:45:41 am »
Thank you for this.
I have tried to follow the procedure, whatever I read from the documentation and from the google.
I am able to create a Content Removal task under Configuration tab (Content Administration). In the procedure, I selected a folder from which I would like to get the reports deleted automatically. However I could not see any reports in that folder. So just selected the folder and applied schedule to run the task for every 1 day. the task ran successfully and got the message :

"CM-ADM-4024. For the search path/ shared report folder - objects were added to a workflow with following status. 0 successfully and 0 unsuccessfully".
And the reports didnt get deleted from shared reports folder.

Looks like I missed something important here
PLease advise me further

Thank
regards
Geetha



Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,411
  • Forum Citizenship: +627/-10
  • Cognos Software Muppet
Re: Cognos Analysis Studio Report Sharing
« Reply #6 on: 02 Nov 2018 04:14:24 am »
Thank you for this.
I have tried to follow the procedure, whatever I read from the documentation and from the google.
I am able to create a Content Removal task under Configuration tab (Content Administration). In the procedure, I selected a folder from which I would like to get the reports deleted automatically. However I could not see any reports in that folder. So just selected the folder and applied schedule to run the task for every 1 day. the task ran successfully and got the message :

"CM-ADM-4024. For the search path/ shared report folder - objects were added to a workflow with following status. 0 successfully and 0 unsuccessfully".
And the reports didnt get deleted from shared reports folder.

Looks like I missed something important here
PLease advise me further

Thank
regards
Geetha

Hi,

It looks to me like you're misunderstanding what a Content Removal task is designed to do. It won't ever delete actual reports. It is designed to remove Run History and /or Saved Report Output Versions from the content store from any reports it finds in the path you specify.

Cheers!

MF.
Meep!

Offline GeethaKL

  • Senior Member
  • ****
  • Join Date: Apr 2015
  • Posts: 67
  • Forum Citizenship: +1/-0
Re: Cognos Analysis Studio Report Sharing
« Reply #7 on: 07 Nov 2018 04:39:14 pm »
Thanks MFGF
Yeah I tried to understand the functionality of it.
Coming back to my actual question, Is there any way in cognos to get the Reports deleted automatically
or Should I develop a script in Sql Management Studio and insert a Trigger delete against a cognos content store database.

If possible can you please let me know the procedures either at cognos level or a SQL management Studio level?
Thank you

Regards
Geetha

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,411
  • Forum Citizenship: +627/-10
  • Cognos Software Muppet
Re: Cognos Analysis Studio Report Sharing
« Reply #8 on: 08 Nov 2018 05:50:57 am »
Thanks MFGF
Yeah I tried to understand the functionality of it.
Coming back to my actual question, Is there any way in cognos to get the Reports deleted automatically
or Should I develop a script in Sql Management Studio and insert a Trigger delete against a cognos content store database.

If possible can you please let me know the procedures either at cognos level or a SQL management Studio level?
Thank you

Regards
Geetha

Hi,

There is nothing in the Cognos UI that automates deletion of reports. The best approach would be to use the SDK and a custom application to delete the content you need to remove.

I certainly wouldn't recommend you hacking the content store using SQL - that's a very dangerous approach.

Cheers!

MF.
Meep!

 


       
Twittear