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... *^_^*