on 03-23-2011 11:45 AM
Hi,
How to Resolve #Multivalue Error in Webi Report.
Thanks In Advance
Regards,
Harsha
Hi,
Take the value as a measure object and don't take dimension objects in to measures.
This will avoid the problem.
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.
#MULTIVALUE occurs when you place a formula that returns more than one
value in a cell that outputs one value only.
Example: Multivalue in a cell
You have a report showing Country, Resort and Revenue and you add a cell
to the report containing the formula [Revenue] ForEach ([Country]).
This cell returns #MULTIVALUE because Country has two values in the
report: u2018USu2019 and u2018Franceu2019.
One cell cannot display the revenues for both the US and France. Placed
outside the table, a cell containing revenue can only aggregate the revenues
All the best,
Madhu...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pallaharsha,
I am getting multivalue error in the month_year field in my report
Below to the month Year i have taken a label name A
Under that level I have created two more label called B & C
Now just below to B & C I have placed two formula's respectively formula
When I am selecting one month using prompt it is showing me the data correctly and month-year field is showing the current month but when I am selecting two months the data is getting populated in the formula field but giving multivalue error in month_year position
Can you please help out as I tried giving ForEach,Forall,In every operator I can use to solve this error
Please let me know if you need more details to understand this issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Multivalue occures only if you are getting more than 1 value in a result and inserting it into one single cell.
To avoids this jus add some aggregate function before it like sum() or avg().
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.