Skip navigation.
spilling the beans
sharing and organising free knowledge for BI implementations with a focus on IBM Cognos TM1.

Excel/Perspectives Tips

| |

. 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:
F9 to manually refresh all the open workbooks
Shift F9 to refresh only the current worksheet
F2 enter (edit cell) to refresh only 1 cell

In TM1 9.4.1, the spreadsheets will recalculate automatically when opening a workbook, or changing a SUBNM despite automatic calc is disabled.
From the Excel top menu, click Insert->Name->Define
.In the Define Name dialog box, input TM1REBUILDOPTION
.Set the value in the Refers to box to 0 and click OK.

. avoid multiple dynamic slices on several sheets in a workbook if you can, otherwise Excel becomes quite unstable and some references might get messed up
. if you are getting the e10) data directory not found error when loading Perspectives, you need to define the data directory of your local server even if you cannot run one.
Go to Files->Options and enter a valid folder in the Data Directory box. if that box is greyed out then you need to edit manually the variable in your tm1p.ini stored on your PC.



realtime monitoring of your TM1 server, pretty much like the GNU top command.




dimension elements with a quote character (') require a double quote to be interpreted correctly by the rules engine
example: ['department's'] -> ['department''s']

TM1 9SP2 U4 released

TM1 9SP2 U4 was released yesterday.
It fixes the following issues:

When the following conditions were true, incorrect child values
were displayed when drilling down on a consolidation in a cube
ViewConsolidationOptimization is set to F in the server’s
Tm1s.cfg file
The VMT property for the cube is set to 0 in the
}CubeProperties control cube

Attempting to open a view that included an empty subset
sometimes caused a server crash.

When you selected a chore in the Server Explorer, the Chores
properties pane displayed member processes in alphabetical

Out of Memory


You will get the dreaded message "Out of Memory" if your TM1 server reaches beyond 2 GB of RAM.
On top of adding more RAM, you also need to add the /3GB flag in C:\boot.ini to extend the available space of the TM1 server from 2 to 3 GB, if you ever need more then you will have to look for a 64bit server.