I have a sales reporting system with incoming data like this
I am new to designing data cubes (for the pentaho BI suite) and when I was building the schema, everything was working fine until I wanted to define
date as a date dimension. The pentaho schema designer needs this to be a foreign key reference to a date dimension table in order to use it as a dimension.
My question is, why do I need a separate table? How would I structure it? how would I reference it in the fact table?