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
- 2 Answers
- 7369 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 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 to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Can Bo generates the Report from the cubical data Explain?
What is package in BO
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What we need to discuss with designer before starting the universe designing.
Explain what are the steps to do to use alerts in bo?
Difference between b.o 5.1 and 6.1b?
how to create reports on screech?
what are the day to day activities of BO administrator ?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What is the difference between condition & filter?
Explain about a task that really tested your analytical abilities?
Differences between business objects and web intelligence reports?
