How to solve the following errors coming in report development?
1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects
are not compatible

Answers were Sorted based on User's Feedback



How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4...

Answer / jansi

Syntax error: As the name indicates, check the syntax of
the formula used.

Multivalue error: Use some aggregate functions such as Max
(), Min(), Sum(), etc... (but that mainly depends on the
requirement)

#Error: This can be solved by checking the formula. For
e.g. If one has a UserResponse function like this.
UserRepsonse("DP1","Enter a date") and if the date format
id mm/dd/yyyy, then the following formula will lead to
#Error.

ToDate(UserRepsonse("DP1","Enter a date"),"dd/mm/yyyy")

This can be solved by using "mm/dd/yyyy" instead
of "dd/mm/yyyy"

Computation error: This error occurs if we don't have a
required object in the block. Sometimes we don't want a
particular object to be visible. In that case, to avoid
computation error, just include that object in the block
and hide it.

Objects not compatible: In this case, try creating detail
objects and associate them with the necessary dimensions
and instead of placing the objects, place the newly created
detail objects.

Is This Answer Correct ?    6 Yes 2 No

How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4...

Answer / vidya

Multivalue Error: while connecting from dimension to fact
it should always be one-to-many only, if this logice is
handled improperly we may come across this error.

Objects are not compatible: This error occurs when
connecting more than one dataprovider,datatypes of both the
objects(dimensions) to be joined or linked to produce a
single report should be same.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

how to limit number of rows in a report in business objects using webi?

3 Answers   Cap Gemini, TCS,


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  


HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 Answers  


In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,


What is the degenerated Objects?

2 Answers  


What is Indexing? how did u implement indexing?

0 Answers   TCS,


In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,


rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?

1 Answers  


What is package in BO

0 Answers   Infosys, Saksoft,


Explain the difference between detect alias and detect context?

0 Answers  


Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,


What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers   Wipro,


Categories