TM1 Forum

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...

Know nothing about functionality etc., only that Intito offers Office Connect which may meet your requirement MarenC.

Glad it helped.

I left the duplicates in as I have ideas of adding more MDX around them to show their parents in the rollup so that it is easy to track down the nonsense. A project for another day...

Are you stalking me? Did this just yesterday to meet a requirement: Basically looking at all the elements in a rollup and counting those that appear multiple times. You could likely add your own TM1FilterByLevel where/if necessary: FILTER ( {DESCENDANTS({[<dim>].[<hier>].[<rollup>]})}, COUNT( {INTER...

Consider that if you are dealing with a private view, those views may have private sets which would need to be copied along with the .vue