Focal Point
[CLOSED] Forcing filter created in master file on all procedures that use it?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1237067096

September 12, 2018, 10:11 AM
JayInBoston
[CLOSED] Forcing filter created in master file on all procedures that use it?
It seems to me it should be possible to set a filter on a master file and have it affect all downstream procedures & reports.

I followed these directions and added a VERY specific filter, which should have cut the results down to 1% of normal:

https://infocenter.information...source%2Ftopic31.htm

But adding the filter seems to have no effect on the results.

Any ideas?

Thanks!

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105
September 12, 2018, 10:15 AM
BabakNYC
The filters described in the link are created so your users can drag and drop them into their reports instead of creating them from scratch. They don't automatically filter the data just because they're present in the master. In order to always filter the data with a specific condition, you can create a Reporting Object which will enforce the filter when users create reports with it. The alternative to that is to use a Master File Profile.
https://webfocusinfocenter.inf...ang/source/ids24.htm


WebFOCUS 8206, Unix, Windows
September 12, 2018, 11:54 AM
MartinY
You must look for DBA feature in the master file which seems to be what you're looking for.
You can find several post/document on it.
Here on:
Implementing Data Source Security


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007