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 |
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.
Where will you find the address of repository in Business Objects?
How many universes can be created in a project?
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 ?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
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
10.why we are going to data warehouse?
can i link two Universes having with different connection
Can Bo generates the reports from cubical data ? Explain?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
What is top business?