Skip to Content
author's profile photo Former Member
Former Member

#Multivalue Error

Hi,

How to Resolve #Multivalue Error in Webi Report.

Thanks In Advance

Regards,

Harsha

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 24, 2011 at 05:48 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2011 at 12:05 PM
    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().

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 04, 2014 at 10:47 AM

    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


    January.jpg (33.7 kB)
    Formula.jpg (44.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.