Search found 132 matches

by ykud
Wed Mar 31, 2021 3:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bespoke Picklists
Replies: 3
Views: 507

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: 5
Views: 799

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: 468

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: 1234

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: 1234

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: 10
Views: 1021

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 it sh...
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: 724

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: 724

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.
by ykud
Mon Feb 22, 2021 7:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Matching unnamed subset with named subset
Replies: 5
Views: 491

Re: Matching unnamed subset with named subset

I'd say it's probably simpler with rest api than with a TI over .vue files, but I'm biased as I had to do something similar to identify all the views that had the unnamed ALL subset in their definition.
Here's the script I used:
https://github.com/ykud/tm1_restapi/blo ... e_views.py
by ykud
Sat Feb 20, 2021 10:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 1196

Re: Monaco TM1 Editor with Intellisense

Vscode would be amazing, it adds a lot of really good extensions and is a very well thought through IDE, so it’s confines are more like a benefit from my point of view. CarpeDatums plug-in was only doing syntax highlighting, live editing with rest api would be a game changer. I’d be happy to contrib...
by ykud
Thu Feb 11, 2021 10:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 1113

Re: RunProcess Again

My only hesitancy in recommending this over file based semaphores is that although the behaviour from using CubeSaveData is logical, it isn't exactly documented. Thanks a lot for confirming, this is indeed quite logical and neat, very nice approach. I'll still stick with file flags until there's a ...
by ykud
Thu Feb 11, 2021 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess Again
Replies: 14
Views: 1113

Re: RunProcess Again

It is possible to keep track of the thread flags in a cube via using the trick in the watcher process of CubeSaveData of the thread control cube which sidesteps TM1's commit model and allows the watcher process to read updated values. But this is a bit of a hack although it seems pretty robust. Can...
by ykud
Wed Feb 10, 2021 11:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 667

Re: PA Cloud Optimization

Our TM1 Server is local, both CA (CAM) and TM1 Web are on the Azure cloud. Our cloud team are looking at network optimizations to try and speed things up. I think TM1web still uses the chatty old protocol with multiple trips to get data from Tm1 server, so you'd see this when you're increasing the ...
by ykud
Sun Feb 07, 2021 9:26 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 15
Views: 17282

Re: PickList to show Alias but store Element Name

The best 'new' feature of 2020 from my point of view!
Amazing how is it not documented, I can only find one post mentioning it was added in 10.2.2 FP5.
by ykud
Fri Dec 25, 2020 9:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New Approval Hierarchy -
Replies: 2
Views: 604

Re: New Approval Hierarchy -

It is rebuilding rights from scratch and it might be a long running process, as it is going through number of groups * number of application dim elements * elements in control dim in the process. https://www.ibm.com/support/pages/changes-tm1-application-deployment-and-rights-saving-tm1-102 has some ...
by ykud
Wed Dec 09, 2020 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Throttle and / or Block a users Rest API connection from third party apps.
Replies: 8
Views: 732

Re: Throttle and / or Block a users Rest API connection from third party apps.

I guess combining this with blocking the path from the third party app to PA or TM1 (the app in question talks directly to TM1) would force the traffic through the proxy. Conceptually this works but requires significant (?) effort and a skill set that isn't traditionally assocaited with TM1. This w...
by ykud
Wed Dec 09, 2020 6:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Throttle and / or Block a users Rest API connection from third party apps.
Replies: 8
Views: 732

Re: Throttle and / or Block a users Rest API connection from third party apps.

In this organisation TM1 is the trusted source for "Dataset A". There are a large group of users (~30) who are skilled technically and have a preference for using the data in a third party application. For a long list of reasons from control and security (i.e. how do we know the users of your third...
by ykud
Sat Oct 31, 2020 11:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 to PA TM1Web iFrame Issue
Replies: 13
Views: 2119

Re: 10.2.2 to PA TM1Web iFrame Issue

That worked like a charm. Thank you so much for your help, JIm. Happy to help, Y I do second the run it through https suggestion by tomok, but I’m a big fan of not doing this configuration on pa side and using a reverse proxy like f5 in front of it to handle https. Certificates have mandatory 2 yea...
by ykud
Fri Oct 30, 2020 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 to PA TM1Web iFrame Issue
Replies: 13
Views: 2119

Re: 10.2.2 to PA TM1Web iFrame Issue

So I put this in: http://uat.reporting.panynj.gov:9510/tm1web/UrlApi.jsp?tm1web.origin="+http+"//"+uat.reporting.panynj.gov+"#Action=Open&Type=WebSheet&Workbook=Applications/Project%20OnBoarding/1.Onboarding%20Financial%20Forecast%20Data%20Entry&TM1Server=UAT_Project_OnBoarding_Financials&AccessTyp...
by ykud
Fri Oct 30, 2020 4:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 to PA TM1Web iFrame Issue
Replies: 13
Views: 2119

Re: 10.2.2 to PA TM1Web iFrame Issue

If you're mixing http inside https (which it sounds you do), the X-Frame setting wouldn't be enough in our experience, you'd get a SameOrigin communicated by tm1web and your https window will cut the iframe out, you need to add tm1web.origin= parameter to show where're you're embedding. Try somethin...