InterviewSolution
| 1. |
What Is Switching On And Off Of Aggregates? How Do We Do That? |
|
Answer» When we switch off an aggregate, it is not available to supply data to queries, but the data remains in the aggregate, so if REQUIRED, we can TURN it on and update the data, instead of re-aggregating all the data. However if we deactivate an aggregate, it is not available for reporting and also we lose the aggregated data. So when you ACTIVATE it, it starts the aggregation anew. To do this select the relevant aggregate and choose the Switch On/Off (red and green button). An aggregate that is SWITCHED off is marked in column Filled/Switched off with Grey Button. When we switch off an aggregate, it is not available to supply data to queries, but the data remains in the aggregate, so if required, we can turn it on and update the data, instead of re-aggregating all the data. However if we deactivate an aggregate, it is not available for reporting and also we lose the aggregated data. So when you activate it, it starts the aggregation anew. To do this select the relevant aggregate and choose the Switch On/Off (red and green button). An aggregate that is switched off is marked in column Filled/Switched off with Grey Button. |
|