Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Which command using Query Analyzer will give you the version of SQL server and operating system ?

5057


How to generate the report from excel sheet?

1179


Explain is there any other repository domains rather than universe, security, document?

1092


What Is Snow Flake Schema?

1203


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?

2040


8. How much supervision have you typically received in your previous job?

2255


Difference between zabo and webi?

1106


What sort of existing documents should business analysts refer to when starting on a new project?

1010


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,

2042


Is there any other repository domains rather than universe, security, document?

1046


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1131


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2427


Explain about a task that really tested your analytical abilities?

1241


What is the difference in creating filters in designer and business objects?

1025


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3082