TM1 Forum

After some inspiration (thanks Alan), I have put some code together that automatically archives user account folders from the TM1 data directory into a 'Archive' folder reducing the size of the server directory and eliminates the need to clean up the directory (which use to be my annual process). Th...

Thanks for the feedback guys, you both bring up some interesting points. I didn't mean that the default account management is useless but as Alan mentioned, if you are managing hundreds of users over multiple servers, it can get cumbersome. Our users ask for the rights they want (so it can be author...

Hi all, I noticed TM1 has a C++ api and was thinking of using visual studio to build a user administration application to manage accounts and access. TM1 doesn't offer any user friendly tools out of the box so i'm curious how others handle user accounts. Does anyone use one and if not how do you man...

It could be that you have lots of cubes or cubes with lots of dimenisons. I've upped the limits so give the new version ago:

https://www.dropbox.com/s/2zybi4gf9ciu2 ... audit.xlsm

The original plan was to use an external system but I wanted to see if it was possible to do the processing within TM1. SPSS would be nice but I don't think we can justify the investment at the moment. I will report back to my colleague with those options though, thanks!

Try adding a \ to the end of the path

Thanks for the comment Robin. A simple linear regression looks complicated to implement in TM1 let alone GMHD. Maybe we will leave trend prediction to the specialist tools in this case.

Hi Ram, give my chore scheduler a go. I have already mapped it to read the server chore files and display them in a spreadsheet:

http://www.tm1forum.com/viewtopic.php?f=21&t=8587

Has anyone integrated any kind of trend analysis/forecasting automation with a TM1 cube? I have had someone approach us wanting to use an external trend prection tool (Group method of data handling) to do their forecasting, much like this: http://www.gmdhshell.com/sites/default/files/images/screensh...

Did you receive a VB error when you click 'Run'? You might be prompted to enable macros when you open the worksheet Try these 5 steps: 1 - Save and open the worksheet in a location that has access to your server data directory 2 - Type in the server name as seen on server explorer in Column B (repla...

I developed it for our TM1 enterprise system so i'm not sure if it works with contributor sorry. If it has a data directory with cub, dim, rux and pro files then it should work though.

Hi all, this is a follow up post about the TM1 auditor that I put together earlier. It identifies the relationships between cubes, dimension, processes and rules to help identify impacted and redundent objects as well as document your server. I have added a front-end for multiple servers and integra...

Thanks for the suggestion Wim, I have updated the code with TABDIM and it works much better now: Sub Dim_to_Cube() ReDim strCubeArray(1 To 500) ReDim strDimArray(1 To 500, 1 To 50) ReDim StrCubesArray(1 To 500, 1 To 4, 1 To 500) Dim StrSorted() i = 1 Set FSO = CreateObject("Scripting.FileSystem...

Hi all, I have a bit of code here I would like to share and possibly get some help with. I have created an Excel VB-based dependency checker that shows which cubes are related to which processes and rules and another process which shows which dimensions are related to which cubes, processes and rule...