In Calculation Context, ForEach is used to include the dimension.
e.g. u want the Sales Revenue of every month by Year & Quarter, it will provides you with Sales Revenue for each month seperately. like
Q1
1 1000
2 1500
3 1200
Q2
4 2500
5 2678
6 1080
Q3
7 3000
8 2900
9 2670
ForAll is used to exclude the dimension used in it.
e.g. u want sales revenue of every month by Year and Quarter, it will provides u the same value of every month.
means for Q1 - for 1,2,3 month same Sales Revenue like
Q1
1 1000
2 1000
3 1000
Q2
4 2500
5 2500
6 2500
Q3
7 3000
8 3000
9 3000
i hope this will help u. |
