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 |
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
Can more than 1 metric be applied on an analytic in business objects?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
What is the use of Surrogate key in BO?
What is the difference between condition & filter?
What is broad cast agent?
is it possible to export the webi reports to crystal reports?with out using businessview?
I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
Explain what are the steps to be taken to schedule the report?