Search found 126 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...
by ykud
Sun Sep 13, 2020 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Risks of using Multiple Commit Mode
Replies: 2
Views: 396

Re: Risks of using Multiple Commit Mode

2- Any idea what causes the the chore to run 2 or 3 times in a row ? I'm a big fan of adding log4j.logger.TM1.Lock.Exception=DEBUG, S1 to the tm1s-log.properties file as it'll show you the lock contention and will say whether a chore is rolled back. I'd guess that SaveDataAll chore is trying a serv...
by ykud
Tue Aug 25, 2020 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Login - Perspectives or PAx or PAW or Contributor
Replies: 3
Views: 800

Re: User Login - Perspectives or PAx or PAW or Contributor

Tm1top and it’s logging reincarnation captures application context that tells you whether it’s tm1web or tm1application (contributor). For Pax vs Perspectives you can look at thread id: old api generated long numeric thread ids and rest api starts from quite low numbers and also has the : in it Here...
by ykud
Thu Aug 13, 2020 12:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: High Availability PA server
Replies: 4
Views: 726

Re: High Availability PA server

Yes with Rest API delta queries it's possible. After you initialize a monitoring/mirroring service each subsequent query can just retrieve cells with changed values since the last delta request and push these to the hot synced instance. For some customers requiring high availability on failover we ...
by ykud
Mon Aug 10, 2020 5:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy your PAW book design to another TM1 server
Replies: 9
Views: 1259

Re: Copy your PAW book design to another TM1 server

Thank you for sharing. While we're at it, can anyone explain why this import it to your personal folder and then you can move it to the Shared Folder. makes any sense? From what I can see in my testing, you cannot overwrite the existing book, so you need to delete the target book first and then move...
by ykud
Fri Aug 07, 2020 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading customisation
Replies: 2
Views: 474

Re: Spreading customisation

Hello! This is my first post on this forum, so if my description is to complicated, please give me a feedback and i would describe it more precisely. I have 2 questions connected with tm1 spreading functionality: 1. Do you know is there any way to change default (propotional) spreading method while...
by ykud
Wed Jul 29, 2020 11:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Separate measure dimension for each cube VS one singular measure dimension for all cubes
Replies: 7
Views: 991

Re: Separate measure dimension for each cube VS one singular measure dimension for all cubes

Somebody will put a string element in this mega-measure dim and bam: you cannot reorder dimensions anywhere anymore :)