cancel
Showing results for 
Search instead for 
Did you mean: 

#Multivalue Error

Former Member
0 Kudos

Hi,

How to Resolve #Multivalue Error in Webi Report.

Thanks In Advance

Regards,

Harsha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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...

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Avik,

better to open a new thread, this looks very old.

anyways can you please confirm your BOBJ version and exact patch.

Thanks,

Vivek

Former Member
0 Kudos

@vivek chauhan sent to you in mail

Former Member
0 Kudos
  1. 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().