Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 Answers  


What is package in BO

0 Answers   Infosys, Saksoft,


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

0 Answers  


how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,


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

2 Answers  


what is drill down?

5 Answers   TCS,


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

0 Answers   IBM,


my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers  


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

0 Answers   HCL,


What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers   Wipro,


how to do Ad-hoc reporting ?

6 Answers   IBM,


What is the link option in the reporting Environment?

3 Answers  


Categories