How to: Vena's Versioning Feature

arana2 commented 4 years ago

Steps to use Vena's Versioning Feature

arana2 commented 4 years ago

Vena's Versioning Feature (To be added to McMaster's Administrator Guide) https://support.venasolutions.com/hc/en-us/articles/208259193-How-To-Copying-data-in-bulk-with-Versioning

Versioning is a versatile feature that allows you to copy data from one portion of your database and write it to another portion
In order to complete the steps outlined on this page, you will need at least Modeler access

The following steps will guide you on how to execute a bulk data move from one member to another This example will be to move data between two archived programs

Log in into Vena and click on Modeler, then click on the Versioning tab
Select Scenario
Expand on ArchivedProgram
Select the source program and then press the "-->" button under the Copy From section a. This indicates where the data will be copied from
Select the destination program and then press the "-->" button under the Copy To section a. This indicates where the data will be copied to
Leave the Page(s) field blank a. This ensures all data for all selected dimensions in the data model will be copied
Select "No"
Select "Yes, make separate copies"
Select "Yes"
Select "Yes"
Select "Run"
Go to ETL History to ensure the job is complete