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
Give some information on report bursting?
Explain about alerts in bos, under what situation we need to use alerts?
What would you consider as your biggest achievement and why?
Explain the difference between union and group?
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....
How to restrict password to a user while sending a document in .pdf format
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can we Save (save as) WEBI Doc as DESKI?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is difference between webi and infoview?
When we use aggregate awareness function in designer?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
How to open a universe with out using the Designer ??
Explain difference between zabo and webi?