Filter on fact query item not working

[WILLA]

Hi everyone,

On framewok manager I created a query item ( count ( distinct id) )  = 500 000 which corresponds for example to the number of sales in report studio I created a list to show the number of sales per year.

Example
-----------
count(distinct id) = 500 000

In report studio :
--------------------------

Year                  Sales
2015                  100 000
2014                   30 000
2013                   370 000

Assuming i want to see only years more than 100 000 sales (i create filter => applying after aggregation)

By analyzing the SQL code returned by the query cognos. The query filter sales more than "count(distinct id) = 500 000".

results after applying filter
--------------------------------
Year                  Sales
2015                  100 000
2014                   30 000
2013                   370 000

[bdbits]

Please do not double post. This violates rule #4, please see http://www.cognoise.com/index.php/topic,24030.0.html.

Any replies should go to the original thread at http://www.cognoise.com/index.php/topic,30612.0/topicseen.html.