TM1 Forum

[img][/img]Holy Sh@t I just met Steve Rowe.

Check out the MaximumCubeLoadThreads parameter in the TM1s.cfg file. You're better off testing to find how many processors you should use than following the suggested "Number of Processors - 1".

It is better to test the new rules in a dev environment and only save the last tested rule in the productive environment when the system is not used very much. Really? Feeders persist for the entire length of time a server is "up"...and now with the persistent feeders option in 9.5 even l...

['amount']=N:DB('inve_Vol',!d_month,!d_year,!d_version,!inv_type,!inv_ca,'quantity') * DB('inv_rates',!d_month,!d_year,!d_version,'Unit Price'); Since this is simple multiplication, you can feed from either factor, using 'quantity' in the 'inve_Vol' cube or 'Unit Price' in the 'inv_rates' cube. som...

In my subset element insert statement, it saying the element does not exist, i have moved the DimensionElementComponentAdd('Version', 'Static Versions', Targetversion, 1); in front of the subset element insert statement, and tried to set some variables relating to Targetversion, but it still wont w...

When tweaking rules on cubes with heavy data and feeders, I like to strip off ALL the feeders until I get the rule calculation just right. Then when I get the rule they way I want it, I put the feeders back in.

I need to spread amounts equally over all detail items

Why not use the "Equal" or "Repeat" spread method?

The Equal Spread method distributes a specified value equally across the cells in a view.

The Repeat method repeats a specified value across cells in a view.

We have a select group of financial users that have access to all cost centers for financial reporting. As the cost center dimension is part of our 'payroll' cube, and even though those users don't have rights to the payroll cube, they are able to access all payroll cube data due to the cost center...

I believe that the only time a feeder will get triggered is if an action happens on the area in the left hand side of the feeder. Absolutely correct! When I used the term "sourced" I was referring to the left side of the feeder statement. :D As I said before, feeders sourced from a numeri...

Watch out for that ReevaluateConditionalFeeders=T parameter. I've seen it cause major problems when restarting your server (version 9.4). On that note, I've also spoken with the guys in TM1Engineering, and they believe that the parameter is incorrectly defined in the documentation. I've been told th...

Where has this been all of my life? I'm getting nauseous thinking about how many times I've had to jump through hoops to get rid of those quotes!!

Yes the errors in the log file disappear when I break the rule into multiple lines. The real story here is that I'm working on a process to loop through multiple rules files and find and replace a VERY long string (629 characters - using DOS and VBScript). My VBScript won't find and replace the stri...

I'm getting the following error message in my log file: TM1RuleImpl::LineGet - String overflow error, length = 649 Which tells me I have a line in my rules file that is too long. I did not receive any error messages when saving the rules file, but apparently there is a limit. Anyone know what the li...

I've seen the Evaluation Stack Overflow pop up when you have a circular reference.

Are you able to pull the cell in a cube view that you're referencing in the CellISUpdateable function? I bet when you try and pull that cell, it throws the same error in the log file...

Now Is it possible, using 3 lookup cubes for Dept, Job Code, and Earning, to modify the right hand side of the rule to check for three conditions (i.e Dept is an Occupancy Dept, Job Code is an Occupancy Job Code and Earning is an Occupancy Earning)? ['Contract Increase' ] =N:if(DB('Dept Lookup', !D...

Hello everyone! I guess I'm dreaming, but I could swear that I've been able to do this before, using STET would to avoid a circular reference... I'd like to be able to enter either hours or dollars and and have the other calculate...I've simplified the rules as an example below. Is there a way to do...

we've got EV, so i'd love to see your example!

Does anyone have an example of using ASP.NET / VB.NET to connect to TM1 9.1?

Thanks Bourne ; ) The full story is that I need to add an element to a dimension from an excel workbook published over <cough, mumble, whimper> TM1web </cough, mumble, whimper> . Each element added has a number of attributes associated with it that need to be specified when created. The available ch...

So...the documentation clearly states that we cannot use cell references within a SUBNM function...does anyone have any workarounds?