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
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 |
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 |
Aliases and Contexts Which once will give the better performence when resolve the loops?
am a fresher hw to get real time experience?
what is the difference between Ranking and sort-out in bo?
Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
How do u Receive requiremnts from the client?
What is a loop? How can we overcome?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain about a time when you discovered a more efficient way to do a work task?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
what is the difference between bo and cognos?
what is difference between Rich client web intelligence and Boxir2 web intelligence
4.what is repository? types