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
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to generate the report from excel sheet?
Explain is there any other repository domains rather than universe, security, document?
What Is Snow Flake Schema?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
8. How much supervision have you typically received in your previous job?
Difference between zabo and webi?
What sort of existing documents should business analysts refer to when starting on a new 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,
Is there any other repository domains rather than universe, security, document?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain about a task that really tested your analytical abilities?
What is the difference in creating filters in designer and business objects?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.