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 DSS?? (Defination of DSS)
. In production reports, some dimensions are missing. how do you load these dimensions in production
What is the difference between the public object&schema object?
why we use aggregation in lower level
How to hide the table s in webi?can any one tell me plzzzzzzzz
Differences between business objects and web intelligence reports?
how to overcome overflow of data in a report
11.what are the features in BO?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance