Load Mode
Type
Constant String ('none', 'rollup', 'query')
Since
2.6.0
Description
This property determines how the included dimension will be aggregated inside the store. It accepts three different values: "rollup", "query" and "none" (the default value):
- _none_: The dimension will not be part of the store and store will be independent of this dimension.
- _rollup_: Only the dimension-mappings for the lowest levels and the special bindings for single keys will be queried from the database. After loading the facts from the lowest levels, they will be rolled up inside the dimension up to the root key.
- _query_: The system will create a sql-query for every combination of all mapped dimension levels and keys, execute it and load the result into the store. There is no aggregation or rollup performed by the system. If any level of the dimension is loaded, the root level will automatically also be loaded.
The 'rollup' is usually the fastest and performs much less queries on the database than the 'query' mode. However there are examples where you cannot use this mode. E.g. a fact using COUNT DISTINCT cannot be aggregated using rollup and you have to use the 'query' mode in this case.
Examples
Load Mode = "none"
Load Mode = "rollup"
Load Mode = "query"
