Saturday, June 11, 2016

#MULTIVALUE Error

In Operator is used to specify exactly which dimensions to include in a context. Other dimensions in the block are ignored. Adding / removing elements from the block does not impact this calculation unless a removed dimension was specified in the context. In that case a #MULTIVALUE error is displayed.

If there are multiple rows in a report with what appears to be the same data, and the measure being displayed is not set at the universe level to automatically aggregate, the MULTIVALUE error will appear.


  1. Use measure objects that are named "SUM", if they exist - e.g., SUM Actual Month (BAL) rather than Actual Month (BAL) in the FINQUERY Balances folder. This ensures that the balance amount will be properly aggregated based on the dimension objects selected in your query.
  2. Create your own variable to sum the measure within the table (you'll need to do this in all tables in the report, though).
  3. Within the table properties in InfoView or Webi, check the box to under Display to "Avoid duplicate rows aggregation". Note that this feature only exists for tables, and not crosstabs.
Note:Every measure object should be defined Aggregate function in select statement
Note:use Proper Calculation context syntax

Example:

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

3 comments:

  1. Thanks prasad, it worked for me.

    ReplyDelete
  2. Hello everyone on here my name is Fumo Sadiku living in Malindi City Kenyan I want to tell a little more about a good hearten man called Benjamin Breil Lee working with funding service as loan officer, Mr Benjamin Breil Lee helped me get a loan of 37,115,225.00 Shillings on my trying time trying to get back on my feet to raise my business I know there are some of you here who are in financial difficulties to talk to Mr Benjamin on what's app +1-989-394-3740 Or  also with his personal E-mail on Lfdsloans@outlook.com I'm so glad for what he did for me and for his Bank accountant as well Accountant Hernandez Lucas Thank you very much for your work well done.

    ReplyDelete
  3. I'm Абрам Александр a businessman who was able to revive his dying lumbering business through the help of a God sent lender known as Benjamin Lee the Loan Consultant. Am resident at Yekaterinburg Екатеринбург. Well are you trying to start a business, settle your debt, expand your existing one, need money to purchase supplies. Have you been having problem trying to secure a Good Credit Facility, I want you to know that Mr Benjamin will see you through. Is the right place for you to resolve all your financial problem because am a living testimony and i can't just keep this to myself when others are looking for a way to be financially lifted.. I want you all to contact this God sent lender using the details as stated in other to be a partaker of this great opportunity Email: 247officedept@gmail.com  Or  WhatsApp/Text +1-989-394-3740.

    ReplyDelete