Applied dimensionality

Having problems with your dllhost.exe grabing a huge amount of RAM and going into winter sleep? A real hog he is, that dllhost.exe. CenterStone pointed on Cognoise, that COM+ memory leaking is an accepted Planning bug, and is resolved in 8.1.Well, I didn’t know that, so had to deal with this problem in 7.3 SP3. [...]

When loading Contributor data to Analyst via links, remeber to use DlinkExecuteList macro. It first creates a snapshot of application queried, and then runs all the links from this snapshots. And that is faster and guaranties data  coherence.  If you use a set of links and user inputs data between execution of them — results [...]

@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 [...]

How can one zero data in EP Contributor Application? By substracting it, using inner links, and allocation cubes. You need to zero those lines? Mark them in allocation cube and substract them from themself. Sign changing? Scale factoк -0,5, por favor.

Dlist formula comments( // markup) appear in Contributor as elem Annotations. Since there is no way of discovering formulas in Contributor (like F7 in Analyst), sometimes it’s better to duplicate dlist elem fomula commented and show this round-up way.

Elist should always be as high as possible in dimension order. Dimension rules apply to it as to subtotal dlist. Interesting effects can be reached by placing complex calculations after elist — they’ll work only on review level.

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.