Report filtering on Facts

View previous topic View next topic Go down

Report filtering on Facts

Post  ccioffi on 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

View user profile

Back to top Go down

RE:Report filtering on Facts

Post  hkandpal on 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

View user profile

Back to top Go down

Re: Report filtering on Facts

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Report filtering on Facts

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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