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 |
Analysis in business objects?
how many times can use the union operator in a report?
What are the steps to be taken to schedule the report?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
How to import BIAR file in bo?
HOw do u migrate from old version to the new version?
Explain how many universes can be created in a project?
Explain how to execute the plsql procedure from the report by clicking with mouse?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
Difference between Decode and Case?