Data Views
There are two main purposes of using Data Views: Selection Pane and Analytical Reports.
Access Data Views by selecting System Administration > Data Services > Setup > Data Views.
The grid to the left lists all Data Views that are defined. Edit or define the Data View in the properties pane to the right.
This topic contains the following sections:
Selection Pane
Create a list of values to be used in, for example, Selection Panes.
A Data View can be designed in three ways, enabling most types of lists to be created:
- Custom list using SQL
- Static list with fixed values
- Object Values list
Analytical Reports
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. Data Views for Analytics.
Dashboard Designer
Select a data view to get data into your dasharea.
Below is a list of Data View fields:
Field | Description | Example | Note |
|---|---|---|---|
Data view 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 CLIENT(s) that should be able to use the Data View.
Begin by highlighting the Data View, then go to the Clients tab.
Select the Client(s) where the Data View should be available.
Usage
The Data View(s) created can be used in the following places in Bizview:
- Selection Pane Lists: Use Data Views in the Script parameter to populate the List.
- 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.
- Dasharea Settings: Use Data Views in data bindings in the right panel to fill your dasharea with data (from Bizview version 7.2).