Can I have a fact table for a descriptive attribute ?
I mean the fact I want to analyse is not a measurable quantity but is a detail.
For example let's say I have subject 'SALES EFFORT ANALYSYS'.
I have tables Customer, Order ...........
Let's say I don't have any numerical in order but just an order details for example
Order Number, date, branch of customer and many other descriptive attributes for
the order.
Further more this order table have a many other child table like (Just few are described below)
1. Ordered_Items which will have order_number and ordered_Items
(For one order there could ne 50 items)
2. Order_Discussions Which has Order_number, Discussions_date, Discussion_Comment
(May have 25 discussion record for a single order)
My question is how to put this in a dimensional model.
1. Can I make dimension as CUSTOMER
and fact ORDER but again one order has many child with different columns ???
2. Dimention and Fact list fact:
I heard about fact list tables where we only relate the dimention
Is it appopriate to make oder as a dimention How to handle the child tables of the order.
I mean the fact I want to analyse is not a measurable quantity but is a detail.
For example let's say I have subject 'SALES EFFORT ANALYSYS'.
I have tables Customer, Order ...........
Let's say I don't have any numerical in order but just an order details for example
Order Number, date, branch of customer and many other descriptive attributes for
the order.
Further more this order table have a many other child table like (Just few are described below)
1. Ordered_Items which will have order_number and ordered_Items
(For one order there could ne 50 items)
2. Order_Discussions Which has Order_number, Discussions_date, Discussion_Comment
(May have 25 discussion record for a single order)
My question is how to put this in a dimensional model.
1. Can I make dimension as CUSTOMER
and fact ORDER but again one order has many child with different columns ???
2. Dimention and Fact list fact:
I heard about fact list tables where we only relate the dimention
Is it appopriate to make oder as a dimention How to handle the child tables of the order.