A question about re-computing the value of attribute

, ,
1

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.

2

Hi Vince,

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

Tony

3

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