TM1 Forum

Thank you Qml. But I still am trying to figure out what options do I have in terms of Rules editor since advanced rules editor is no more available in Architect Last time I checked ARE was not officially supported, but still supplied with 10.2.2 and so you should be able to use it if you really nee...

And it has nothing to do with dimension order or any of the text because after I use DB button to create the formula, I modify the parameters to match exactly like what I copied and it works. TM1 doesn't care how you created the code as long as the code is correct. There must be something incorrect...

Architect/Perspectives is still the default modelling interface you should be using. There are a few newer functionalities that don't exist in A/P (dimension types, content folders, managing TM1 Applications etc) so if you use those you will need to use PM or PA. If code editing/formatting is import...

However, I realized the DB formula not working until I delete it and use the DB button to create the formula then modify the parameters. As such, I believe cube dependency is my issue. Cube dependency is not the cause of your issue. As stated above, the concept of cube dependencies exists for cache...

I think I know what happens: cube dependency. Cube dependency is not something that 'happens'. It is a relationship that is established by the TM1 server (automatically by rule analysis or manually through a TI function) so that the cache invalidation mechanism can work properly. I'm not sure how t...

Is there any way to improve the speed of building views apart from using faster CPU or increase core numbers? Impossible is nothing. There are probably still rule calculations there that you can optimise, utilising weighted consolidations instead etc. You can also look into optimising dimension ord...

There is also a config parameter that can help solve your problem, which is, as Alan pointed out, that the denominator is small, but not zero.

"Memory Used for Feeders" divided by "Number of Fed Cells" gives you the average memory used by a single feeder flag (in bytes). While I would not consider it to be one of the more important Cube Health Indicator Parameters (CHIPs :geek: ), it still does tell you something about ...

sorry but i dont understand why i should use Application.OnKey . Isn it that i need again a click or somthing and it is not calcualted automatic during add a new value for example ? You wrote this in your OP: What i need is similar to the automatic Recalc F9 Function. ...which I took to mean that y...

Hello can you give me an example how i can combine Application.OnKey with Application.Run, that i can paste it into my macro area from Excel Active Form ? I think you will benefit more if you try and do it yourself. You only need a few lines of code and with the hints from me and a bit of googling ...

You can use a bit of VBA to achieve that.

Combine Application.OnKey with Application.Run "TM1REFRESH".

Sorry the behaviour is not as you would expect it, but it is as intended. TI does not commit data changes immediately, but instead collects them in memory until the entire transaction (which might be a chain of TI processes) is done making changes and only then are they committed to the main model. ...

You have syntax issues there. The "first number" element returns the first character of the cost center: ['First number'] = NUMBR (SUBST (! ALL.D.CENTRO_CUSTO_UNIDADE, 1,1)); No, it doesn't. This would: ['First number'] = S: SUBST ( !ALL.D.CENTRO_CUSTO_UNIDADE, 1, 1 ); The second element b...

You've now 'protected' the password from admins in a way I can only liken to closing one's eyes in order to make things invisible.

Check out this thread for other ideas on how to do it better. Especially Brian and Paul made some good suggestions.

I was thinking of another solution, but I do not know if this is a good one and I wanted to share this idea with you. In the measure dimension I store the password using a string element. Do you know if there is a custom format to apply for this string element? I was thinking to apply a format that...

TI commits metadata changes only once - between Metadata and Data tabs. It does not do it at the end of Prolog and it's been that way since I can remember. It's easy to test. Put one DimensionElementInsert call in Prolog and one in Metadata. If you then add a ProcessQuit call anywhere before the Dat...

I have never seen log entries not being recorded either. However, in the case of a rollback you might see more Process "X" run messages in the log than Process "X": finished executing normally messages. But I don't suspect that has anything to do with your case and, if I understa...

Set up Windows Error Reporting to generate a full (type 2) crash dump next time a TM1 service crashes. This is something that will likely be requested by IBM if you open a service request anyway.

I had to manually update the configuration and certificates using the following guide: http://www-01.ibm.com/support/docview.wss?uid=swg21991545 So know the only option that i have now is to manually update all ExecuteCommand ? If you went with option #1 (updating v1 certificates manually) then you...

If you perform the steps from the second link ('How to Update Your Expiring TM1 SSL Certificates - Updater Kit') you should not need to make any changes to your tm1runti config or calls. The first link ('How to configure TM1 to use the bundled 2048-bit SSL certificate') presents another, alternative...