Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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.

Selection Pane

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

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. For more information, see 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

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.

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).

Published:

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.

Selection Pane

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

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. For more information, see 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

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.

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).

For an optimal Community experience, Please view on Desktop
Powered by Zendesk