how to solve #multivalue, #syntax, #error. iwant complete
solution process in practical wise?
Answer Posted / narsi
practical wise:
#Multivalue :- this error will occur in 3ways
1) #multivalue in aggregation
2) #multivalue in breaks header or footer
3) #multivalue in section level.
1:-- the o/p context not include i/p context its situation
this error occurs.
Ex: in a report i have year,city dia's & Revenue measure is
there.
=<revenue> In <year>
The above condition will to run the query getting revenue
column #multivalue error occurs.
solution: cilck the formulabar in view menu
select the error containg cell, edit the formula to
write below condition.
= <revenue> In(<city>,<year>) In <year>
The above formula will run correct data will appear in the
report.
Note: the above condition by default it will take agg "sum"
function.
#syntax:--
the variable in the formula no longer exist in the
condition.
Ex:- <product price> * <quantity sold>
The above condition will run this error will occur.
Solution:- Click edit dataprovider--> new object will be
need --> select error cell --> edit formula --> click ok.
#error:--
the variable in the formula is incorrect. this
error will occur.
solution : go for data menu --> click variable
select the error containing a cell --> copy the formula in
edit menu --> paste it in new cell --> go for formula bar in
view menu --> --> take the first error containg cell
-->edit the formula --> repeat the above steps.
| Is This Answer Correct ? | 18 Yes | 20 No |
Post New Answer View All Answers
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what are the tables used in health care domain project and columns used in report?
What is aggregate table and aggregate fact table ... Any examples of both?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Explain what are the steps to do to use alerts in bo?
What is the difference between the public object&schema object?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how get the grand total in master-detail report?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
what is document design in boxi,have u participate in that
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What we need to discuss with designer before starting the universe designing.
Migration of Reports from business objects 5.1.5 to samee version in different hardware?