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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Display FM filter in Report Studio Report

Started by kgcognos, 15 Dec 2014 08:40:01 AM

Previous topic - Next topic

kgcognos

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.

cognostechie

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

kgcognos

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