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 |
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance
what is diff between Decode and case ? Give some Example?
what is the use of merge option in webi reports? explain with example?
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?
what do u mean by variable functions ?
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
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
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
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How to check for a particular value from one column with the list of values present in another column in Webi reports?