VALT
= 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 |
<VALTYPE ID> |
<VALTYPE ID> Available from Bizview 2011 (1.0901.1427) |
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).