Can any please explain FOR EACH AND FOR ALL?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the dense rank?

679


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

544


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1557


Difference between b.o 5.1 and 6.1b?

653


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1891






Give some information on report bursting?

573


How to open a universe with out using the Designer ??

6619


what is xcelsius architecture?

3747


U r project in which stage in implementation?

1950


What is report template in b.o?

588


what will be the contents for a functional requirements specifications

1790


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

579


Explain about a tricky situation for which you found a very simple solution?

543


Can anybody tell me what are the tuning problems?

1592


What are the steps to be taken to schedule the report?

558