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
When to use local filter and when to use global filter?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
U r project in which stage in implementation?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain is there any other repository domains rather than universe, security, document?
Can Bo generates the Report from the cubical data Explain?
What are the steps to be taken to schedule the report?
Explain when to use local filter and when to use global filter?
How were the reports scheduled and how to resolve unexecuted documents?
What is difference between custom hierarchy and report based hierarchy?
Explain the difference between union and group?
Is there any other repository domains rather than universe, security, document?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Can we configure two instances of CMS pointing to two different CMS system databases?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?