Modeling products that *didn't* sell
3 posters
Page 1 of 1
Modeling products that *didn't* sell
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.
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
Re: Modeling products that *didn't* sell
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.
If your BI tool can't handle it, you could create a view that uses product and sales.
Re: Modeling products that *didn't* sell
Yes there is, here's a link, http://www.kimballgroup.com/1996/09/02/factless-fact-tables/
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Modeling products that *didn't* sell
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
Similar topics
» Modeling Financial Products
» Modelling Products with Stages
» Production/Consumption products cube
» Modelling Sales of Products and Product Packs
» Designing Sales Promotion for Packed Products
» Modelling Products with Stages
» Production/Consumption products cube
» Modelling Sales of Products and Product Packs
» Designing Sales Promotion for Packed Products
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum