In this video we will demonstrate how users can create a Data View in AVEVA™ Data Hub.
Additional learning resources will also be highlighted at the end of the video.
Before you start, confirm your Data Hub service has been deployed and is activated.
You will typically require editor access in data hub, from a user group with
the Tenant Contributor role.
You will also have explored and defined the data that you will add to your Data View.
Once these steps are completed, you are ready to start creating your Data View.
Creating a Data View is a recommended way to manage your data.
A Data View can help by combining your assets, meta-data and time series data...
into a single view that can be shared and consumed by other data tools,
such as Power BI or used via a REST API call.
It also helps provide operational data with context, so it's easier for data scientists
to get started on their work.
A Data View is also a recommended approach for efficient data collaboration.
In the example that follows, we have used Assets to help build our Data View.
However, be aware you can also use Streams in Data Views, if you choose to do so.
Be aware that data streams are the current method used to share data using
the Communities function in Data Hub.
It may be useful to know that a Data View can hold up to one hundred thousand data items.
Start by opening Data Hub using AVEVA Connect.
Explore the data you are planning to use.
Streams can be viewed in Data Management, in the Sequential Data Store.
Assets can be viewed in Visualization, using Asset Explorer.
Make use of the search panel, to filter if required.
Use the tabs to explore the details.
To create a new Data View, select 'Analytics' then 'Data views' from the side menu.
Select the ' Add Data View' button to proceed.
Start by giving your Data View a suitable name.
Name your Query if desired.
Select Streams or Assets, depending on your requirements.
Assets will be used for this example.
Enter your query, using available search terms.
The search helps us find the assets.
Review the results and select 'Save' to continue.
Enter a search for required fields in the text box, then make field selections, as shown.
Select relevant fields by ticking the check boxes.
Search and select additional fields, as required.
You can also search and select Metadata fields, as shown.
You can also add summary calculations, such as Average, Maximum or Minimum, as shown.
Use the checkbox to select.
The total number of selections is displayed on the 'Apply' button.
When you have completed your fields selection, press 'Apply' to proceed.
Review your Data View, by using the preview pane.
To change the column order, use the left hand pane to change field positions, as shown.
The example field 'Revenue Monthly Value' is selected and dragged to a new position.
The 'Refresh Preview' button is selected, to update the preview displayed.
The field is now displayed in the new position.
Please note the Data View Shape function.
The Narrow format can be selected for your view, if required, for use in another application.
Return to the Standard view shape, by selecting the other button and then Refresh.
The time range for the preview can be edited using the function, on the lower menu.
You can also specify these parameters whenever you query the Data View
using the API.
Let's change the start date, as an example.
You can also use the 'Now' button, to set the end time to your current time and date.
Select 'Apply' to save the change.
If a change to the grouping field is required, this can be peformed here.
This will also change the shape of your view.
The preview has been set to Auto Refresh. We recommend you leave this enabled.
If you wish to inspect the API Console for your view, use the 'View in API Console' link
on the top menu.
Details of the API call parameters can be inspected here and copied or edited if required.
The 'GET' button can be used to initiate the API query, if required.
When you have finished editing all aspects of your Data View,
select 'Save and Close' to finish.
Your new Data View has now been created.
For more information on Data Views, visit docs.aveva.com.
To help with navigation on docs.aveva, select 'AVEVA Data Hub' then open 'Analytics'
and then 'Data Views'.
A brief demonstration of navigating the site will follow, in the next section.
Visit the docs.aveva.com website.
Select 'AVEVA Data Hub'
Select ' Analytics'.
and now - select 'Data Views'
Select the appropriate section, as required.
This completes our video for creating a Data View, in AVEVA™ Data Hub.