how to solve #multivalue, #syntax, #error. iwant complete
solution process in practical wise?



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

Post New Answer

More Business Objects Interview Questions

how did u give developed universe to ur client?

1 Answers  


solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  


HOw do u migrate from old version to the new version?

1 Answers   AOL,


what is difference between Rich client web intelligence and Boxir2 web intelligence

3 Answers   TCS,


what are the disadvantages of alias?

6 Answers   Patni,






Explain the difference between compatible and incompatible objects?

0 Answers  


Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  


what is drill down?

5 Answers   TCS,


How can we use multiple data providers in a single report in business objects?

2 Answers  


WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  


when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers   BMC, TCS,


Can we create universe with no cache??

1 Answers  


Categories