Forum Discussion
IN/OUT calcule
Hello, I want to calculat the IN and OUT of my stock for 1 week. I have already try that but it's more complicated than we think. For exemple I have this table: Article Name article Week...
They have week IN and date IN in my fact table I have modified this table to match with my problem. They have two temporal dimension in this table because I must have the Date IN for have the Week IN and the Date OUT for the Week OUT.
The Date IN column are link with my Date table but I don't know if it's good to link with this column ?
oh yes, it is much better than having to link via the week number. You always want to link at the lowest possible granularity level to avoid M:M relationships.
I have find a solution for my problem.