Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite
2

I'm currently designing the OLAP cube for my bachelor year major project. It is some how like as given below on the figure.

enter image description here

Here 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.

share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.