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 DO YOU SCHEDULE THE REPORTS?

5 Answers  


how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,


How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers  


What are the differences between webi and deski of XI R2 not the earlier versions

1 Answers  


1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers  






What is casual dimension?

4 Answers  


Explain difference between zabo and webi?

0 Answers  


Can i merge two dataproviders if they do not have common column?

3 Answers  


Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  


Hi any done business objects certification.i am expecting some help from them.

6 Answers  


Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

4 Answers   Infotech,


IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,


Categories