how to solve #multivalue, #syntax, #error. iwant complete
solution process in practical wise?
Answer / 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 |
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
What is package in BO
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
how to restrict up to three levels in hierarchy when u do drill mode?
How can we use multiple data providers in a single report in business objects?
what is drill down?
Did you face any problems while creating reports? Name? Solutions?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
how to do Ad-hoc reporting ?
What is the link option in the reporting Environment?