Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Performing a full extraction (metadata +data)

  • Performing a metadata only extraction for a given source

  • Performing a data extraction for the given source and year/period/scenario slice

  • Running Longview Data and Metadata Extraction

Running extractions via Command Line Interface (CLI)

To perform a full extraction (metadata + data) for the given source and year/scenario slice:

...

Info
  • If the scenarios contain empty space in their member name, they need to be put in double quotes. Ex: .\CXO.Adapter.LongviewTidemark.Cli.exe metadata-extract source:longview-close years:17,18 periods:Jan,Feb scenarios:"Scenarios 001","Scenarios 002","Scenarios 003"

  • Metadata members should be split by commas and should not contain empty space between the comma and the member name.

Running

...

Extractions via Windows Scheduler

Pre-requisite:

Initial Source Metadata and Data Extraction has been completed by Professional Services.

...

After completing the 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.

Configuring Data Loads

To reconfigure the dimension members for the data load, the related. Lvparam file needs to be edited. After saving the file (do not change the name of the file), windows scheduler will automatically use the updated configuration.

...

  • 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 - 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.

...

If extraction isn’t needed to be executed with periods file can be edited like this:

...

Scheduled extraction

After completing the process above, scheduled jobs can be 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.