I've also considered using 2 different queries such that the cost is gathered on cons-level, but when using forcemerge() the cost of a consignment is only used for one file that You can't sum by "file" and use it to drive a calculation unless it's in the output block in some fashion. Thanks, Jus Comment by Dave Rathbun January 15th, 2010 at 12:26 pm One is for input, and the other is for output. Percentage is of a project revenue is calculated as project revenue/All projects revs.
In the case above I left it out for simplicity. Comment by Edwin June 29th, 2012 at 2:08 pm Data exaple: Error Margin: 0.03 X Y F 1.1 1.2 N 1.3 1.9 Y Comment by Edwin July 2nd, 2012 at 9:12 If I pull account no and balance into a separate report and apply a report filter for [Balance]<0 then I can see the negative balances against the accounts. I often enjoy bumping into your site whenever I'm googling along for some BO questions. http://www.forumtopics.com/busobj/viewtopic.php?t=82605&sid=18a57698e9d5adebea2ef634d6d5f3cb
After reading this I seemed to be using contexts well for most things but have hit a brick wall when using counts, in some circumstances. To calculate a contribution percentage I need to divide each individual value by the overall grand total. A dimension that participates on the Input context does not have to be present.
I have a Region- Location - Status - #of applications table in my report. I'm sure this is simple and I'm missing something, but I've tried every variation of calculation context to no avail. Reply from Fernando Sanchez | Mar 26, 2007 Popular White Paper On This Topic Top 5 Reasons ERP Installs Fail and What You Can Do About Them All Replies (4) Best Business Objects Rank Function I got the total for all customers for all fiscal periods.
Loading... #multivalue Error In Webi Eventually. file Cons costs A 15 B 90 C 45 What I get as output is the below block which is not what I need. http://businessintelligence.ittoolbox.com/groups/technical-functional/businessobjects-dev-l/context-errors-in-webi-1386187 As mentioned elsewhere, this blog isn't intended to be a source of personal support.
What is Data Foundation in Information Design Tool (IDT)? Webi Calculation Context If this were a typical spreadsheet I could reference the total value using a row/column address, but that doesn't work in Web Intelligence. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Comment by Shaohua Ye March 20th, 2013 at 7:14 pm Hi Dave, I keep reading your blog to find a solution for a data calculation/analysis problem.
Comment by Ingrid November 9th, 2010 at 10:48 am Hi Dave. http://www.dagira.com/2010/01/04/calculation-context-part-i-overview/ Link tanvi jain April 9, 2013, 4:35 am Since the shortcut join is not required to be included in any context then how should it be handled like if A->B->C---E is Common Errors In Webi Reports Designer will show up the name and joins for the candidate context Review the highlighted joins in respective context if you are ok with it click on add button. #overflow Error In Bo Comment by Dave Rathbun April 20th, 2010 at 10:43 pm Hi, this really isn't a context issue.
In particular using CountAll on a dimnesion object. I understand that Integra merged with Quoram but where can i find the materials. -Jus Comment by Dave Rathbun January 6th, 2010 at 5:33 pm Hi, Grantie, thanks for your comment. Imagine we're breaking down revenue by customers, but each customer could live in multiple states. Comment by Tej November 22nd, 2011 at 5:36 am Hi Dave, Eagerly waiting for your next post on this topic. Context Operators In Webi
I wanted to see sales$ at Division level not for each Market even though it is sectioned by Market. Webi Rank Function Example Extended Merge dimensions results when a table contains synchronized data. Fernando Sanchez replied Mar 26, 2007 Sounds like the columns that are used to join the various table in your context have different data types...check the data type and make sure
Always get an answer here:) Thanks again! The column I have this applied to has a filter on the first report and a different filter on the second report. I can alter which of those dimensions impact the calculation using one of the following three context operators. Thanks for your help.
Thank you, Poonam N. In order to do that, I need to know how to generate the grand total anywhere I want it. I suppose it's for backwards compatibility. Comment by Dave Rathbun July 27th, 2010 at 1:01 am Hi, Sunil, you don't have a context issue in your scenario.