Data level security for report author in cognos 11.0.3 for SSAS datasource

[lalitha.nov20]

Hi All,

Here i have a requirement on Cognos 11.0.3 reporting, where the data source is SSAS cube.

Data level security :

SSAS cube has a .net code /xml attached to it which accepts the user login and provide the list of account the user has access to. A third party front end was used to design the reports which passes this list of account to SSAS cube . Once the user login to the cube he would be seeing only data he has access too.

With this report author will also be able to design adhoc reports on data that he can view only.

Can we provide the report author of cognos the same kind of data level security. if so, please let me know how can we achieve it.

Thank you,
lalitha