Search found 144 matches
- 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: 2738
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...
- Thu Feb 08, 2024 11:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IF Statement Evaluation in Rules
- Replies: 4
- Views: 881
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...
- Wed Jul 19, 2023 10:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting Architect Users into PAW
- Replies: 6
- Views: 1904
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...
- Wed Jun 28, 2023 1:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting Architect Users into PAW
- Replies: 6
- Views: 1904
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'...
- Wed Feb 23, 2022 9:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Background processing / queue (Not chores)
- Replies: 15
- Views: 4106
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
https://ibm.ent.box.com/s/v2r2np0ijarak ... 7bae75v9ne
- 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: 11629
Re: Managing TM1 database assets with Git
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 )
- 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: 44745
Re: Planning Analytics 2.0.9.9
Shows then I last edited it directly Thanks heaps for correction -)Andy Key wrote: ↑Mon Jul 19, 2021 2:20 amFirst line not last line. 575 is the start of the Epilog...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.means that there are 84 lines in Data.Code: Select all
575,84
- 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: 44745
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...
- 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: 11629
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...
- Wed May 12, 2021 1:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Mode 2 - External AD
- Replies: 2
- Views: 3701
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...
- Fri Apr 23, 2021 2:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube last data pull
- Replies: 14
- Views: 7745
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...
- Wed Apr 21, 2021 2:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Local Backup
- Replies: 30
- Views: 20129
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...
- Wed Mar 31, 2021 3:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bespoke Picklists
- Replies: 3
- Views: 2601
Re: Bespoke Picklists
I think it's just called }Picklist cubes , definitely something to use in your case.
- Fri Mar 12, 2021 10:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web logout not working
- Replies: 6
- Views: 4986
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...
- 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: 2415
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
- 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: 16551
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...
- 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: 16551
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...
- Tue Feb 23, 2021 4:08 am
- Forum: Free And Open Source Tools
- Topic: Visual Studio Code Extension for TM1
- Replies: 12
- Views: 66640
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...
- 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: 6382
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...
- 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: 6382