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

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers  


Where will you find the address of repository in Business Objects?

4 Answers  


How many universes can be created in a project?

0 Answers  


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

0 Answers   TCS,


i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,






Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  


10.why we are going to data warehouse?

4 Answers   Satyam, TCS,


can i link two Universes having with different connection

3 Answers  


Can Bo generates the reports from cubical data ? Explain?

2 Answers   IBM,


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

0 Answers   BMC,


WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?

2 Answers   PCS,


What is top business?

0 Answers  


Categories