I already wrote some notes on choosing dimension for publish in this post.
Today I just want to add some of points:
1 If you’re up to publishing some serious amount of data, variant with adding a dummy dlist with 1 item and using it as dimension for publish seems a very bad idea. You’re terribly slowing [...]
As I’ve promised, here are naming conventions I tend to follow in EP projects.
Setting up naming rules doesn’t seem so crucial at project start, but generally hits on you on the head on final phase, when development turns to support. And trying to support your colleagues model will leave you thinking about naming objects the [...]
Finally, we’ve solved problem stated in communities. And Robert allowed me to publish resulting library here as well. See attached zip file.
Problem statement
We have 2 cubes, one containing product groups sales (for example) and the other containing detailed product data. Users should be able to correct overall group totals and correct detailed product distribution.
If [...]
There are some situations when you definitely need some way of recognizing new input from user. These are rather rare occasions, but when it’s nice to have such a tool is sack.
One of the applications was discussed in this communities topic. By the way, I’m spending much time on communities these days (it’s a [...]
In the old times, before SliceUpdate first appeared ) we’ve thought that one thing analyst lacked to be really all-in-one tool was ability to do loops. For, while, until — all that nice stuff. And when SliceUpdate was introduced it became clear that @Test(Restart) allows you to cycle macro execution on whatever basis.
Using @Test(Restart) allowed [...]
In 8.2 we’ve got incremental publishing, allowing us to create real-time reporting on contributor data and that sets up new frontier in model data transfer speed. Now the slowest part of models are administration links (who’d guessed that when 7.3 appeared).
Here are some ideas of how to speed admin links up, using the same principle [...]
I’ve nicked the term “Multi-Line” model out from some cognos best practices presentations. Never known it was called that way )
Multi-Line is only way to go when you have a potentially huge dimension only a tiny bit of which should be available to end-user at a time. Like employee planning, whole dimension of 10k people, [...]
A common question of ep admins is: “How can I see all users currently logged into planning wrt applications they’re using?”
Something like: “Steve is now editing Capex and Sales Planning, and Mary is the only one in HR application now”.
The task relatively simple for 1 application (yet required view publish for version prior to 8.2, [...]
Just found an excellent option “Table-only Publish Post-GTP” that detects changes that make incremental publish incompatible and republishes application. It should be set to “Yes” by default, imho.
See how incremental publish can streamline your reporting in these posts: 1, 2.
I’d like to collect some scenarios of how Event Manager can leverage your Planning process, to recognize patterns later and be sure what to propose.It’s like a brain-storm, feel free to add your comments. And there it goes:
1 Automatic publishing of updated data - see here, and here2 Sending mail notifications of budgeting period closure [...]
Powered by FireStats