To each expert:
My example data is shown as follows:

<?xml version="1.0" encoding="BIG5"?>


??? Books
??? Stores
??? Time



??
??? Stores
??? Time



MS SQL???
??? Stores
??? Time




I use a XQuery syntax to update this data. I wonder the result is value of attribute @Value multiply a constant.

My XQuery syntax is shown as follows:
update
let $Revenue := input()/CubeFact[@CubeName=“Profit”]/Cell/Measure[@Name=“Revenue”]/@Value
let $temp := $Revenue * 35
do (
replace input()/CubeFact[@CubeName=“Profit”]/Cell/Measure[@Name=“Revenue”]
with )

No matter what I define the type of @Value as Integer or int or double or decimal, the Tamino Interactive Interfact always return the message like “<ino:message ino:returnvalue=“7763”>
<ino:messagetext ino:code=“INOXDE7763”>(cvc-datatype-valid) An invalid value has been found during validation</ino:messagetext>
ino:messagelineLine 0, Column 0: datatype validation for attribute “Value” of type xs:double failed:</ino:messageline>
</ino:message>”

Does anyone could help me to solve this problem.
Thank you very much.

Hi Vince,

Please provide the schema for test and tell me what Tamino version you are using.

Tony

Hi,

Value=“($temp)”
denotes the constant string ($temp)

If you want to refer to the contents of variable $temp, please write
Value=“{$temp}”

Regards

Harald