Here i m not able get the All project revenue in each record to calculate percentage. You might try creating a couple of variables to address this. Comment by Satya July 2nd, 2012 at 10:17 am Hi Dave, I have a report which will display top five projects and their revenue percentage. Any help is appreciated. weblink
In which case, include all three in both data providers! However, calculation context can be specified by more than a set of dimension values. Note that this can be used to enter dates values too. Default Calculation Context Let's start with a simple example, using the infamous eFashion universe.
I have a variable that provides +/- variance. Thanks in advance. Meaning that all information is available in one data provider.
Comment by Dave Rathbun September 3rd, 2013 at 2:42 pm Marcus, the problem is probably related to the fact that your 0/1 indicator is only valid at the row level. Up next SAP BO WEBI Calculation Context - Duration: 1:15:33. Now you can be the reporting master, as well the universe master. Error 30270 Web Intelligence In fact, why haven't you got all five objects in one query???_________________Current version I'm using: 4.1 SP3 Next available for contract or consultancy work: October 4th 2016 ______________________________________ Note to clients:
Thanks Comment by Dave Rathbun May 25th, 2012 at 8:47 am As I said, it's not a calculation context issue, and therefore isn't really appropriate to address in comments on this #unavailable Error In Web Intelligence No of Beds per hospital ---------------------------------- ABC - 30 DEF - 20 GHI - 60 Can you please help? Thank you Comment by Dave Rathbun April 1st, 2010 at 9:40 am Hi, Mathew, I have more posts in "draft mode" on this subject. Comment by jgrodrigueza August 21st, 2012 at 12:30 pm Hi, I need some ideas to accomplish something.
Whereas I get % to be Count of each Status for Bay Area for the entire report or any filter I select which changes constantly. Common Errors In Webi Reports Any suggestions? Thanks. And I can't just add a filter to the report table because the this is part of a bigger report, so several other columns are involved (although this is the only
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 Reply JessysBlessings says: January 5, 2016 at 3:13 PM I'm (relatively new) to BO, but been struggling with this concept for a year. Webi #context Error The results? #datasync Error In Web Intelligence Reply Raj Namineni says: August 2, 2011 at 1:44 PM Michael, Good one.
The syntax for Calculation Context is as follows: =Aggregate Function([Measure] Input Context ) Output Context Notice that the Input Context is inside the aggregate function, and the Output Context is outside DecisionFirst 34,006 views 14:09 Loading more suggestions... That means I have to use another technique to generate the grand total. Then, try to add another column where you can compare revenue to the calc from column 2. Web Intelligence Multivalue Error
You were our instructor years ago, and you are still teaching. Thanks, Reddy Comment by Sandhya June 17th, 2011 at 1:16 am Hi Dave, Can you please explain in detail about the issue which poonam has posted "Comment by Poonam N April Reset context is used to determine when a running function starts over at zero. check over here I have two data providers, this because the data comes from distinct databases.
Thanks Comment by Vineet December 17th, 2014 at 4:23 am Hi Dave, I have a weird situation. #multivalue Error In Webi So, you can display Tagname (merged dimension), SampleValue (Query1), Date (Query1), BeginDate (Query2), and EndDate (Query 2), all in one block. Thanks Comment by Karen May 16th, 2012 at 8:44 am Hi Dave, I'm in desperate need of your expertise.
file Cons costs A 90 B 90 C 90 I hope this clearifies my question. Or is it a known bug? for a year now but with no formal training so I haven't learned the tricks. #overflow Error In Bo Just to let u know, when I used only rev in the formula ‘rev =1mill' then ‘1-100mill'..same Id is appearing in different categories(investigating this i found that the id has two
Thanks Comment by dee October 9th, 2012 at 11:52 pm Hi Dave, Please post the part II for calculation context, waiting eagerly to see it from you. Reply Claire says: June 10, 2016 at 11:18 AM Hopefully I can get some help with this… Referring to the example in the article where there is a table for the Reply Michael Welter says: August 24, 2015 at 10:36 AM I'm glad it helped. Thank you.
My formula work after 4-5 attempts ..🙂 . Goodness me. Comment by Dave Rathbun April 20th, 2010 at 10:43 pm Hi, this really isn't a context issue. Output context is used to determine the output scope of the formula.
Please try again later. Comment by Dave Rathbun April 15th, 2010 at 8:59 am Hi, and thanks for your question. Thanks for the post. I need the data into one report from four different universes which are at different grains/hierarchy..It would be great if your could post more details with examples about In ,For Each,For
Thanks for removing this known confusion for almost every webi develoer .😉 … Hatzz off..😀 Reply Jayesh says: December 9, 2013 at 11:23 PM Excellent post Michael.I had confusion since long Thanks.