VoV Dataset Un-joined

Tony Coffman -

Trouble viewing images? Click on images to enlarge.

 

 

An Un-joined Dataset will return one Datatable for each Detail and/or Summary result from the selected Views.  Datasets are useful when you need to combine disparate views into a single data source for Finished Reports or Visualize.  Users often build a Dataset when they want to combine multiple Views into a single Excel workbook where each View is a separate spreadsheet.

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

mceclip1.png

1. VoV Build DataSet

First, select BuildDataSet from from the VoVOption property.

mceclip0.png

 

2. Add Views

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

 

3. Save and run VoV

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

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

 mceclip5.png

 

Example:

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

 

View4.vdm has the following report fields:
mceclip3.png

 

When VoV_Dataset.vdmv is executed, View1.vdm and View2.vdm are run against the defined connection, and the details from each View is added to their own datatable in the dataset.

View1 Results:

mceclip6.png

 

View4 Results:

mceclip7.png

 

 

 

Have more questions? Submit a request

Comments