Periods of Cube Data Analysis
As a rule, the period of cube data and reports analysis is as follows:
- A short period (daily/weekly/monthly): the speed of such cubes calculation should be reduced by applying a filter to the period of the processed data.
- A fixed past period (last year/quarter/month, all data up to any date): such cubes can be calculated only once (each time the period changes, it must be calculated again).
Optimization Rules
Below are a few rules allowing to optimize the calculation of cubes:
...