Can any please explain FOR EACH AND FOR ALL?
Answers were Sorted based on User's Feedback
Answer / ojas
Scenariao: We have multiple cities and their respective
Population in a perticular State and Nation.
FOR EACH:
This is used when we want the total population for each
State. Then it will be:
Sum(<Population>)For Each <State>
FOR ALL:
This is used when we want the total population that
includes all the states. Then it will be:
Sum(<Population>)For All <State>
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / nameer
For Each :
Used to add the dimension to the calculation context.
eg: sum([sales_revenue] For Each ([quarter])) IN ([year])
For All :
Used to remove the dimension from the calculation context.
eg: sum([sales_revenue] For All ([quarter])) IN ([year])
| Is This Answer Correct ? | 16 Yes | 1 No |
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
What are the steps to do to use alerts in bo?
Can we do the slice and dice in webintellegence?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
How to change the order of prompts in universe?
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
HOW DO YOU SCHEDULE THE REPORTS?
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.