TM1 Forum

I just ran into an error on Planning Analytics local 2.0.2 IF4: Unable to register view "<1>" in cube "<2>" I tried a few different things; in the end I believe the error was caused by the length of my view name. I was making the view name unique by appending parameters, which n...

Hi, i'm using this code to unwind a hierarchy (or parts from that). I always move the unwinded elmenets to a new parent called "trash". Then i'm always sure, that i don't lose any elements. ############################# sDim = 'MyDim'; sTopNode='MyTopNode'; sMDX ='{HIERARCHIZE({TM1DRILLDOW...

Hi Kenneth, i guess there is a "DimensionDeleteAllElements" used in the process, that caused the problem, while the account wasn't in your datascource. Maybe this will help in the future: I try to avoid "DimensionDeleteAllElements". In most times when rebuilding a structure, i le...

hi tsw,

the most TM1 enviroments i know, are PVU licensing for the server.

Regards,
orlando

Hello! I have a very old (around 12 to 14 year) planning environment, that uses a lot of VBA. The user connection is made via VBA (Perspectives I also loaded by a VBA Code) and works fine. The Excelsheets, that are used for planning, are very static and also created by VBA. So, in this old world eve...

Hi yy, of course. There is a TI-Process in each enviroment, that exports all users (and the groups they belong to) to an csv file. I import theses files to a cube in the admin enviroment. This cube contains three dimensions: the enviroments, the users and a measure dim. Via the measure dim i track w...

Hi YY, here the same. I'm working on an "Admin" environment. There I have all users (of all TM1 environments) and environments in dimensions. Via a cube I track which user uses which environment. In the near future I want this for the complete user management (add/del clients, change passw...