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
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)?
Explain how many universes can be created in a project?
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,
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??
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what are the steps to be taken to schedule the report?
(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.
Can Bo generates the Report from the cubical data Explain?
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?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Difference between zabo and webi?
8. How much supervision have you typically received in your previous job?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
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....
What is a fantrap in business objects?