You need to create a strategy for implementing this process
Which set should you use?
You need to redesign the cube dimension to meet the requirements
Which relationship type should you choose?
Data is frequently queried at the day level and occasionally at the month level.
Which partitioning strategy should you choose?
You need to design an ETL process that meets the requirements
Which three actions should you perform in sequence?
What should you do?
You need to design a MOLAP cube that meets the requirements