Search found 126 matches
- 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...
- 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
- 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
Here's the script I used:
https://github.com/ykud/tm1_restapi/blo ... e_views.py
- 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...
- 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 ...
- 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...
- 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 ...
- 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.
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: 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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 
