Search found 294 matches

by John Hammond
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: 4591

Re: Advice on training in Planning Analytics between jobs

gtonkin wrote: Wed Oct 18, 2023 2:52 pm The new PA on AWS (PA aaS) trial is here
Thank you gtonkin and all respondents
by John Hammond
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: 4591

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...
by John Hammond
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: 4591

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...
by John Hammond
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: 8960

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...
by John Hammond
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: 565

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...
by John Hammond
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: 565

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...
by John Hammond
Tue Jun 20, 2023 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting Architect Users into PAW
Replies: 6
Views: 1751

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...
by John Hammond
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: 3959

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...
by John Hammond
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: 750

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.
by John Hammond
Wed Nov 30, 2022 10:22 am
Forum: Bugs
Topic: 11-101026871-9.1SP4-Apparent bug in Load On demand Property
Replies: 2
Views: 11235

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...
by John Hammond
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: 2123

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...
by John Hammond
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: 830

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.
by John Hammond
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: 830

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...
by John Hammond
Thu Mar 10, 2022 11:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 and ibm cloud
Replies: 6
Views: 1695

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.
by John Hammond
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: 3973

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 ...
by John Hammond
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: 3973

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. ...
by John Hammond
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: 24881

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...
by John Hammond
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: 28095

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...
by John Hammond
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: 26635

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 ...
by John Hammond
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: 7611

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.