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

 

Error running report against olap source with measure permission.

Started by oscarca, 04 Jun 2020 04:19:17 AM

Previous topic - Next topic

oscarca

Hello Cognos community,

I have a report that consists of a list with multiple measures that runs agains an SSAS cube. If I apply security on the measures so only  certain users can view certain measures this error will occur everytime a user tries the run the report:
Failure: QE-DEF-0157 The model or package  does not exist or you are not allowed to use it because of security settings.
Original Error: XQE-V5-0005 Identifier not found '[Sales].[Measures].[XXX].
The users have Read, Execute and Traverse so they should be able to run the report. If you run the cube in Excel it works with the permission setting but not in Cognos. If I remove the permission setting in the cube the users can run the report again without any errors but then they can view more measures then they should.

I am using Cognos Analytics 11.0.7. Could this be a bug ? or does anyone know how to solve this ?

Best regards,
Rubrix