Thank you gtonkin and all respondents
Search found 294 matches
- Wed Oct 18, 2023 6:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advice on training in Planning Analytics between jobs
- Replies: 7
- Views: 5173
- Wed Oct 18, 2023 5:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advice on training in Planning Analytics between jobs
- Replies: 7
- Views: 5173
Re: Advice on training in Planning Analytics between jobs
You would think (maybe they do!) that IBM would have some kind of support network for people who have passed the badges, so when they lose their job they have access to training/development environments etc. I suppose that once they get TM1 itself established as part of the application running unde...
- Wed Oct 18, 2023 5:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advice on training in Planning Analytics between jobs
- Replies: 7
- Views: 5173
Advice on training in Planning Analytics between jobs
I would appreciate anyone's advice on Advice on training in Planning Analytics between jobs. I see there is an option to download a free trial from IBM, but I'm worried I might get roped into paying a lot of money to continue with that trial. I literally want to use Planning Analytics to upskill but...
- Thu Jul 13, 2023 1:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW assets disappear when MongoDB becomes corrupt or frozen under OCP
- Replies: 0
- Views: 10473
PAW assets disappear when MongoDB becomes corrupt or frozen under OCP
MongoDB is a text optimised database where the PAW assets are stored as json. If it doesn't work you have no assets. There are two distinct issues that we have encountered with MongoDB since we moved to OCP. (Openshift container platform) 1. Corrupted MongoDB – PAW objects are lost forever unless yo...
- Thu Jul 13, 2023 12:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel asks for Credentials in PAX when the CAM Authentication Service should get Credentials
- Replies: 2
- Views: 595
Re: Excel asks for Credentials in PAX when the CAM Authentication Service should get Credentials
Solution The user was attempting to login to the CAM authentication service with stored credentials which were out of date as the user had changed their password without the store updating. Type Credentials to get Credential Manager and then Windows Credentials. Delete the credential and it will cre...
- Wed Jul 12, 2023 1:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel asks for Credentials in PAX when the CAM Authentication Service should get Credentials
- Replies: 2
- Views: 595
Excel asks for Credentials in PAX when the CAM Authentication Service should get Credentials
Afternoon I have a very perplexing problem where PAX authentication has suddenly stopped working for a user. Normal troubleshooting has produced results and I am hoping someone in the wide world of the forum has encountered this. We are using PAX 72 with Mode 5 (CAM authentication) Normally the user...
- Tue Jun 20, 2023 1:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting Architect Users into PAW
- Replies: 6
- Views: 1833
Re: Getting Architect Users into PAW
As lotsa says, access to PAW is independent of TM1 at present and is through clunky .csv load/unload. The security gradation for users in PAW are just admin/non admin, but PAW users can be given permissions to access PAW objects by the owners of objects. When you need to connect to instances you wil...
- Tue Jun 13, 2023 1:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 4171
Re: Run Process - How to Determine When All Completed.
So the TM1 Servers move to the cloud as a service for IBM managed clouds (Openshift I assume). This will be the same black boxing as the PAW HTTP and Webservices and mean traditional access to the servers disk objects is gone without admin access to the cloud platform. All good until something break...
- Wed Nov 30, 2022 12:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mass conversion of Excel workbooks from Perspectives to PAW
- Replies: 2
- Views: 767
Re: Mass conversion of Excel workbooks from Perspectives to PAW
Server and Instance connections are held in CustomProperties in Excel and Named ranges. You can bulk VBA through a directory of workbooks. You can't change any VBA code in the macros by VBA though you have to do that through find and replace for the Project.
- Wed Nov 30, 2022 10:22 am
- Forum: Bugs
- Topic: 11-101026871-9.1SP4-Apparent bug in Load On demand Property
- Replies: 2
- Views: 12599
Re: 11-101026871-9.1SP4-Apparent bug in Load On demand Property
Thanks Alan - I can confirm in 2022 this bug has not been resolved. The load on demand is ignored if the cube has any feeders including internal feeders! As you say, IBM docs should be updated to say Load on Demand is effectively useless since large cubes will always have some type of feeders. As al...
- Fri Aug 05, 2022 3:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is this a Useful PAX tip?
- Replies: 7
- Views: 2158
Is this a Useful PAX tip?
L & G A user was moaning that, when he was moving from Cell to cell in a spreadsheet with PAX enabled, it was taking 5 seconds. So PAX was intercepting an event and doing 5 seconds of work and then returning control to Excel to move the cursor. We told him to type and run this in VBA: "Appl...
- Wed Mar 16, 2022 3:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX returns 413 Request Entity Too Large from Websphere in ICP
- Replies: 2
- Views: 846
Re: PAX returns 413 Request Entity Too Large from Websphere in ICP
Thanks Burnstripe - havent had time to try this - will let you know soon as I can.
- Thu Mar 10, 2022 12:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX returns 413 Request Entity Too Large from Websphere in ICP
- Replies: 2
- Views: 846
PAX returns 413 Request Entity Too Large from Websphere in ICP
When we make a "large" (>1MB) HTML request to Websphere from PAX (this can be report with many rows or typically a commit request that has a lot of tuples) we get it bounced back at the Webserver level as below. This severely limits what we can do in PAX. Capture.PNG So we found out that a...
- Thu Mar 10, 2022 11:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 and ibm cloud
- Replies: 6
- Views: 1721
Re: Tm1 and ibm cloud
Watch out with spreading esp auto spread. When you have loads of dimensions you can inadvertently generate a massive query. We had this and turned spreading off.
- Fri Feb 25, 2022 5:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What do IBM still have to do to replace Perspectives with PAW and PAX
- Replies: 11
- Views: 4110
Re: What do IBM still have to do to replace Perspectives with PAW and PAX
Hi, Refresh security, isn't that just a right-mouse button click on the server name ? Capture.PNG Wim, I stand corrected. Thanks all for your replies so far. Thanks Alan for your very comprehensive and entertaining response. qq On top of my original, hearing good things about 3rd party development ...
- Thu Feb 24, 2022 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What do IBM still have to do to replace Perspectives with PAW and PAX
- Replies: 11
- Views: 4110
What do IBM still have to do to replace Perspectives with PAW and PAX
Yoinks! Just heard a rumour IBM plan to deprecate/not support Perspectives in 2022 Q3. I don't think they can without, at the very least, replacing all of Perspective functionality with the same reliable features in PAW or PAX. Off the top of my head, I made a list of features we simply don't have. ...
- Mon Jan 24, 2022 6:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
- Replies: 12
- Views: 24969
Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
tm1runTI doesnt like \ in the parameters. Sometimes you have to change to double backslash. That might cause your missing parameters...
- Wed Dec 01, 2021 11:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Resolution problems with Windows 10 and tm1 perspectives
- Replies: 8
- Views: 28210
Re: Resolution problems with Windows 10 and tm1 perspectives
Hmmm IBM's approach to gradually let Perspectives die is not a good one. They dont have a Monopoly like Microsoft. This font problem should be sorted out, and the automated refresh of TM1 metadata on running a process should be disabled, so it is tolerable without Citrix. That should not bust the IB...
- Fri Aug 20, 2021 3:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Warning: PAX and Rest API do NOT support filters in Views
- Replies: 5
- Views: 26656
Warning: PAX and Rest API do NOT support filters in Views
All If you are moving from Perspectives to PAX be aware of this limitation. In Perspectives the Cube Viewer and Dynamic Reports (Active Forms) support filters in Views. (Right click on a column to choose sort order or Top 10 values etc) In PAX and I assume by extension the API, view filters are not ...
- Mon Aug 16, 2021 5:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cannot convert field number 14, value "@None" to a real numb
- Replies: 5
- Views: 7648
Re: Cannot convert field number 14, value "@None" to a real numb
Thanks everyone got this in Perspectives using a cube view as input with all dims defined as strings.
The cure was to change the view being used as a template in the Datasource section of the TI and accept keep all variables.
Don't know why it fixed it, but it did.
The cure was to change the view being used as a template in the Datasource section of the TI and accept keep all variables.
Don't know why it fixed it, but it did.