Modeling products that *didn't* sell

View previous topic View next topic Go down

Modeling products that *didn't* sell

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

View user profile

Back to top Go down

Re: Modeling products that *didn't* sell

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

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

View user profile http://aginity.com

Back to top Go down

Re: Modeling products that *didn't* sell

Post  BoxesAndLines on Wed Sep 18, 2013 8:37 am

avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Modeling products that *didn't* sell

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

View user profile

Back to top Go down

Re: Modeling products that *didn't* sell

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