Maintaining subsets on your server might be problematic. For example you wanted to delete an old subset that you found out to be incorrect and your server replied this:
This is not quite helpful, as it does not say which views are affected and need to be corrected.
section dedicated to documenting TM1 with different techniques and tools.
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
The Applications folder is great but limited to views and xls files, well not anymore.
The following explains how to make available just any file in your Applications folders.
1. create a file called myfile.blob in }Applications\ on your TM1 server
it should contain the following 3 lines:
ENTRYNAME=tutorial.pdf
ENTRYTYPE=blob
ENTRYREFERENCE=TM!:///blob/public/.\}Externals\tutorial.pdf
2. place your file, tutorial.pdf in this case, in }Externals or whatever path you defined in ENTRYREFERENCE
One day you might face or already faced the problem of too many licences being in use and as a result additional users cannot log in.
Also on a default setup, nothing stops users from opening several tm1web/perspectives sessions and reach the limit of licenses.
So in order to prevent that:
.open the cube }ClientProperties, change all users' MaximumPorts to 1
.in your tm1s.cfg add that line, it will timeout all idle connections after 1 hour:
IdleConnectionTimeOutSeconds = 3600
The following code will:
so you are just 1 click away from accessing your TM1 data :)
Replace the "\\path\to\tm1p.xla","server","user" and "password" strings to your own settings.
----THIS WORKBOOK------------------
Private Sub workbook_open()
TM1Top provides realtime monitoring of your TM1 server, pretty much like the GNU top command.
It is bundled with TM1 only from version 9.1. You might have to ask your support contact to get it or get Ben Hill's TM1Top below.
. Dump the files in a folder
. Edit tm1top.ini, replace myserver and myadminhost with your setup
Before running the following script you need to setup a chore with a TI process to execute that line in Prolog:
SaveDataAll;
/!\ Avoid using the SaveTime setting in tm1s.cfg as it could conflict with other chores/processes trying to run at the same time
here is the DOS backup script that you can schedule to backup your TM1 server