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

please anyone explain me the derived table with the problem tables.

1 Answers   CTC,


HOW TO INSTALL BOXI

1 Answers  


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

0 Answers  


CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,


Types of universes in business objects?

20 Answers   TCS,






If there is no common dimension? Is it possible to combine two different dataproviders?

7 Answers  


filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,


What are steps to be taken care to create a good Universe?

2 Answers  


What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,


What is Indexing? how did u implement indexing?

0 Answers   TCS,


what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,


suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,


Categories