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 |
What is batch processing in Business Objects?
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
What is the difference between condition & filter?
What Is The Difference Between Oltp And Olap?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
what is static filter and dynamic filter
can u create report to connect oracle and sqlserver at a time?
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
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 DO YOU SCHEDULE THE REPORTS?
Differences between business objects and web intelligence reports?