Search found 144 matches

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

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

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

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

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

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: 19
Views: 106286

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

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

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

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

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

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

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

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

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

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

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

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

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 :)
by ykud
Thu Jul 23, 2020 6:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES
Replies: 9
Views: 8155

Re: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES

Thanks, ykud. I will check if setting LockPagesInMemory=F could solve the problem. When the error happened, the working set of tm1s.exe process is about 49G, and almost of these 49G is locked and garanteed non-paging like the IBM doc says, but the free physical memory on that VM is still 100G which...
by ykud
Tue Jul 21, 2020 11:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP BW as a data source in TM1 (PAL) - Cognos Integration server (CIS)
Replies: 3
Views: 3218

Re: SAP BW as a data source in TM1 (PAL) - Cognos Integration server (CIS)

We've had a few rough patches with CIS and use BW ODBC connection lately with a lot less friction :) That's for BW -> TM1, TM1->BW is still via file / staging database.