Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Report filtering on Facts

3 posters

Go down

Report filtering on Facts Empty Report filtering on Facts

Post  ccioffi Fri Sep 19, 2014 8:43 am

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)


Posts : 7
Join date : 2014-03-28

Back to top Go down

Report filtering on Facts Empty RE:Report filtering on Facts

Post  hkandpal Fri Sep 19, 2014 11:38 am


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.



Posts : 113
Join date : 2010-08-16

Back to top Go down

Report filtering on Facts Empty Re: Report filtering on Facts

Post  ngalemmo Fri Sep 19, 2014 12:41 pm

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.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Report filtering on Facts Empty Re: Report filtering on Facts

Post  Sponsored content

Sponsored content

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum