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 |
draw the architecture of bo
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
What is the use of BO SDK?
Explain what task is 98% of the required work of a business analyst?
how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?
explain in detail about type 3?
Explain in detail about type 1?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is the difference between the prompt and cascading prompt
Can anybody explain what mean by Database Delegated Measures?