Multivalue Error In Webi Reports
Contents |
is not set at the universe level to automatically
Multi Value Error In Webi Crosstab Report
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 avoid duplicate row aggregation webi 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 Learn more about hiring business objects #multivalue measure developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Avoid Duplicate Row Aggregation Business Objects
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them;
Webi Sum Multi Value
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 is the code in question: =If([Group Change Task http://www.upenn.edu/computing/da/bo/webi/qna/webi_multivalueWarning.html 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 - Error in dataset values : #MULTIVALUE Check formula definition in this http://stackoverflow.com/questions/28776577/web-intelligence-report-error-multivalue-error 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. SUM). Thus, if your variable is called [Count C and O], you'd add SUM() to it, resulting in SUM([Count C and O]). There's also
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge http://businessintelligence.ittoolbox.com/groups/technical-functional/businessobjects-reportinganalysis-l/how-to-avoid-multivalue-error-796296 Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX VoIP_News Inside-ERP I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day error in Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Craig Borysowich Dennis Stevenson mircea_luca Richard DukeGanote iudithm Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk jakarman Adrian_Grigoriu knowscognosdoi COMPANIES GeoTrust Juniper Networks Silver Peak Sophos View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Business Objects error in webi Reporting & Analysis For discussion on Business Objects Reporting & Analysis , please visit the Business Objects group. More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. How to avoid #Multivalue error? wills asked Aug 5, 2005 | Replies (10) Hi all, Will any one tell me how to avoid #Multivalue error when replacing object in the report column? New column is added in our datab
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 20:46:18 GMT by s_nt6 (squid/3.5.20)