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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain 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)?

544


Explain how many universes can be created in a project?

620


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1588


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3927


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691






Explain what are the steps to be taken to schedule the report?

639


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1001


Can Bo generates the Report from the cubical data Explain?

1628


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9882


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

818


Difference between zabo and webi?

638


8. How much supervision have you typically received in your previous job?

1836


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1491


What is a fantrap in business objects?

583