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
- 7256 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
Differences between business objects and web intelligence reports?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
what is document design in boxi,have u participate in that
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
When to use local filter and when to use global filter?
Which versions are used in the bo dashboard work?
How to restrict password to a user while sending a document in .pdf format
Can Bo generates the Report from the cubical data Explain?
How to open a universe with out using the Designer ??
What is the difference between user and versatile user?
What is top business?
What are the steps to be taken to schedule the report?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
