TM1 Forum

Hi! You were pretty close, I put in bold what you didn't list, and underlined what isn't really necessary: C folder from bin64 N folder from bin64 ssl folder from bin64 gsk8cms_64.dll gsk8dbfl_64.dll gsk8iccs_64.dll gsk8kicc_64.dll gsk8km_64.dll gsk8ssl_64.dll gsk8valn_64.dll libibmcogeay32.dll log4...

I'm not sure why you would go to the trouble of shelling out with RunTI and logging on in a new thread as a full admin user when all that needs to be done for a process to run as full Admin rather than Data Admin is to right-click the process and select "security access" which then allows...

Since no client uses access I had to google if bat-scripts may be executed via access: http://bytes.com/topic/access/answers/452957-run-batch-file-microsoft-access (apparently yes) If you can indeed call bat-scripts (and this is applicable in your case), have a look at runti.exe http://www.tm1forum....

I'm not aware of a possibility to query the ODBC-datasource within a process, but I have workarounds a had to cope with In prolog: executeonce=1; In data, very first statement to be executed: IF(executeonce=1); #clear data here, variables are accessible #I called a zero-out process here, maybe it wo...

The range shouldn't matter because TM1 handles sparsity really well. Can't you define alternate consolidations in the existing Date dimension that you can use for your cube? E.g. if the current sub-divisions/ consolidations are based on weekly roll-ups, then there's nothing to stop you creating mon...

Second I tried with security but I did not meet the requirements. I'm no native speaker, so ' apologize if this is obvious to you: If you say "I don't meet the requirements" do you mean that you couldn't implement it or that cell-security is not what you need? If you need to disable rules...

Hello, 1: no, the user needs to be in a group that has read rights to the process associated with the action button. 2: I'm almost sure that in 9.1 and below the process started by a user still executed as administrator and only recently (when Data/Security Admin was used) certain process-functions ...

If you still have one - LMeyer_(a)_gmx,at (just to be on the save side '_(a)_' := '@'; ',' :='.' - I don't like bots grabbing my mail, at least not the stupid ones. I appreciate a good programmed bot, tough) I don't want to appear greedy - so I'll give you some German special characters in return. F...

Hi Matt, You are looking for CELLISUPDATEABLE(cube, d1, d2[, ...]) - it will return 0 if either the cell in question is rule calculated or not a leaf, otherwise 1. Unfortunately TI doesn't provide ISLEAF (which is available in rules), but you can check the level of each and every dimensions's elemen...

Thank you! So there is no reason why ['All Fish'] => ['Monkeys']; doesn't work but ['Cod'] => ['Monkeys']; ['Carp']=> ['Monkeys']; ['Tuna']=> [Monkeys'']; works? (There is no rule for C:'All Fish', but N:Cod, N:Carp and N:Tuna have heavy, but feedered, rules (therefore rules, which use a lookup cube...

Hello, Sadly The wiki-article (http://wiki.olapforums.com/index.php?title=TM1_Feeders) lacks advanced information. When I started three years ago, I was told, that I can feeed N=>C, must not feed C=>* I read in forums, that C=>C is possible, but not a very perfromant idea. In my model the only possi...

To answer your basic quesion - if you don't mind not using TM1Web (which can be good, since you wouldn't have to play around with stupid formats not being 1:1 from excel), you can use an Excel macro. SUBPICK would be your function :) When using the DBRA approach, you have to be careful not to have t...

Steve, Having the CubeViewer open and altering the dimensions would be a synchronization problem, since the client has a now outdated reference, thus the problem is not persistent. (Your problem was only for those users who had the CubeViewer open, and it would run fine when the client restarted, ri...

Herman, No, there is no explicit Default-View. If there was, at least I assume, deleting it would not have solved the problem - as mentioned I can take a working view (any view not having the Default-Subset of company dimension) and render the cubeviewer useless by selecting the company's Default-Vi...

Hello, This is the same problem as in this thread I recently started: http://forums.olapforums.com/viewtopic.php?f=3&t=1391 so the systems settings remain the same: Server & Client 9.1 SP3, Perspectives with Excel 2003 SP2, English language in both, Client & Server When a client double-c...

Thanks, that could come in handy for problems in the future, in this case it won't apply tough. The first described problem occurred on the machine (via mstsc) itself, the second one was limited to that very subset, some other could still be accessed and altered. A college of mine deleted the views ...

I think the problem is, that the TM1-Server is set up on English, whilst you client is Spanish. So your client assumes, that there is the system-generated, always available TODO subset - but the server has only the generic ALL subset. They just don't meet where expected ...

That was my first thought too - but a restart should not auto-repair subsets, eh? And if TM1 manged to have corrupt subsets in memory, everything is lost anyways, so that solution is not an option

Hello, Server & Client 9.1 SP3 , Perspectives with Excel 2003 SP2, language in sync Unfortunately I lost the screenshot of how the CubeViewer responds when opening a View directly from Server Explorer. What happens is, that the view pops up for a split second, then closes and is replaced by &quo...

Hey guys, this is meant to clarify my identity on the old Applix forum, not a real TM1 rule. /lol I'm sorry if I confused anyone... :lol: As you wrote it, it wouldn't have worked anyways... :) If I were sorry whenever I confuse someone, I would not be able to feel sorry anymore - so better be sorry...