What's missing in the security?

[PlayCognos]

I published a package (ST_Appln) and granted read, write, execute and traverse permissions to a cognos group (ST_Gp). The ST_Gp has been granted access to the data source (DS_ST) against which the data is pulled from.

When an user runs a report who is part of the ST_Gp cognos group, it gives an error "Unable to find the data source 'DS_ST' in the content store".

Any idea what I might be doing wrong?

Thank you.
PC

[Ty Clabbers]

can you post the complete error message? And did you test the data source in Cognos connection?

[cognosjon]

Is the datasource (DS_ST)  listed as a datasource within Cognos connection as that error implies it is not.
Have you published the package to a different C8 server from which you created the package.
For example from a dev server , where the datasource connection exists to a production server where it currently does not?

[DL20852]

What version of Cognos are you working with...?

[rockytopmark]

Add Cognos -> Everyone back to the Data Source first, so they can execute reports using the Datasource.

Then examine all the security you have implemented.  I have to admit I am not well-versed in this area of C8, but I can say that explicit designation of rights can make a mess that is hard to recover from later.

Try removing all the explicit grants and get the reports to work and then apply one new grant back at a time until you can identify the problem.  Also, your user may have multiple group assignments.  If another group is set to DENY access to this Datasource, that DENY may override the grant given in the other group.

Just thoughts...

GL!

[cognosjon]

Take a look at this Cognos KB Doc to see if it helps shed any light.

Document Number 1003268.4

http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=127710

[PlayCognos]

Sorry for the delay in responding. I had to get some details from the Cognos admin.

Ty, The error message that user is getting is "Unable to find the data source DS_ST in the content store."

cognosjon, The data source DS_ST is listed in the Cognos connection. The package is published to a server from which I created the package (FYI..there is another server that does the load sharing).

Also, the kb article that you have mentioned pertains to (Unable to find the database when trying to run reports). Would that be the same for "Unable to find the data sourse int he content store"?

DL20852, we are running C8.

rockytopmark, I have not tried your option but will pass that on to the Cognos admin since I donot have access to the Cognos admin interface.

Thank you all for your feedback. Will post back when I try the other options I have not tried yet. Please add on to your suggestions if you have more to share.

PC

[PlayCognos]

The Cognos groups in the data source was not specified right. Once that was done, the error was gone.

Thank you all for your feedback.

PC