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

Fact Design and best practices

2 posters

Go down

Fact Design and best practices Empty Fact Design and best practices

Post  sam119 Fri Oct 05, 2012 10:34 am

This is design question.

What if designing Order Line Items Fact.. However, not every order has line items.

Would you design Order Facts and Have line items as dimension?
or
Order Line Items Facts, but then what is the best practice to represent orders without line items?
or
would you create 2 separate facts which create another set of issues?

Thanks in advance.

sam119

Posts : 2
Join date : 2012-10-05

Back to top Go down

Fact Design and best practices Empty Re: Fact Design and best practices

Post  BoxesAndLines Fri Oct 05, 2012 2:17 pm

What's an order without a line item? It sounds like the business in an inconsistent state.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Fact Design and best practices Empty Design

Post  sam119 Fri Oct 05, 2012 2:49 pm

I used order as an example. It is transactions, not every transaction has line items.

Thanks.

sam119

Posts : 2
Join date : 2012-10-05

Back to top Go down

Fact Design and best practices Empty Re: Fact Design and best practices

Post  BoxesAndLines Fri Oct 05, 2012 4:00 pm

OK, got it. If one of the columns that defines the grain is optional, you can't build the fact at that level. In this case you would need two facts.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Fact Design and best practices Empty Re: Fact Design and best practices

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