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


Please Help Members By Posting Answers For Below Questions

Can you please send me the migration related issues .

1743


Explain what are the measure objects?

641


any difficulitis have you phase while creating bo reports and how did u solve it

3076


Explain about alerts in bos, under what situation we need to use alerts?

643


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

791






What is the difference between slice and dice and cross tab report?

693


Explain how many universes can be created in a project?

721


how to create metric universe ?

1996


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....

1582


Explain about a tricky situation for which you found a very simple solution?

638


Give some information on report bursting?

647


is it possible to export the webi reports to crystal reports?with out using businessview?

1914


Explain is data mart?

680


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3936


Did you face any problems while creating reports? Name? Solutions?

3346