Business Objects - Multivalue and Syntax error

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 214 of 242

Multivalue and Syntax error

What is #multivalue and #syntax error in Business Objects

Total Answers and Comments: 5

Last Update: September 24, 2008 Asked by: kusam_m

Sponsored Links

Best Rated Answer

—

Submitted by: Praveen Vaddadi

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.

Above answer was rated as good by the following members:
Sindhunarayana

January 04, 2008 10:35:52

chskumar

Member Since: December 2007 Contribution: 7

RE: Multivalue and Syntax error

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

Is this answer useful? Yes | No

January 04, 2008 10:37:49

avbaby

Member Since: January 2008 Contribution: 5

RE: Multivalue and Syntax error

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

Is this answer useful? Yes | No

February 01, 2008 18:39:55

Praveen Vaddadi

Member Since: January 2008 Contribution: 6

RE: Multivalue and Syntax error

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 13, 2008 05:26:11

neha1985

Member Since: February 2008 Contribution: 3

RE: Multivalue and Syntax error

When r trying to run mutiple valued mutiple objects in the section then you get multi value error.

Is this answer useful? Yes | No

September 24, 2008 06:42:47

ag_SRIDHAR_SUBRAMANI

Member Since: September 2008 Contribution: 2

RE: Multivalue and Syntax error

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.

Is this answer useful? Yes | No

Go To Top