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 |
how to limit number of rows in a report in business objects using webi?
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)?
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
In a context can i get the data from two different factables by using the single data provider?
What is the degenerated Objects?
What is Indexing? how did u implement indexing?
In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
What is package in BO
Explain the difference between detect alias and detect context?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?