Multivalue and Syntax error

What is #multivalue and #syntax error in Business Objects

Questions by kusam_m

Showing Answers 1 - 18 of 18 Answers

chskumar

  • Jan 4th, 2008
 

#mutiplevalue: it occurs when ever u place one formula that returns morethan one value in a cell that output is one value only.....

  Was this answer useful?  Yes

avbaby

  • Jan 4th, 2008
 

each cell in a report can contail only one value. When more than one is returned by the query, then it gives multivalue error.

  Was this answer useful?  Yes

Multi value - This error is displayed when the Object/Variable fetches more than one rows for the selected Cell.

Soultion:Try creating a varialbe to select Distinct value of the Objects.If there are more than one distinct values, then insert the same as a new table.

If the error appears when you apply breaks, then try replacing the cell with the aggrigation of the above field.

Syntax Error - This is displayed when the selected column/cell is a calculated field, and calculation is based on a basic field which was not picked in the report layout.

Solution: To avoild Syntax Error, pull the basic fields into the report and then the fields which are based or calculated based on them.Finally, hide the unwanted fields.

Multivalue error will occur when more than one row comes for one cell. to avoid this issue you have to use Min(), or Max() as per your requirement.

Syntax error will occur when available improper formula used in the report.  so you have to correct it first.

  Was this answer useful?  Yes

avinash kumar

  • Feb 10th, 2013
 

I need full example of #multivalue error............how the errors r coming..............n how to solve that errors

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions