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

Modeling products that *didn't* sell

3 posters

Go down

Modeling products that *didn't* sell Empty Modeling products that *didn't* sell

Post  sj1ch Tue Sep 17, 2013 10:47 am

Is there a standard modeling approach which supports analysis of both what *did* happen as well as what *did not* happen?

For example, I’ve got a line of “value” products which should be top sellers in all of our stores.  In addition to tracking the performance of those products within each store, users need to be able to identify the stores which are not selling those products.  The exception reporting is as important as the performance reporting.

In a star-schema design where the BI tool is essentially doing INNER JOINs between the dimension & facts, stores which had no sales fall off of the report. A user may know that they have 78 stores in a region and see that only 77 stores appear on the sales report.  They know that the final store fell off of the report due to a lack of sales; but it would be helpful to be able to call out those exceptions as well.

Thanks for your help.

sj1ch

Posts : 2
Join date : 2013-09-17

Back to top Go down

Modeling products that *didn't* sell Empty Re: Modeling products that *didn't* sell

Post  ngalemmo Tue Sep 17, 2013 11:38 am

You could do an outer join from item to sales or create an aggregate snapshot using outer joins.

If your BI tool can't handle it, you could create a view that uses product and sales.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Modeling products that *didn't* sell Empty Re: Modeling products that *didn't* sell

Post  BoxesAndLines Wed Sep 18, 2013 8:37 am

Yes there is, here's a link, http://www.kimballgroup.com/1996/09/02/factless-fact-tables/
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Modeling products that *didn't* sell Empty Re: Modeling products that *didn't* sell

Post  sj1ch Wed Sep 18, 2013 10:53 am

Thanks for the responses. I've used factless fact tables before but never in the form of a coverage table. Obviously, the coverage table is designed to answer very specific questions; but I think it will work for us.

sj1ch

Posts : 2
Join date : 2013-09-17

Back to top Go down

Modeling products that *didn't* sell Empty Re: Modeling products that *didn't* sell

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