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

Filter (DQM) Application Property Not Working

Started by Cynder, 12 Mar 2019 05:00:54 PM

Previous topic - Next topic

Cynder

I'm working with a DQM configured relational model and trying to set up a summary filter. I've set the Query Subject (DQM) Usage property to "Summary Query", then created a filter and set the filter (DQM) Application property to "After Auto Aggregation". But it doesn't work. The filter always works "Before Auto Aggregation" regardless of the (DQM) Application setting.
I also tested the filter with the IBM Cognos sample data using the sample great_outdoors_sales_dq package, by applying the filter to the Sales query subject, with the test set to Auto Sum:
[gosales].[Sales].[Quantity]  > 10000
The filter only delivers a "Before Auto Aggregation" result regardless of the filter's (DQM) Application property setting. Regardless of how the property is set (before or after) the SQL does not display an "aggregated quantity" being filtered.
So I'm stuck. Don't know if I'm missing something here or if there's a bug in FM.
Any wisdom from the FM gurus would be appreciated... *^_^*