data modeling - Dimensions without any link to the fact table -


i designing dimensional model there dimensions

orders, product, shipment, returns, items.

my goal calculate metrics @ day level , populate fact table.

the metrics count of orders per day, total gross sales per day, total net sales per day.

i have designed dimensions , problem facing how design fact table. need these 3 metrics, want fact table have below 4 fields in fact table have better performance.

but thing worried okay if leave dimensions isolated without connecting fact table?

please kindly advise me on this. appreciated. thank you.

if want calculate metrics - count of orders per day,total gross sales per day, total net sales per day. can directly transactional table.

if doing dimensional modelling fact table should have granular details, in case, should order line item. have link dimensions fact can perform aggregations @ different level , slicing/dicing on aggregated data show details.

now, if doing above , still want show metrics @ daily level count of orders , sum of gross/net sales can create aggregate table purpose. aggregate table if want pre-calculated, otherwise can perform aggregation on fact , result. in general, actual use case scenario might explain further.


Comments

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -