how to solve #multivalue, #syntax, #error. iwant complete
solution process in practical wise?
- 1 Answers
- 53800 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
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
Explain the difference between union and group?
What are the join problems comes appart from loop,chasm & fan Traps
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
how to create reports on screech?
How to restrict password to a user while sending a document in .pdf format
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the difference between slice and dice and cross tab report?
Explain what are the steps to be taken to schedule the report?
(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.
Explain what task is 98% of the required work of a business analyst?
what are the day to day activities of BO administrator ?
explain in detail about type 3?
U r project in which stage in implementation?
Explain about alerts in bos, under what situation we need to use alerts?
What Is The Difference Between Oltp And Olap?
