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 |
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
what is static filter and dynamic filter
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
WHAT IS ROW LEVEL SECURITY IN BO?
what is meant by slowly changing dimensions?
what is xcelsius architecture?
Can we use unconnected lookup as dynamic lookup?
Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers
What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?
HOW TO INSTALL BOXI
what is diff between Decode and case ? Give some Example?