Planning Analytics Workspace (PAW) has some slightly UI annoyances that can be easily ironed out with some local javascript code.
For example, saving a process will generate a popup "process saved successfully" while hiding the "Run" button. So you are forced to wait that the popup disappears to be able to run that process, or aim for the tiny cross on that popup to close it, then aim again for the Run button.
Homemade TM1 reports can get quite convoluted and users might get a hard time updating them as it is difficult to tell where some TM1 formulas are pointing to.
The excel formula auditing toolbar can be useful in such situations.
Publishing users' view is still far from a quick and simple process in TM1.
First, the admin cannot see other users' views.
Second, users cannot publish their own views themselves.
So publishing views always require a direct intervention from the admin, well not anymore :)
1. create a process with the following code
in Advanced->Parameters Tab
Columns width
When you have a view with a lot of dimensions displayed, it happens that most of the screen estate is consumed by the dimensions columns and you find yourself scrolling a lot left and right to read the data points.
To ease that problem:
choose the shortest aliases for all dimensions from the subset editor
choose subset names as short as possible
uncheck the Options->Expand Row Header
. to reduce the probability of crashing your Excel, disable Automatic Calculation : Go to Tools->Options-> Calculation Tab then click on the Manual button
You can use:
To display consolidated elements below their children: View -> Expand Above
In order to get a faster response from the subset editor, disable the Properties Window:
View -> Properties Window
or click the "Display Properties Window" from the toolbar
to add one or more elements in an existing subset without recreating it:
from the subset editor
Tips for TM1 users: