I have a filter which is appearing in Cognos report studio when I am creating a report using the data items from a particular Query Subject. I am not coding the filter in the report.
When I go into Framework Manager under edit definitions for this Query Subject there are no filters under the FILTER tab. I have looked under all Query subjects defined in this project and still cannot find this mystery filter. Can anyone give me some suggestions as to where I might look to find this filter ?
`Operating_Account_Ledger_Table`.`ACTIVITY_DATE` between `Account_Table`.`EFF_DATE`
and `Account_Table`.`NCHG_DATE`
Thanks
Hi,
Can you take a screen shot in report studio and show what embedded filter you are looking for. And are you the author for the framework model? If not make sure your modeller has provided you with the most current model file.
Genenral practice the modeller would design a folder named FILTER, and you add your embedded filters in that and refer them in various package publish to accompany the query subjects. The filter you were looking for thru edit defination is an applied filter not embedded difference being that its applied for the entire query subject were as the embedded is a predefined filter in FM applied for report build time. Hope this makes sense.
Thanks,
RK
Hi,
It could likely be a security filter. Select your query subject, then from the menubar select Actions > Specify Data Security. Do you see the filter here?
Cheers!
MF.
I think this filter must be and applied filter... but I don't see it anywhere in my Filters folder.
Anytime I use the Query Subject in Report Studio the filter is applied automatically... and I can see it when use the generate sql. Enclosed is a screen shot in Framework Manager of the Query Subject 'Operating Account Ledger Table' showing that there are no embedded filters in ACTIONS > SPECIFY DATA SECURITY. Screen shot also displays all of the applied filters in the 'financial filters' folder (bottom left).
I should add that the filter is only applied to the Query Subject when a join is done to another Query Subject in report Studio.
Does it show up in lineage?
Have you checked the SQL of the query subject to see if the filter has been hard-coded as a predicate (where clause) in the SQL?
MF.
Are you certain it's a filter? It looks like a join predicate to me - two tables being joined. Perhaps you have a column from another table in your query subject so it's joining these two tables:
Operating_Account_Ledger_Table
Account_Table
Ah! Good spot there! It could well be a coded relationship expression!
or maybe a Prompt macro too used in conjunction with a data column for security