I have a query that has list DataItems : Year,Quater,Product Line, Quantity. I have 2 options to make a filter
Opt 1. [Quantity] > 100
Opt 2. [Business View].[Sale].[Quantity] > 100
what the difference between 2 options ?
It is a matter of reference. If you check the query proposition, you will notice it is identical
With a detail filter, it makes no difference at all. There is a radio button / properties option to control the timing of the filter - before or after the default aggregation takes place.
With a query calculation things are different. There is no property/radio button to control the timing of a query calculation, and the rules there are that if you bring in items from the package (with a fully qualitied name), the timing of the calc is before the default aggregation occurs. If you define the calculation using items from the query (ie just the item name in the reference), the timing is after the default aggregation occurs.
So - as Ties said - with a filter, it is a matter of reference. It makes no difference to the result.
Cheers!
MF.
Could you give me an example of a detail filter and a query calculation ? I have try drop a query calculation from toolbox to page body and when I edit the query, I still can see a radio button / properties option to control the timing of the filter.
In your case, it makes no difference because you are interested only in the filter , not in a query calculation.
When you go to the query and see those radio buttons for the filter, that is at the query level because the filter applies to the entire query. That has nothing to do with the query calculation which you dropped in the page body. When you dropped a query calculation to the page body, it might have created another query too if you did not drop it in the List.