TM1 Forum

I've used the same approach as listed in this thread however, I'm having some odd behavior. As and Admin and Data Admin running the TI locks or unlocks the version as expected. But running the TI as a member of a group that is not Admin or Data Admin causes the value in the element properties cube t...

Another alternative is using sell locking and protecting the sheet How does his restrict the input of negative values ? Ah, I stopped reading at restrict values... technically I suppose not being able to enter any value would include not being able to enter negative values, but not the intended out...

Another alternative is using sell locking and protecting the sheet. We use this a lot because it also works in TM1 web, unlike VBA alternatives.

I just tried this on a small model running 10.2.204. Didn't work for me either but it did use to work. Possibly this feature has been broken in the 10.2 release. Disappointing as it was a nice feature. A feature I guess that wasn't implemented that often in practice. Maybe there's something finicky...

At Vision there was talk of "smart caching". Preventing a single change in a cube from blowing out the cache for all the dependent cubes on unrelated calculations. I was kinda hoping we would see that in this release since we have a number of dynamic, driver based models, and its a bit si...

At Vision there was talk of "smart caching". Preventing a single change in a cube from blowing out the cache for all the dependent cubes on unrelated calculations. I was kinda hoping we would see that in this release since we have a number of dynamic, driver based models, and its a bit sil...

Hi JP, Thanks for the link! It has lot of useful functions listed. But actually I couldn't get any function from there to use for the requirement i stated below, I would need a subset which displays both leaf and consolidation of that leaf based on the filter on the leaf elements. Please let me kno...

Considering that DimensionElementInsertDriect does not cause a recompilation of dimensions then it's not exactly a surprise that there might be side effects like that. This behaviour is not documented, but I doubt IBM would accept it as a defect. I would consider best practice to avoid using Dimens...

I think I saw a problem where DimensionElementInsertDirect() is causing rules not to be applied to new elements. Check what happens if you run DimensionUpdateDirect() on that dimension - does it fix it without restarting the server? Success, this fixed the issue. Archive now has rules calculations ...

Hi Kamil,

I have not tried using that function. I'll give it a try and let you know if it works.

So I have a rather bizarre issue. I have an archival process for a model that creates a STET version of a budget or forecast. The process first creates a new element for the archive using DimensionElementInsertDirect in the Prolog. Then cycles through a control cube that lists all the cubes that sho...

I have been getting a weird error in TM1 web recently. Specifically, when a certain report is opened in Web, the report loads fine. But when I attempt to switch from the base to a sandbox I receive the following error: Lost connection to TM1 server. Please login again... This same error occurs when ...

Despite what you've been told in this thread setting DatasourceType = 'NULL' is actually a pretty common strategy to do on the Prolog tab if for some reason a data source validation test should fail. Essentially it sets the process at runtime to ignore the Metadata and Data tabs and proceed directl...

Why are you trying to set the datasource type? Perhaps a little more of the script may help to understand what you are trying to accomplish? Switching the datasource type from cube to 'none' has some implications on the variables. It might be better to check the existence of a cube and then execute...

I am trying to debug an issue in a process which was built by someone else. I am not very strong when it comes to writing TI's and the issue is occurring when the process attempts to set DataSourceType to null see below: DataSourceType = 'NULL'; ItemReject( sMessage ); This snippet is executed when ...

Agreed. I'm always amazed at how poor the UI is for a product that costs what it does.

... ['Element X'] = IF( ['Element A'] <> 0, ['Element B'], 0 ); ... Is it necessary for 'Element X' to evaluate to 0 if the condition is FALSE? Had you considered using STET instead? I realise that the rule presented is probably not a real-life example but the consultant's substitute code arrives a...

I don't care if it's faster or not. All it does is add confusion to the business purpose behind the rule and for that reason I'm out (with due respect to the Sharks :) ) Translation: I would never use it in a model. Agreed, assuming I had control over what goes into the models. I think it destroys ...

One of the consultants we work with loves using an alternate to an if statement. Where typically we might want to check if something is equal to 0. For instance where we might want to use: ['Element X'] = IF( ['Element A'] <> 0, ['Element B'], 0 ); The consultant will use: ['Element X'] = ABS( SIGN(...