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)

ccioffi

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

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

hkandpal

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.
ngalemmo
ngalemmo

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

http://aginity.com

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