@AddLocalPreselection macro allows you to “slice” all cubes in macro on dlist selection. You can choose one month and all commands in macro will be applied only to this month slices. By setting up an input variable for this macro, you make choice dynamic. Macro starts, you choose month and them all commands are applied [...]
If you need loops in ep, iterative calculations — remember about Test(@Restart) macro. It check a cube slice for non-zero elements, and restarts macro execution if any is found. @Restart is an undocumented attribute of Test macro, usually used with SliceUpdate.
on DMR’s pros and cons
on DMR’s pros and cons on DMR’s pros and cons
on DMR’s pros and cons on Macro functions and prompts in Cognos BI reports