I'm currently designing the OLAP cube for my bachelor year major project. It is some how like as given below on the figure.
call_date includes date of the call and
call_time is of 86400 column include second of each day.
call_date has one to many relationship with
call_time, as there occur many calls in a day.
My professor said me to me that it is best design OLAP which give answer to all dimension question, like: What is the duration of call on day1?
My question is: Is it necessary to remove many-to-one relation on OLAP cubes? If so then what is the next step I have to perform in order to do so?
I'm not the best in describing the problem so if anything is unclear then please comment below.