Security Filters using SDK

[gauravd20]

How can i implement data level security filters using COGNOS Java SDK?
Any ideas?

[raro]

As the Cognos-BiBus creates and eventually executes the SQL-statements fetching data to be incorporated into reports, you have to implement data-level-security in the frameworkmanager-model.
e.g. in WHERE-Clause of query-subject use something like:
SELECT s.myproductline,
           s.myproduct,
           s.myvalue
FROM sales s, productline_security ps
WHERE s.myproductline = ps.productline
  and ps.USERID = #sq($account.personalInfo.userName)# )

In Java-SDK you would login into Cognos-Server using named-user logins.

hth.

[gauravd20]

Thanks for the reply.
Actually i am looking on how to create security filters to apply on specific query subject using COGNOS SDK from external application.
Any ideas if some API is being used for its implementation?

[raro]

Imho data-level-security must be done in fm-model on sql-basis as said before.

You can read and write FM-Models via SDK. So you might want to read the fm-model via SDK from the contentstore. Manipulate it as you need and send it back to the contentstore.

hth