I have customers that receive a given service for a current time. An exceprt of the fact table would be
I have a Time dimension. I'd like to know how should I design my cube, so for a given date I could know whcih service and which customers are concerned.Code:customer_id INT, service_id INT, start_date INT, end_date INT,
If I tight it to either start_date, or end_date it would give me the customer that have a start date being in the current selection, but not during.