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
- 2 Answers
- 6732 Views
- I also Faced
- E-Mail Answers
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 what would you consider as your biggest achievement and why?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to execute the plsql procedure from the report by clicking with mouse?
What is a fantrap in business objects?
What is top business?
What is the difference in creating filters in designer and business objects?
what is document design in boxi,have u participate in that
Did you face any problems while creating reports? Name? Solutions?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what is xcelsius architecture?
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)?
How would you format some text using css to be verdana and bold?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain in detail about type 1?
Explain what is the difference between business requirement document and use case document.
