TM1 Forum

When this happens (TM1 ribbon loses descriptions and displays only icons) it is due to an error within tm1p.xla or tm1pRibbonX.xlam. When this happens it is likely that the buttons will not function correctly anyway so the best option is to restart Excel. I have experienced this from time to time bu...

You can programatically lock/unlock a cube with TI by writing to }CubeProperties As I am guessing you have discovered you can programatically lock an element by writing to the }ElementProperties_Dimension cube but you cannot programatically UNLOCK the same element once that element is locked since t...

I haven't had a good play with 9.5 Contributor yet but I principle I see no reason why you should have to navigate only to leaf elements to submit a forecast. The manager of product A or B should be able to navigate to that node and use data spreading (TM1's analogue to break-back) to change numbers...

Thus message is new to me.
Are you by chance on v9.5? Please refer to the request for assistance guidelines and include as much relevant information as possible to allow others to assist.

Hi Tutak, There are a few ways to do what you want to do. You can have 'YTD' be an N element in your month dimension and have a rule based approach that would look at a value in a system cube and then direct to the appropriate consolidation. Your rule might look something like ... ['YTD'] = N: DB('y...

If I understand correctly you have a string attribute 'Closed Date' in the Tickets dimension and you require a rule in your cube (which contains a date dimension) to check if the date matches the ticket's closed date and if so record a 1 against a count for tickets closed on that day .. Your rule sh...

2 questions for you - How long is the "feeder chain"? - When you save the rule file do you get any "stack overflow" messages in the server log file? Both these questions get at the same issue, namely that there is a limit to how many cells can be fed from a single cell. TM1's &qu...

This isn't a bug. It is quite well publicised that 9.4.1 FP1 and FP2 will only install over the 9.4.1 (MR1) full release and IBM support should have told you as much.

I should have been more specific. If cell security cubes are being used with PrivilegeGenerationOptimization then only fed cells in security cubes will be processed. This can dramatically shorten server load time, but it does mean all values must be correctly fed (if rule populated).

Feedstrings is probably essential to get right if you ever have any decent sized cube with cell security. But any 2D security cube is going to be dense by definition so there is nothing to gain from Skipcheck or Feedstrings. Feedstrings is often a little flaky and doesn't quite work as it should (in...

TM1 already provides its own on board ETL and scripting tool. Why would you not use Turbo Integrator to create the subsets and views (and set security for that matter)?

It would make your life a whole lot simpler!

I have used TM1ProcessExecute.exe extensively with 9.4.1 to trigger processes externally when a confirmation file arrives in the data source directory. There haven't been any stability issues as far as I'm aware. Haven't used the ChoreExecute exe though.

Yes this shouldn't be a problem. You can't exceed the number of named users purchased in total but any individual named user could have as many concurrent open sessions via whatever interface(s) took their fancy. A named user could have sessions to the TM1 server open via Excel, TM1 web, EV, Cockpit...

Not only is is it not possible, I can't see any earthly benefit in doing that. Because... ... you can create a dimension which is exactly the same in TM1. Days are the N level which consolidate to weeks at level 1, to months at level 2 or whatever. This of course brings us back to the auld discussi...

John, I'm baffled as to why you would expect any other result. The hardware hyperthreading just turns your 8 CPU box into a 16 CPU box. To use any more than one of these CPUs during server load you would need to set MaximumCubeLoadThreads to a value greater than 1. Your observations are not disappoi...

Another viable option would be to create a separate cube without any time dimensions and calculate the active customers in that cube. This might make the rules simpler for you. If you then want to drill back to your main cube and see when and how many transactions there are per customer that would b...

Hmmmm.... lotsaram wrote ['Contract Increase', 'Depts':'OCCUPANCY DEPTS', {'70200928U','70201028U','70205029U','70205530U','70453026U','70469026U','70469527U','70470030U'}, {'0380','0400','0420','0440','0460','0500','0560','0600','0660','0680','0700','0730','2750'}] Is this syntax new? I've never s...

Our IBM consultant prepared a demo for us and that was how he had the code written: with area definitions comprised of long lists of department numbers, job code numbers, and earning numbers etc. Don't assume that just because a consultant prepared your original rules that this means they are well ...

I posted something similar in the original thread but as to the usefulness of this as a feature. Let's have a think from the developer's perspective. ("Developer" in this context could mean IBM software engineer or TM1 developer ...) Subsets may be invisible to rules but rules are quite ob...

I would like to replace the following code in our Payroll Budget cube rule: ['Contract Increase', {'01.71.2752000','16.71.2100000','16.71.2756000','16.71.2758010', '16.71.2758020','16.71.2758040','16.71.2760100','16.71.2760200', '16.71.2760300','16.71.2760400','18.71.2750000'}, {'70200928U','702010...