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
What is the dense rank?
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)?
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?
Difference between b.o 5.1 and 6.1b?
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.
Give some information on report bursting?
How to open a universe with out using the Designer ??
what is xcelsius architecture?
U r project in which stage in implementation?
What is report template in b.o?
what will be the contents for a functional requirements specifications
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)?
Explain about a tricky situation for which you found a very simple solution?
Can anybody tell me what are the tuning problems?
What are the steps to be taken to schedule the report?