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
How can you first report in Business Objects by using broadcast agent?
how many reports have u created ? explain a few.
How to generate the report from excel sheet?
Explain what three things do you consider to be the most important factors for a manager?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain what is the difference between slice and dice and cross tab report?
what will be the contents for a functional requirements specifications
How were the reports scheduled and how to resolve unexecuted documents?
What we need to discuss with designer before starting the universe designing.
Explain is there any other repository domains rather than universe, security, document?
What is difference between custom hierarchy and report based hierarchy?
8. How much supervision have you typically received in your previous job?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is the difference between slice and dice and cross tab report?