Search found 2612 matches

by Wim Gielis
Thu Apr 22, 2021 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 13
Views: 192

Re: Cube last data pull

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 :-)
by Wim Gielis
Wed Apr 21, 2021 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 26
Views: 4399

Re: Local Backup

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...
by Wim Gielis
Tue Apr 20, 2021 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to for TI to write to multiple intersection in one line?
Replies: 8
Views: 169

Re: Is there a way to for TI to write to multiple intersection in one line?

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.
by Wim Gielis
Mon Apr 19, 2021 7:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 283

Re: Tm1s.cfg my own parameters

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...
by Wim Gielis
Fri Apr 16, 2021 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 263

Re: Break function

Weird ! But then the advantage of the simplicity of Break is gone too 😉
by Wim Gielis
Fri Apr 16, 2021 11:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 263

Re: Break function

I haven’t tried Sleep yet, I should do that more by the way !
by Wim Gielis
Fri Apr 16, 2021 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 263

Re: Break function

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.
by Wim Gielis
Thu Apr 15, 2021 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 263

Re: Break function

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.
by Wim Gielis
Thu Apr 15, 2021 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 263

Break function

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...
by Wim Gielis
Tue Apr 13, 2021 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

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:
05.png
05.png (37.07 KiB) Viewed 183 times
by Wim Gielis
Mon Apr 12, 2021 5:46 pm
Forum: Useful code, tips and tricks
Topic: TM1 formulas to values in VBA with PAFE API
Replies: 2
Views: 167

Re: TM1 formulas to values in VBA with PAFE API

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.
by Wim Gielis
Sun Apr 11, 2021 10:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Setting Element variable
Replies: 6
Views: 2237

Re: TI - Setting Element variable

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.
by Wim Gielis
Sun Apr 11, 2021 10:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HELP: ASCIIOUTPUT issues
Replies: 20
Views: 10783

Re: HELP: ASCIIOUTPUT issues

The filename could be dynamic and contain the cost center:
asciioutput ( 'c:\data_' | vCC | '.txt', ... );
by Wim Gielis
Sat Apr 10, 2021 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT does not create output file
Replies: 18
Views: 1345

Re: ASCIIOUTPUT does not create output file

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...
by Wim Gielis
Sat Apr 10, 2021 9:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 5
Views: 991

Re: Asciioutput Data Export is not working

Please do not post in multiple topics the same question.
by Wim Gielis
Sat Apr 10, 2021 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT does not create output file
Replies: 18
Views: 1345

Re: ASCIIOUTPUT does not create output file

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.
by Wim Gielis
Sat Apr 10, 2021 2:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Register process via RestAPI
Replies: 14
Views: 583

Re: Register process via RestAPI

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
by Wim Gielis
Sat Apr 10, 2021 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

What about Belgium with 3 official languages (Dutch, French, German), even not including English ? 😉
by Wim Gielis
Fri Apr 09, 2021 9:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

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