How can i implement data level security filters using COGNOS Java SDK?
Any ideas?
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.
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?
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