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

I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,


what is diff between Decode and case ? Give some Example?

2 Answers  


what is the use of merge option in webi reports? explain with example?

2 Answers   TCS,


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

0 Answers   Banking, Genpact, TCS,


We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  






what do u mean by variable functions ?

2 Answers  


In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  


How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

1 Answers   IBM,


date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

0 Answers  


How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 Answers  


Categories