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 |
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
What Is Snow Flake Schema?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
can anybody tell me about issues faced while creating reports
How will you know the version of Bo using designer?
4 Answers Tavant Technologies,
Can i use personal database connection to the Webintellegence reports?
what is drill down?
What is mean by stored procedure ? and how we can generate stored procedure universe?
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
how many reports have u created ? explain a few.
1 Answers InfoStep, Ness Technologies, TCS,
Can Bo generates the Report from the cubical data Explain?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)