TM1 Forum

I would say that this is expected behaviour. Even if you have set tm1s.cfg parameters to load sets and views, I would expect that opening views where TM1 needs to recalculate would increase memory usage (assuming no memory to recycle from garbage). If you are running processes, these would consume m...

Have a look at the reference guide for more on how to use StrToMember per Lotsa's suggestion.

The error typically indicates that another process has the file locked. Have you ruled out antivirus or other program locking the file to scan it? ProcessExplorer can assist in telling you what process is locking. Your service stuck in stopping state could be that it is just taking too long to shut ...

Been caught out before with a chore reporting failures each day. Running the process was fine though.
Turned out to be exactly this, old value retained from chore to chore each day.
After Initialising in the first process's Prolog, all smooth.

Here's another reference that may help: Using TM1 Web logging Edit: and another that looks useful Include user names and memory usage in TM1 Web logs The following information is included in logs: Timestamp Application and Active Form name Number of rows that were generated User name Current heap me...

I'll get the ball rolling... Let's ignore the organic growth in cubes, dimension etc. and how that would scale and factor into your answer. In recent months I think where we get pretty close to the edge sometimes in with chores. At some clients we have seen that the chores execute and memory grows t...

Looks like what I have used previously for testing.
I typically run these commands in Prolog (activate) and Epilog (deactivate) and have not seen any issues so far but saying that have not used these for over a year.

Have you looked at your PAX logs to see what it may be doing? Have you changed the Log Level to ALL to see more details? Have you checked for known issues that impact performance like cells with errors, including on hidden sheets, named ranges with errors, pointing to invalid addresses? Have you tri...

Another question - so if we are using CAM, they user will automatically get added when they first log in. So good news here. But what if you need to add/remove Tm1 groups? Sounds like you will still need to use architect, and cannot therefore completely ditch it for PAW? You can use TI to add the u...

Once you have done what David suggests, I think you will see an issue with your WHERE clause - looks to ultimately be saying WHERE PERIOD = X AND Y - cannot be both, maybe you meant BETWEEN. Also, a better approach for these kinds of expressions is to use Expand() e.g. sSQL = EXPAND('DELETE FROM &qu...

Another way is to use Debug utility 123 (all the usual exclusions and waivers apply when using undocumented features) Extracts a file with information about all cubes and dimensions So in short given the following: DebugUtility( 123, A, B, 'Model_Information_0_1.txt', '', '' ); A = 1 suppresses cont...

Lotsa's solution is far more elegant for what you are trying to achieve here.

Hi John, iirc, my connection in PAfE used the URI to the PASS server rather than the TM1 server and HTTPPortNumber.
The PASS "pass-through" was the missing link.

If you are building vi TI there are any number of ways to do this. Simplest is probably to add the elements to a string and scan the string. If you are about to add an element check if it is in your string i.e. previously added. If not add otherwise skip. You could also build an MDX string - add the...

... So which is wrong...Garbage or Cube..... If there is a process running, you would not see how much memory it is consuming with transactions in case it needs to roll back. And then don't forget that all the dims, sets etc. eat memory too - can still use the properties window in architect from th...

Noticed this parameter in the TM1S.CFG - may be worthwhile checking/reviewing. Default is True though. SaveFeedersOnRuleAttach When set to False, postpones writing to feeder files until SaveDataAll and CubeDataSave are called, instead of updating the files right after rules are changed and feeders a...

After deleting all rows below the TM1RPTROW, have you tried removing the named range referring to the DATARNG? This should be regenerated on rebuild.

Let's go with the random words option...

Cross-posting this topic here in case someone needs it. TL:DR Inserting the below function will allow you to append to a file when using AsciiOutput or TextOutput. Works across Prolog, Metadata, Data and Epliog as well as other TI processes: AsciiOutputOpen(<filename>,0|FILE_OPEN_APPEND|FILE_OPEN_SH...

The below script uses some undocumented functions to do the decryption. These are not recognized in PAW but save and just ignore the error or use Architect. Create a new process with a string parameter called pClient then add the following to the prolog section: IF(pClient@=''); pClient=TM1User; END...