We are thinking about using OLAP for our project, therefore here is a question we need to answer: Can OLAP handle these requirements?
We need 3 dimensions (axis):
-Organisation (~300)
-Time1 (365 days)
-Time2 (24 Hours)
Questions:
1) Can a cell hold more data than one? For example can i save in orga A, Time1 B and Time2C the values a and b?
2) Is there no problem to have such a high number of categories on an axis (for example 365 days)?
3) If the answer for 2) is no. Is it also realistic to have 8760 (days * hours) on an axis? Hierarchy on this dimension is then: hours - days - weeks - months - year
Thanks for any help.
We need 3 dimensions (axis):
-Organisation (~300)
-Time1 (365 days)
-Time2 (24 Hours)
Questions:
1) Can a cell hold more data than one? For example can i save in orga A, Time1 B and Time2C the values a and b?
2) Is there no problem to have such a high number of categories on an axis (for example 365 days)?
3) If the answer for 2) is no. Is it also realistic to have 8760 (days * hours) on an axis? Hierarchy on this dimension is then: hours - days - weeks - months - year
Thanks for any help.