We are testing the data security in FM. We applied some filters in FM so certain users only see subset of data.
Is it possible in Report Studio to display the applied filters from FM to the report? We want the report to show for ie. a Canadian user is set up in FM to see Canada Sales only. The report should show that there is a filter on Country = Canada.
Thank you in advance.
That will depend on what functions/macros/method you used to apply security in FM. Whatever logic you have used to filter the data in FM has to be exposed (partially) and that will provide the display of filter in the report. You can create standalone filters in FM with the same logic which can be used in the Report but again, that will depend on what you did in FM . Without knowing the details, we cannot provide the answer
Here is what we did in FM:
1. In FM, we created different Filter Definition.
For ie. Name of Filter is "Canada". The Expression Definition is [BusinessLayer].[FromFile].[Country] ='CAN'
2. We then assigned the Filters to User Group.
In Security Filters, there is an entry like this:
Group Based On Filter
Cognos Canada Users Canada
When a Cognos Canada Users runs a report studio report, he only sees Canada data only.
What we would like is to dispay the statement in Expression Definition from FM.
We want to show the user there is a filter on Country = Canada.
Thank you