VALT (Col A)

        = mandatory in template or in PARAM (FORMS)

 = optional in Column A (REPORTS)                                                                                                                                        

VALT is a FORM specific parameter, which is mandatory either in column A, row 1 or in PARAM. 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 can, for example be AMOUNT, QUANTITY, or TIME.

The parameter can also be used in REPORTS if data from the Bizview data view (in which FORM data is updated) is used in the report. Then one specific value type maybe need to be specified 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.

Note:  

The column VALT or valtype_id is now deprecated since the value type is now the actual column. In older version you stored CVAL among with a VALT, i.e. cellvalue=123.33, VALT=AMOUNT. Now you store value 123.33 directly to the column AMOUNT.

What do you need to do?

Remove the VALT from column A and copy the VALT value for each column to row 1 where the column name is written.

Revision (2019-05-06):

Since a row can have different VALT with exactly the same criteria (in the original template, VALT was the only thing that differs between the columns), the new BizView had difficult to sort out which rows that had been changed. Say you have AMOUNT and QUANT in separate columns and only change the AMOUNT cell. Then BizView would delete the QUANT value also from the database since it matches the criteria for the AMOUNT. To solve this issue, we have added valtype_id in the dt-table. This column is automatically set with the correct value type and will be used as a dependency on the column. In other words, you don't need to worry about VALT or valtype_id but when you look in the dt-table you'll see it and of course you can use it in a where filter if you want.

Revision (2020-03-18)

As revision 2019-05-06 (above) automatically sets the VALT it takes the VALT from the actual measure name. This is OK in 99% of the time but you could have a case (i.e. CASE WHEN UNIT='10' THEN AMOUNT ELSE 0 END) as a column. In this case Bizview has trouble to get what VALT to use and in these circumstances, you'll need to help Bizview by entering VALT in column A or in PARAM.

Caution: VALT can only be defined in ONE place, either in column A (for each CVAL column), in row 1 (for each DATA row) or in PARAM.

Template Worksheet

If a template only contains one value type, then it is best to state VALT once in the PARAM sheet. However, VALT can also be stated in column A and defined for each CVAL column. If a template contains several value types for different CVAL columns, then VALT must be defined in column A.

If spread groups are used in the template, then only one value type can be defined within one SPGROUP. However, different value types can be stated in different spread groups.

The VALT row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).