Search found 144 matches

by ykud
Wed Mar 27, 2024 11:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to avoid queuing at the end of processes parallelization ?
Replies: 5
Views: 358

Re: How to avoid queuing at the end of processes parallelization ?

Data commit (the last step of the process) is single threaded / locking as it updates the cube index structure, so it might be the case when a lot of Tis are committing at the same time and are queuing due to this. It might be better to split data less evenly, so that they're committing at different...
by ykud
Thu Feb 08, 2024 11:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF Statement Evaluation in Rules
Replies: 4
Views: 799

Re: IF Statement Evaluation in Rules

I remember looking into this a while back and concluding that all IF conditions are evaluated, but I can't remember what example I used to conclude this (I think it was looking at rule stats to see if a measure value is being calculated where it shouldn't be). I think the order of how you write A OR...
by ykud
Wed Jul 19, 2023 10:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting Architect Users into PAW
Replies: 6
Views: 1788

Re: Getting Architect Users into PAW

Wow, can you please share more details? can't seem to find anything like it in release notes. I thought it's the other way around, there's now a way to sync PaW users to TM1 database now, like this https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=mugpadco-import-users-groups-from-planning...
by ykud
Wed Jun 28, 2023 1:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting Architect Users into PAW
Replies: 6
Views: 1788

Re: Getting Architect Users into PAW

However, as of either PAW 86 or 87 users and groups from TM1 can now be used as a source for PAW. So as long as you go with the latest version you will be fine and it will be pretty seamless. Wow, can you please share more details? can't seem to find anything like it in release notes. I thought it'...
by ykud
Wed Feb 23, 2022 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Background processing / queue (Not chores)
Replies: 15
Views: 3932

Re: Background processing / queue (Not chores)

Have a look at IBM's one for inspiration. it's usually something in the same vein + some pegs and bandaids for a particular operating system or any other idiosyncrasies.

https://ibm.ent.box.com/s/v2r2np0ijarak ... 7bae75v9ne
by ykud
Wed Oct 06, 2021 11:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Managing TM1 database assets with Git
Replies: 12
Views: 11341

Re: Managing TM1 database assets with Git

marko_p wrote: Tue Oct 05, 2021 9:55 am Hi,
did you manage to connect to Github via SSH?
Yep, works for me, but you need the 2.9.0.4 or later ( https://www.ibm.com/docs/en/planning-an ... er-17-2020 )
by ykud
Mon Jul 19, 2021 4:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0.9.9
Replies: 39
Views: 44293

Re: Planning Analytics 2.0.9.9

Andy Key wrote: Mon Jul 19, 2021 2:20 am
ykud wrote: Mon Jul 19, 2021 1:13 am I always get tripped up by the fact that the last line of the section records the number of lines in it, i.e.

Code: Select all

575,84
means that there are 84 lines in Data.
First line not last line. 575 is the start of the Epilog... ;)
Shows then I last edited it directly :) Thanks heaps for correction -)
by ykud
Mon Jul 19, 2021 1:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0.9.9
Replies: 39
Views: 44293

Re: Planning Analytics 2.0.9.9

Should it not be changed by IBM, then I can see a number of consequences: - editing a PRO file directly in a text editor and rebooting TM1 becomes a very risky undertaking Although I sometimes live life on the edge in the way a lot of old school admins do, I have to admit that I don't think I've ev...
by ykud
Fri May 21, 2021 7:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Managing TM1 database assets with Git
Replies: 12
Views: 11341

Re: Managing TM1 database assets with Git

Also, github is deactivating the basic auth that the tm1git uses to connect to their server in august 2021. Now they'll only accept tokens or SSH Key authentication , but tm1git doesn't have support for that! SSH is supported : https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=git-secure-s...
by ykud
Wed May 12, 2021 1:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Mode 2 - External AD
Replies: 2
Views: 3628

Re: PAW Mode 2 - External AD

My question: What else should I do in order to allow an external user to use PAW Windows authentication ? Do I need to use kerberos to allow this user_A ldap server ? PaW and Architect actually work quite the same way (unlike Tm1web with SSO, sigh), you need an SPN set up for the tm1 service accoun...
by ykud
Fri Apr 23, 2021 2:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 14
Views: 7620

Re: Cube last data pull

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. Very cool idea. There's a caveat to LoadOnDemand -- every cube that is rule referenced or has feeders will be loaded r...
by ykud
Wed Apr 21, 2021 2:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 30
Views: 19667

Re: Local Backup

Insetad of 7-zip, I used PowerShell System.IO.Compression.FileSystem to perform the zipping. Alternatively you can use Powershell Compress-Archive cmdlet. All thee are available on Windows Server as long as PowerShell is not disabled. No installation of 3rd party software. Sorry for raising the dus...
by ykud
Wed Mar 31, 2021 3:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bespoke Picklists
Replies: 3
Views: 2565

Re: Bespoke Picklists

I think it's just called }Picklist cubes , definitely something to use in your case.
by ykud
Fri Mar 12, 2021 10:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web logout not working
Replies: 6
Views: 4894

Re: TM1Web logout not working

We guess that the many active users are the reason for regular crashs of TM1WEB. Number of users wasn't really ever the reason for crashes in my experience. I'd look into playing with your JVM parameters in jvm.settings as per this technote Something like this -Xmx16256m -Xms4096m -Xmn4096m -Xgcpol...
by ykud
Thu Mar 11, 2021 2:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Comments and threaded conversations in dashboards
Replies: 4
Views: 2378

Re: Comments and threaded conversations in dashboards

I'm in the 'second cube with comments' (potentially with some cut-down dimensionality) camp. You can try to show it as a cube view with synchronised context or a wesbhreet (that's the standard). Throw in an additional dimension to capture multilines or replies if you're feeling fancy :)
by ykud
Wed Mar 03, 2021 7:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )
Replies: 19
Views: 16018

Re: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )

So what you are saying is that runing PAW on a windows env with WSL 2 is the way to go and its all peaches and cream? Would you go with this over Linux? If you would go with Linux over Windows with WSL 2, what would be a good reason to do so when setting up PAW? Alan is spot on, I didn't say anythi...
by ykud
Tue Mar 02, 2021 11:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )
Replies: 19
Views: 16018

Re: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )

If you've managed to get PAW to run for you (and as an aside I believe that this is easier on Linux than on Windows, which doesn't help in an all-Windows shop) then more power to you. Night and day on Windows and Linux. PaW on Windows is a real box full of unknowns and surprises and doesn't play ni...
by ykud
Tue Feb 23, 2021 4:08 am
Forum: Free And Open Source Tools
Topic: Visual Studio Code Extension for TM1
Replies: 12
Views: 65890

Re: Visual Studio Code Extension for TM1

Very exciting! Do you need help with anything? I understand you don't want to create the repo yet, but maybe create a stub on GitHub with readme.md of your first post? It'd give you an issue tracker for ideas & discussions straight off the bat. We can start voting for extension name :) I think i...
by ykud
Mon Feb 22, 2021 11:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: preventing automatic restart of databases after monthly maintenance
Replies: 14
Views: 6266

Re: preventing automatic restart of databases after monthly maintenance

Interesting. I suspect that will change in time, but I suppose that's another cost factor. Having the servers on Windows only saves the cost of having some Linux support specialists, beyond those needed to run PAW. When or if they reach a critical mass of cloud clients... we can but speculate which...
by ykud
Mon Feb 22, 2021 10:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: preventing automatic restart of databases after monthly maintenance
Replies: 14
Views: 6266

Re: preventing automatic restart of databases after monthly maintenance

Alan Kirk wrote: Mon Feb 22, 2021 5:49 pm Interesting; that surprises me on a number of levels.
They wouldn't be able to migrate on-prem customers otherwise, too much hassle with converting all the scripts to bash :)

PAW in cloud is on linux, TM1 is on Windows without a linux option.