On this page, it is assumed that the initialset-up of data loads by Professional Services has been completed.
Scheduled extraction
After completing the aforementioned process, all scheduled jobs are run automatically using Windows Scheduler. More information about this tool can be found here.
Manual extraction
Besides the scheduled runs, it is possible to run manual extractions. They can also be triggered in Windows Scheduler:
...
After selecting the desired job, you can ‘run’ the item in the right bottom panel of the screen, as shown in the screenshot above.
Configuring data loads
In order to reconfigure the dimension members for the data load, the related .Lvparam file needs to be edited. More info about this below. After saving the file (please do not change the name of the file), windows scheduler will automatically use the updated configuration.
Parameter files (.lvparam files)
Each job comes with it’s own parameter file from which it reads parameter values and extracts metadata and data based on it. By default, there are three such files:
Script | Parameter file | Parameters |
|---|---|---|
MetadataExtraction.ps1 | MetadataExtractionParameters.lvparam | SOURCE_NAME |
DataExtraction.ps1 | DataExtractionParameters.lvparam | SOURCE_NAME, YEARS, SCENARIOS, PERIODS (optional) |
FullExtraction.ps | FullExtractionParameters.lvparam | SOURCE_NAME, YEARS, SCENARIOS |
They can contain the following parameters
SOURCE_NAME - name of the source from which metadata or data is extracted
YEARS - one or more years that are comma separated and specify years for which data is extracted
SCENARIOS - one or more scenarios that are comma separated and specifies which scenarios are extracted
PERIODS(optional) - only applicable for DataExtraction.ps1 script which specifies periods which want to be extracted for the years, can be Q1-Q1 or months from 1-12
To run a job, its parameter file needs to have the appropriate configuration using comma separated values.
Example with periods in the file:
...
If extraction isn’t needed to be executed with periods file can be edited like this:
...