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

VALT

 Optional parameter in PARAM= optional in PARAM sheet                                                                                                                        

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Value in col D (example)

Occurrance in PARAM sheet

Comment

FORMS

REPORT

VALT

Optional parameter in PARAM

Optional parameter in PARAM

<VALTYPE ID>

<VALTYPE ID>

Available from Bizview 2011 (1.0901.1427)
(for fetching values to the doc)

1

A valid value type ID. Need to be defined in PARAM or in template worksheet in row 1 or in column A. Can only be defined in one of these places.

VALT is a FORM specific parameter, which can be used either in PARAM or in the template worksheet (in row 1 or in column A). When updating values in the database, the data rows need to be tagged to a specific value type, in order to keep the updated data cells separated and not risk that already existing data would be updated with incorrect data. Value types could for example be AMOUNT, QUANTITY, or TIME. In new data engine the measure columns in which data is entered,  are usually  the value types so it is not required to use the VALT parameter anymore. For more information, see New Data Engine - VALT.

The parameter can also be used in REPORTS if data from the Bizview data table should be retrieved to the report. Then one specific value type maybe need to be specified in the PARAM sheet in order to get the correct numbers in the report, however that is only the case if data is registered in several different value types.

Any VALT value containing a - (hyphen) must be stated within { } in PARAM sheet, otherwise SQL will not treat this as a unique value and data will not be linked and saved with the value type value. A hyphen is treated as a interval in SQL smart.

Access the Value Type from the right panel in Template Design by selecting Parameters > Data Dimensions > Value Type:

In the Value Type field you can either directly add the value type ID you want to filter the data on, enter a formula, or you can use the buttons to the right to either select a specific value type from the Value Type drop-down.

The value you enter in the Value Type field in the right panel, will be written to the VALT  parameter in column C.

If the template contains several sections you can add specific value types for each section or define one for all sections. If you leave the Section drop-down empty the Value Type  will apply for all sections.

Retrieve/Update Values - Column C and D in PARAM

In a FORM, if only a value in column C in PARAM is defined for the VALT  parameter then that value will be used both when retrieving data to the form and when updating values to the database.

If you for some reason want to retrieve values for a different set of value types compared to the VALT value you want to be updated, then you need to define those retrieve value(s) manually in column D in PARAM sheet. If several value type values should be retrieved then these value type  values need to be separated with # in column D in PARAM, i.e. VALT1#VALT2

REPORT templates only support values in column C in PARAM (column D in PARAM should not be used).

Published:

VALT

 Optional parameter in PARAM= optional in PARAM sheet                                                                                                                        

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Value in col D (example)

Occurrance in PARAM sheet

Comment

FORMS

REPORT

VALT

Optional parameter in PARAM

Optional parameter in PARAM

<VALTYPE ID>

<VALTYPE ID>

Available from Bizview 2011 (1.0901.1427)
(for fetching values to the doc)

1

A valid value type ID. Need to be defined in PARAM or in template worksheet in row 1 or in column A. Can only be defined in one of these places.

VALT is a FORM specific parameter, which can be used either in PARAM or in the template worksheet (in row 1 or in column A). When updating values in the database, the data rows need to be tagged to a specific value type, in order to keep the updated data cells separated and not risk that already existing data would be updated with incorrect data. Value types could for example be AMOUNT, QUANTITY, or TIME. In new data engine the measure columns in which data is entered,  are usually  the value types so it is not required to use the VALT parameter anymore. For more information, see New Data Engine - VALT.

The parameter can also be used in REPORTS if data from the Bizview data table should be retrieved to the report. Then one specific value type maybe need to be specified in the PARAM sheet in order to get the correct numbers in the report, however that is only the case if data is registered in several different value types.

Any VALT value containing a - (hyphen) must be stated within { } in PARAM sheet, otherwise SQL will not treat this as a unique value and data will not be linked and saved with the value type value. A hyphen is treated as a interval in SQL smart.

Access the Value Type from the right panel in Template Design by selecting Parameters > Data Dimensions > Value Type:

In the Value Type field you can either directly add the value type ID you want to filter the data on, enter a formula, or you can use the buttons to the right to either select a specific value type from the Value Type drop-down.

The value you enter in the Value Type field in the right panel, will be written to the VALT  parameter in column C.

If the template contains several sections you can add specific value types for each section or define one for all sections. If you leave the Section drop-down empty the Value Type  will apply for all sections.

Retrieve/Update Values - Column C and D in PARAM

In a FORM, if only a value in column C in PARAM is defined for the VALT  parameter then that value will be used both when retrieving data to the form and when updating values to the database.

If you for some reason want to retrieve values for a different set of value types compared to the VALT value you want to be updated, then you need to define those retrieve value(s) manually in column D in PARAM sheet. If several value type values should be retrieved then these value type  values need to be separated with # in column D in PARAM, i.e. VALT1#VALT2

REPORT templates only support values in column C in PARAM (column D in PARAM should not be used).

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