mvm2002_2002

 Profile Answers by mvm2002_2002 

• Dec 7th, 2007

 

For each – The For Each context operator allows you to add dimensions to the current default input context. For example, if a table contains the dimension [year] and [Quarter] and the measure [revenue], the default context is [year]; [Quarter]. The For Each context operator is used to add [sales person] dimension to the context (without adding [sales person] to the table).
For All - The For Each context operator allows you to remove dimensions from the current default input context. For example, if a table contains the dimension [year], [Quarter] and [Sales Person] and the measure [revenue], the default context is [year]; [Quarter]; [Sales Person]. The For All context operator is used to remove [sales person] dimension from the context (without removing [sales person] from the table).


Thanks, Vani