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
Search found 144 matches
- 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
- 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...
- 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 ...
- 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...
- 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 ...
- 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.
Amazing how is it not documented, I can only find one post mentioning it was added in 10.2.2 FP5.
- 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 ...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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
- 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...
- 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.