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 |
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are the traps ? What are the disadvantages of traps?
How many universe dfi you create if you have 2 years of experience in BO
any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
What type of schemas did you use in your project?Andwhy did you use that schema
Can anybody tell me the difference b/w canned and adhoc reporting?.
what is stacked chart , Bar chart, Column chart?
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that