Data Views
Dataviews are the logical layer between database tables and templates. They can act as a data source to templates. There are two main purposes of using Data Views: Selection Pane and Analytical Reports.
This topic contains the following sections:
Access Data Views
Access Data Views by selecting the System icon from the menu.
Then, in the Data Services section, select Data Views:
The Data Views display, as shown below:
Select the Dataview ID to open and view or edit the dataview.
Data views usage in Selection Pane
In selection pane lists, use the data views in the script parameter to populate the list.
Create a list of values to be used in, for example, Selection Panes.
A Data View can be designed in a number of ways, enabling most types of lists to be created:
- Autogenerated
- Custom list using SQL
- Static list with fixed values
- Object Values list
Data views Usage in Analytical Reports
In Data Views for Analytics, the Data Source for Analytics reports are either Data Views based on SSAS analytical cubes, or ad-hoc based on standard SQL data view.
Data Views can act as a data source to Analytical Reports (Templates). Analytical reports can be based on a Microsoft Analysis Services (SSAS) multi-dimensional database, or a flat data source SQL statement. For more information, see Data Views for Analytics.
Data views Usage in Dashboard Designer
In Dasharea Settings, use the Data Views in data bindings in the right panel to fill your dasharea with data (from Bizview version 7.2).
Select a data view to get data into your dasharea:
Below is a list of Data View fields:
Field |
Description |
Example |
Note |
|---|---|---|---|
ID |
The unique ID for the Data View. |
SQL_LIST |
Keep short, no spaces, no strange characters, capital letters. |
Description |
The description of the Data View. |
SQL list all Users |
|
Information |
Additional information. |
||
[Type selection] |
Selection for type of Data View. |
Choose what type. |
|
Data source |
The data source to be used for the Data View. |
Bizview application database is default (no choice). Can be any Data Source defined in Bizview. |
|
[SQL / values / object] |
The SELECT, static list, or Object Values to fill the Data View. |
The GUI changes depending on the [Type selection] made earlier. |
|
List Preview |
Test and preview the Data View. |
Additional Information
To be able to use the Data View, you need to give access to the Clients(s) that should be able to use the Data View.
Select the Access icon from the menu.
Then, in the Access - Data Services section, select Data Views:
Select the Data View to view the clients that have access. The color next to the Client ID indicates whether that client has access, as shown below. Green indicates that client can access the Data View, whereas red indicates they do not have access. Utilize the check boxes in the Access column to make changes to client access.
Additionally, you can toggle the Access to ALL Clients by selecting ON or OFF.