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
Can you please send me the migration related issues .
Explain what are the measure objects?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain about alerts in bos, under what situation we need to use alerts?
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?
Explain how many universes can be created in a project?
how to create metric universe ?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain about a tricky situation for which you found a very simple solution?
Give some information on report bursting?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain is data mart?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Did you face any problems while creating reports? Name? Solutions?