Report filtering on Facts

General question....Attributes are noted as being most commonly used for filtering/grouping in reports and analytics from the star schema, but I never see mention of filtering on facts. I know facts are typically and most commonly used for aggregation, but are there legitimate filtering use cases? For example, a report that counts customers by region who spent more than $100 on an order. (where order_revenue > 100 group by region)

Hi,

You can filter (by using a where clause in your query) if you are capturing the information.
if you are capturing the amount spent on the orders then you can write a query in our reporting tool and generate the output.
THere will be times where you may see a performance hit due to data size or if the same type of summarized data is needed quite often then you can create summary tables/views based on the fact table.
thanks

Himanshu

As far as the literature goes, yeah, it talks primarily about attributes. Attributes provide context to the measures and context exists to group and filter.

But that is not to say measures cannot be used in the same manner. Grouping or segmenting on measures is common practice in a lot of analysis.