Can any please explain FOR EACH AND FOR ALL?

Answers were Sorted based on User's Feedback



Can any please explain FOR EACH AND FOR ALL?..

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

Can any please explain FOR EACH AND FOR ALL?..

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

Post New Answer

More Business Objects Interview Questions

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  


What are the traps ? What are the disadvantages of traps?

5 Answers   Wipro,


How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,


any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....

2 Answers  


I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers   Rolta,






Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  


WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?

2 Answers  


What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...

1 Answers   TCS,


What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,


Can anybody tell me the difference b/w canned and adhoc reporting?.

5 Answers  


what is stacked chart , Bar chart, Column chart?

1 Answers   Tech Mahindra,


Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that

3 Answers   BirlaSoft,


Categories