VDM Release Notes Version 12.3.3.0

Release Date: November 20, 2023

Important Note: We highly recommend clients do not update directly to production environments without first testing in a demo environment.

What's New?

• The primary goal of this feature is to develop a View Level (.vdm) option that enables a user to do the following. (Feature 1561)
  1. Write the Detail and/or Summary grid's results to a Microsoft SQL database; one option for each grid.  
  2. Choose the connection profile to receive the data.
  1. Only MS SQL connection profiles are available in the combo box.
  3. Provide a Table Name for each the Detail and Summary grid.
  4. Options to Overwrite or Append to the MS SQL table.
  5. Added two additional columns to every write process:
  1. VDMImportDateTime - Date/Time Field: writes current system date/time.
  2. VDMReportFileName - Varchar(250) Field: writes the .vdm report file name.

  When enabled, each time the report is executed, the resulting grid level data would be written to the MS SQL database (includes grid level expressions).  

   

  This feature is unavailable/options disabled to all VoVs at this time.
   
  The option is available with the scheduler.  When "Data Storage" is selected via the Execution Wizard, it will behave identically to Insights throughout the Execution Wizard process.  Similarly, to how certain properties can be edited for an Execution inside the Execution's property grid, but not the Wizard, this "Data Storage" feature would allow the user to control:

  1. Connection Profile
  2. Detail and Summary Table Names
  3. Overwrite or Append

  Additionally, with this feature it writes the configuration to the .vdm report file, resets with other view options, and has appropriate logging including the following:

  1. Table Creation/Deletion/Append
  2. Records Counts
  3. Associate Connection Profiles
  4. Errors, Warnings, and Successes
   
  • Example View Data Storage - Data Warehouse 
    • Image1: Sample Table Created
      • 
    • Image2: Settings
      • 

Bug Fixes

This list includes all bugs resolved in version 12.3.3.0

Please refer to our severity ranking for information on the impact each bug could have.

Low - ■ - Bug may cause minor annoyances and most likely has a work around.
Medium - ■ - Bug may cause disruptions and may or may not have a work around.
High - ■ - Bug can or will cause significant disruptions to users. Important to update to resolve

VDM

• No new bug fixes.