New DTS Tasks in XP3 version 5.1 SR-1
Top :
| Article ID: |
 |
000092 |
| Rating: |
 |
5.0 / 5.0 (1 votes)
|
| Views: |
 |
1680 |
|
Problem:
New DTS Tasks in XP3 version 5.1 SR-1
Solution:
Untitled
- Cube partition maintenance - Creates new partitions and refreshes and removes existing cube partitions.
- Dimension members segmentation - Creates dimension members segmentation, based on regular expressions applied on dimension member names.
- Load configuration and setup - Loads global variables configuration from Excel worksheet. The first row defines global variable names. If a name starts with '_', it is ignored and not included as global variable. The rest of the rows define global variables configurations. First column is reserved for description of configuration.
- Get range of periods - Gets a range of periods selection from an XP3 data source.
- Shifting time segmentation - Performs predefined shifting time segmentation, based on period position in time. If segmentation is not defined, it is not performed. There are three parameters for segmentation: segment name, current period value, previous period value. They are separated with ParameterDelimiter. The values can reference groups from the regular expression (DateMatch) matching the dimension member period name, using following syntax {0}, {1} … for group 1, 2, etc.
- Value manipulation - Allows manipulation of XP3 array and XP3 dictionary.
For more information click on the following link:
New DTS tasks in XP3 v5_1_1.
|