Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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:

  • No labels