_JobsParameters
The _JobsParameters table describes the element filters for partial fact loads. The filters determine where in the cube the data is loaded. The area of the cube defined here is cleared before the data is loaded.
This table describes _JobsParameters:
| Column | Type | Description |
|---|---|---|
| JobParameter | BigInteger | Identifies a set of element filters for a partial load. All parameter sets used in a partial load have the same JobParameter. |
| ParameterSet | Integer | Integer identifying the set of dimensions defining one filter for a load. All dimensions relating to one filter must have the same parameter set, but this can otherwise be arbitrary. |
| DimIdx | Integer | The index of the
dimension within the cube being restricted (to the list of elements in the
ParameterValue column). The index must be zero based. |
| ParameterValue | Text | Comma-separated
list of elements of the dimension whose index is DimIdx to which the loading is
restricted for the related job (linked through JobParameter). Element names containing commas must be enclosed either in single quotes or double quotes. Single quotes would be used to enclose element names containing double quotes and vice versa. Both single and double quotes cannot be used together in the same element name. (If this is done, the behavior of the process is undefined and will give unexpected results.) |
| Comment | Text | User defined comment. |
General information
The value of JobParameter is linked through the JobParameter column of the _Jobs table.
For this type of load to be allowed, _FactLoad.FactLoadType must be 2 which indicates a partial load. Where this is not 2, _Jobs.JobParameter must be NULL and no corresponding rows on _JobsParameters are allowed.
A set of dimensions defining a filter must have the same ParameterSet.
Dimensions of the cube omitted from a parameter set represent unfiltered dimensions. Facts in the cube relating to all elements of these dimensions are loaded. Omitting the dimension from a parameter set includes all elements in that dimension.
The set of parameters for one value of ParameterSet define one filter. These define the coordinates of the data to load through element names that are to be selected from the table. But what the OLAP does first is to clear a space in the OLAP database of any data occupying those coordinate positions. Moreover, the data to load need not necessarily fill the entire space cleared away. It need not fill any of it. So these parameters can be used as a means to delete data from the OLAP database by using an empty table with related _JobsParameter data defining the elements coordinates of the data to be cleared away. The space cleared away can be further restricted by fact load parameters.
An element job parameter could be qualified with the name of the
hierarchy it belongs to. If the element data in the fact table uses hierarchy names, so
must the matching job parameters. The two names are separated with a Tab character. The
hierarchy name appears first. For example, hierarchyName<tab>elementName.
You can include consolidated elements by prefixing the element name with a "B". The
elements are expanded in the processing to their base level descendants. For example,
March,B:'2nd Quarter',July expands to March,April,May,June,July.