#multivalue Error In Boxi
Contents |
is not set at the universe level to automatically how to fix multi value error in webi aggregate, the MULTIVALUE error will appear. There are a few options to address this: Use measure objects that are named "SUM", if they exist - e.g., SUM how to resolve #multivalue business objects 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. Create your own variable to sum the measure within the table (you'll need to do this in all tables in the report, though). Within the Format Table box under General, check the box "Avoid duplicate rows aggregation". Note that this feature only exists for tables, and not crosstabs.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business
Avoid Duplicate Row Aggregation Business Objects
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation webi foreach multivalue Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like
Business Objects #multivalue Measure
you, helping each other. Join them; it only takes a minute: Sign up Web Intelligence report error. #MULTIVALUE error up vote 1 down vote favorite I've run into an issue with the WEBI report I am making. Here http://www.upenn.edu/computing/da/bo/webi/qna/webi_multivalueWarning.html is the code in question: =If([Group Change Task Status Desc] = "Open") Then([Count of GCT]) ElseIf([Group Change Task Status Desc] = "Complete" And [SH Open Date Actual Dt] >= [Current Date - 60] And [SH Open Date Actual Dt] <= [Current Date]) Then([Count of GCT]) This is very basic and straight forward code. Count the O's and count the C's when they fall between the two dates. This is the error I'm getting: Formula Evaluation http://stackoverflow.com/questions/28776577/web-intelligence-report-error-multivalue-error - Error in dataset values : #MULTIVALUE Check formula definition in this dataset context I've determined the error is because of this part of the code: And [SH Open Date Actual Dt] >= [Current Date - 60] And [SH Open Date Actual Dt] <= [Current Date] I've tried it without this line and I get no errors. But the obvious problem is that I get too much data counted for the C's. I hope I provided enough info. Like I said, its pretty straight forward code. But this is my first time using WEBI and I need more experienced eyes on it. sap business-objects multivalue share|improve this question asked Feb 28 '15 at 0:23 woods 801818 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote The #MULTIVALUE error means, given the context (dimensions) in your block, the formula in your variable is returning two or more figures, and WebI does not know how to aggregate them (assuming that the variable you've created is a measure). You'll notice that if you add more dimensions to your block, such as [Group Change Task Status Desc], [Current Date - 60] and [SH Open Date Actual Dt], the #MULTIVALUE error eventually disappears and the figures will appear instead. You can try to solve this by manually specifying the aggregation to be used (e.g.
2011 by Ron Keler When you create variables in web intelligence, they must be assigned a qualification. This qualification assigns a "strong" type of either a measure, or a dimension (or http://bihappyblog.com/2011/11/13/using-webi-new-foreach-function-to-solve-complex-aggregation-problems/ a detail) kind of object to your variable. This strong tying has a profound impact on how webi handles aggregation of values in the variable you create, and can be the cause of many headaches for report developers trying to handle complex reporting requirements. The following example uses the e-Fashion universe for illustration purposes: Imagine you need to produce a report that business objects contains a reporting year in column one. Column 2 should display the revenue for the year in prior year, and a revenue state for the current year, and the revenue by state in the third column, for the current year only. Seems fairly simple, right. You can create a fairly simple variable in webi to satisfy the condition for column 2: If([Year]="2006″;[State];[Sales value error in revenue]) (If the year is 2006, the current year, display the State, else, display the revenue). Your variable will have to have a qualification, and will default to a dimension most likely. When you place your variable in the report, you will see a result far from what you were looking for: What is happening is that webi is treating the variable value as a dimension and is not aggregating it across the states for the prior years. So even though the states are not displayed, we still get multiple rows for the years, as if the states were included in the calculation context. Try to change the variable qualification to a measure, and you get the flip side of the problem: now you get the infamous #MULTIVALUE error because webi is treating the list of States like a measure and is unable to aggregate multiple States per Year. What can you do? Using the ForEach webi function, you can enforce the proper calculation context for each part of your variable and "loosen" the tight typing of your variable due to its qualification: If([Year]="2
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 02 Oct 2016 09:21:43 GMT by s_hv997 (squid/3.5.20)