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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


How to handle date field with a null value in the fact table ?

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

How to handle date field with a null value in the fact table ? Empty How to handle date field with a null value in the fact table ?

Post  esreis Fri Jun 07, 2013 3:47 pm

I am developing a solution for the analysis of invoices.

My fact table is structured like this:

fact_invoice
----------------
SupplierKey
CustomerKey
.
. (other fields)
.
Price
EmissaoDatekey
CancelDateKey

My question is about how to treat the field CancelDateKey that also has null values​​.


esreis

Posts : 3
Join date : 2013-04-29

Back to top Go down

How to handle date field with a null value in the fact table ? Empty Re: How to handle date field with a null value in the fact table ?

Post  BoxesAndLines Fri Jun 07, 2013 6:21 pm

Treat it the same way as you would any other dimension, set to the default row value.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum