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 |
What is difference between webi and infoview?
Where will you find the address of repository in Business Objects?
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
How to create Index to the table in the universe designer and how it improves the Query performence
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
What is report template in b.o?
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
When we go for OLAP , and When we go for OLTP for generating the reports ?
How will you move reports from Dev to QA in BO