Has anyone found a way to set security on the folders or individual reports in the Public Folders section of Intelligence?
We have users who are keen to design their own reports but if we give them edit access to Intelligence then they have access to edit all the public reports.
Do they need access to companywide data or just for the people on their teams? If they just need the information pertinent to their departments they can have 'complete' access to all the reports with the BI reporting which they should already have access to but even though they can see all of the reports listed, when they run the report it will only show data from their employees.
If they need to run reports with companywide data then it would make sense to give them author access.
The issue is that if you give someone author access then they are able to edit any report within the public folders.
We have reports that we run to extract Concur data into other Finance systems so we can't give users author access in case these reports are accidentally edited. We need a way to lock them down so that only Administrators can edit them.
I understand completely. You appreciate their enthusiasm but don't touch my stuff situation...
If you click on the scheduled report you wish to lock down and click the 'Set Properties' icon it will take you to the setup page. From there click the Enable Accessibility Support then down below where it says 'PDF Options' and then Set, click the Set...
That will take you to the below page where you can make it password protected and some other little security options.
I don't see the places Amber mentions.
Years ago I found a way to protect the reports or folders for the same reasons you mentioned. It was not easy to do and we didn't set it up. That option seems to no longer be accessible.
The advice we've gotten is to create a fake employee that will act as Report admin. Move all the reports to the My Folders area of the fake admin employee and use that access to run and manage your reports.
Leave reports safe for all users to access in the public area.
I had it on my To Dr List however now that Intelligence is being discontined I'm not planning to spend the time setting this up.
@SandraA@Rebecca The general/shared profile is another option that can be used for multiple workarounds, not just this one, but be careful because there are also a lot of audit risks involved. I would try every other option first before going this route because of that.
When I get stuck on a reporting issue my go-to solution (besides asking this community) is to open a case with my service team. If you've already done that with no luck then we're going to have to figure it out ourselves. Again, that's the great thing about this group.
Rebecca, were you able to see the password protection page I posted earlier? If you're all unable to find it I'll go back and try to write out better instructions on how to get there.
Unfortunately there is not a way to limit access to specific folders or reports. Security is established by the group Cognos users are assigned in the reporting hierarchy. Once a user is granted access to Cognos they can access all reports but the data they see is restricted based on the group they are assigned to. If you give a BI Manager access to Cognos their view of data is restricted to only their data and their direct and indirect reports.
Thanks for the steps.
I haven't had any luck accessing the password protection page. Either:
1) in the Properties tab there is no Enable Accessibility Support option
2) There is no Properties tab at all
3) Where there is the Enable Accessibilty Support option the 'Set' boxes are greyed out and can't be ticked.
My issue is not really that the users can run the report and see the data but that its possible for anyone to edit them.
Lets hope whichever reporting tool replaces Intelligence has security options!
I had trouble finding them too.
I like the workaround that you suggest. I'll have a look at setting that up.