Discuss the use of online analytic processing (OLAP) cube as a flexible way to obtain business insights. Choose two out of the following topics below and related your discussions to the business environment based on your own work experiences.
1. How to determine the granularity of an OLAP cube?
2. What are the factors that need to be considered in choosing facts and dimensions?
3. In addition to the date/time hierarchy, what are other hierarchies that might be useful?
4. In which circumstances do you think it necessary to reprocess the OLAP cube?