VoV Dataset Joined

Tony Coffman -

Trouble viewing images? Click on images to enlarge.

 

A Joined Dataset will return a single result from the selected Views based on the defined linking relationship.  When the Views are joined together, the individual Views' results are imported into a local MS SQL database and then joined using the relationship defined during the VoV build process.

Joined Datasets require MDS is setup in your VDM installation.  For more information on setting up MDS, please review this article: https://support.bridgeworksllc.com/hc/en-us/articles/360020504692-MDS-Multiple-Data-Sources

 

To create a VoV DataSet joined click on the VoV Builder tab on the navigation bar. 

mceclip1.png

First, select BuildDataSet from from the VoVOption property.

BuildDataSet.png

 

Next, click on Add View to browse and select your View.  Repeat the Add View process for each View.

BuildDataSetAddViews.png

 

Next, establish a relationship between the Views.  To add a new join/link, select the key field from one View, drag and drop it the corresponding key field in the second View. VDM will ask what type of join you would like to establish; Equal (=) – Implicit, Equal (JOIN) –Explicit, Left, or Right. If you have more than two Views, repeat the task for each View.  

VoVLinked.png


Click Save on the Ribbon Bar to save your VoV Dataset Joined.

To run the VoV, click on View from the Navigation Bar.  Click Open, select the VoV and then click Run View to execute.

 

Example:

View1.vdm has the following report fields:
View1.png

 

View2.vdm has the following report fields:
View2.png

 

When VoV_Dataset_Linked.vdmv is executed, View1.vdm and View2.vdm are run against the defined connection, and the details from each View is added to the MDS database.  Next, a secondary query is constructed and executed automatically against the MDS database, producing a single result:
VoVLinkedResults.png

Have more questions? Submit a request

Comments