TM1 Forum

Elessar wrote: ↑

Thu Apr 22, 2021 1:22 pm

Hi,

You can use "load on Demand" parameter for this. Check it on every cube, and monitor the memory usage in }StatsByCube. The cubes which are not loaded - were not used.

That's a good piece of lateral thinking

I'm intrigued to know whether dropping EXE files onto the TM1 cloud environment is formally permitted by IBM's SaaS Ts&Cs? Last week I implemented a backup functionality with 7zip for a cloud customer. Either you copy over the file 7za.exe and call it. Either you copy over the files 7z.exe and 7z.d...

If you want to write String data to the cube (CellPutS), CellPutProportionalSpread is not going to help you.

But most likely, yes, the fact that the dynamic subsets recaculates too many times could be the culprit.

BTW, I don't like the idea of having prod and non-prod services sharing the same name. YMMV. My mileage varies greatly indeed. If I'm having users testing reports in a dev environment (especially complex reports which draw from multiple servers), websheets on TM1 web etc, etc, I want them using EXA...

Weird ! But then the advantage of the simplicity of Break is gone too

I haven’t tried Sleep yet, I should do that more by the way !

Hi Wim, I use Break too, so this is good to know. If you put Sleep (100) before the first Break does this resolve it? Interestingly adding an asciioutput into both IF statements outputs 2 files if a break statement is there. regards, Mark Yes, the Breaks are ignored leading to endless loops too.

Thanks for the confirmation, these were exactly my thoughts too.
I think I will continue using Break and make sure there's only 1 of it, if there are 2 then yes, a numeric value will do.
I just find Break so much better than escaping loops with numeric values like -1 or 0 or 999 or some such.

Hi all, I know that the Break function is not supported in TI. But in the past it never bite me, until today. Looking at this code: c = 1; While( c > 0 ); If( 'X' @= 'Y' ); Break; EndIf; c = c + 1; If( c > 3 ); Break; EndIf; End; The process will run forever and bring the TM1 server to the ground. W...

Hello Ty,

While not definitive proof, I am almost certain Caption is an Alias here. I found back this part in a TI process of some time back:

Paul Segal wrote: ↑

Mon Apr 12, 2021 3:45 pm

Hi Wim,

It's version-related - from 11.0.56 I don't think it will give you the confirmation messages.

Thanks Paul. I have PAFE version 61 on my own laptop and it still gives the confirmation msgbox'es.

Please do not post the same question in more than one topic. It’s even not your topic and it’s a very old one.

The filename could be dynamic and contain the cost center:
asciioutput ( 'c:\data_' | vCC | '.txt', ... );

Nice application

If you have a process without any code, what are the settings of the view that you use in the Data source ? Are certain cells skipped from the view ? When removing any consolidated cells / zeroes / rules-calculated cells, do you have at least 1 cell remaining ? Do you have the variables marked as Ot...

Please do not post in multiple topics the same question.

The problem will be the data source, unless you see that other code in the Data (or Metadata) tab gets executed. You do need to make sure at runtime the correct view is used, including settings for skipping consolidated cells/zeroes/rules-calculated cells. 95 out of 100 there is your problem.

Hi,

I haven't experimented with it (yet) but would be PAFE API be an alternative ? In the end it's VBA so not terribly difficult (I assume )

There's code here: https://ibm.github.io/paxapi/#rest-api

What about Belgium with 3 official languages (Dutch, French, German), even not including English ?

If a TM1 model needs to be made multi-language, it can be done with a Caption: 05.png Cubes, dimensions, elements, views, subsets, processes, chores, ... can be made multi-language. Too bad this does not work ! DimensionElementPrincipalName( '}Clients', 'Measure' ) It gives back 'Measure' instead of...