For the managed package runtime, you must create a new version of a row-versioned calculation matrix before you upload new data from a .csv file.
This information is for Omnistudio for Managed Packages. For Omnistudio on standard runtime, see Omnistudio Help.
- Make sure the CSV is in good shape. Most importantly, make sure all the column headers in the .csv file are identical to the headers in the existing calculation matrix.
- On the calculation matrix you're updating, click the Related tab.
- Under Vlocity Calculation Matrix Versions, click New.
-
Enter the following information:
-
Name: Enter a name for this version of this calculation matrix.
TipChoose a name that makes it easy to understand the contents of this version of the calculation matrix. For example, CalcMatrix_ChangedRows12-24 or CalcMatrix_ChangedRowsForWesternStates2020.
-
Version Number: Enter a unique version number for this calculation matrix version. This version number does not relate to the row versions, but Vlocity needs it as a unique identifier for each matrix version uploaded.
-
Enabled: Select this checkbox to enable this version of the calculation matrix.
-
Start Date / Time: Enter the start date for the new and updated rows.
ImportantThe Date field is mandatory for row-versioned calculation matrices.
-
End Date / Time: Enter the end date for the new and updated rows.
TipIf you need to update rows with an end date that's not today, don't delete the rows. Instead, create a .csv file that includes only the rows you want to set an End Date for.
-
Priority: Enter a unique priority number that calculation procedures can use to prioritize which in which order to search calculation matrices.
NoteDon't enter anything into the End Date / Time fields unless you're updating rows specifically to give them an end date. In row-versioned calculation matrices, Vlocity sets end dates behind the scenes. If you enter specific end dates, you may get unpredictable results.
-
- Click Save.
- Click the name of the matrix version you just created.
- Click Upload CSV.
- Choose your new CSV file, then click Upload.
- Review the matrix.
- Click Save Data.