List of Contributions

Matt Hopkins

QueBIT Consulting

Contact Details

QueBIT Consulting

My Content

1 to 17 of 17 total

RE: PAX - 413: Request Entity too large

Posted By Matt Hopkins Thu March 10, 2022 09:36 AM
Found In Egroup: Planning Analytics \ view thread
Hi James, Hope you're doing well. Take a look at the following IBM Websphere troubleshooting article. This error is related to denial of service protection on the WebSphere server. There is a way to adjust this, but you might need IBM's help if this is an issue with PA cloud. https://www.ib ...

RE: Scripting PAX API with Excel application hidden

Posted By Matt Hopkins Wed March 02, 2022 10:25 AM
Found In Egroup: Planning Analytics \ view thread
Herman, You mentioned that the issue is only occurring when the authentication code is included. This could be a side effect of the way PAX stores cookies. As I understand, a browser is launched during authentication in order for the cookies to be retrieved for future API calls. Since the authentication ...

RE: Automate Task pane via API in PAX

Posted By Matt Hopkins Wed September 29, 2021 09:44 AM
Found In Egroup: Planning Analytics \ view thread
Hi Nico, A 438 error indicates that a property or method you are trying to use does not exist. This is more than likely happening because the casing is incorrect in your call. https://ibm.github.io/paxapi/#refresh-task-pane Based on the above link, the call would need to be changed to the following. ...

RE: PAX API

Posted By Matt Hopkins Fri July 23, 2021 09:10 AM
Found In Egroup: Planning Analytics \ view thread
Siew, Can you try and remove the hard brackets from the create call? Also, do you have "http://test.tech" system configured as a connection in PAFE? Try the following instead. Public Sub Create() Reporting.Explorations.Create "http://test.tech", "24Retail","Revenue", "Compare" End Sub ...

RE: PAX API

Posted By Matt Hopkins Mon July 19, 2021 09:17 AM
Found In Egroup: Planning Analytics \ view thread
Siew, Please make sure you have followed the "Necessary IBM Cognos automation API references" documentation which can be found below. https://ibm.github.io/paxapi/#log-automation-activities-and-errors Specifically, you need to make sure the following VBA code block exists in order to reference ...

RE: PAfE SUBNM Set Editor Customization

Posted By Matt Hopkins Thu June 10, 2021 09:19 AM
Found In Egroup: Planning Analytics \ view thread
Hi Constantin, The following documentation may help with the customization of the UI. Because PAfE uses the Workspace Set Editor, these settings would need to be changed on the Workspace side. https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=workspace-customize-interface-your-company ...

RE: PAW/PAX Task Pane

Posted By Matt Hopkins Fri March 19, 2021 10:57 AM
Found In Egroup: Planning Analytics \ view thread
Hi Nidhi, I would suggest upgrading to the latest version of PAx. I have tested this in version 2.0.54.6 (not the latest) and it does seem to change the captions in the tree to the alias value as expected. Hope this helps. Matt ------------------------------ Matt Hopkins Senior Software ...

RE: PAW/PAX Task Pane

Posted By Matt Hopkins Thu March 18, 2021 09:37 AM
Found In Egroup: Planning Analytics \ view thread
Hi Nidhi, You can accomplish this by right clicking the hierarchy and selecting the appropriate alias name. Thanks, Matt ------------------------------ Matt Hopkins Senior Software Engineer QueBIT Consulting ------------------------------

RE: Migrating Quick Reports

Posted By Matt Hopkins Fri February 19, 2021 09:41 AM
Found In Egroup: Planning Analytics \ view thread
Hi Joe, You can also modify the named ranges which support each quick report. Opening the Named Range Manager will show a set of 4 named ranges for each Quick Report. The 'tm1\\_0_H' host named range is value based and can be updated manually or through automation to point to the appropriate host, ...

RE: Default expand direction option not working in PAfE v55

Posted By Matt Hopkins Fri February 19, 2021 09:31 AM
Found In Egroup: Planning Analytics \ view thread
I was able to reproduce this on an older report which had been created without hierarchy unique names in the Exploration's MDX. This seems to be an issue that needs to be resolved by the dev team. However, I found a workaround by simply opening the MDX editor and clicking OK which seemed to update the ...

RE: PAX/PAW Context Filter allows only one member

Posted By Matt Hopkins Tue December 22, 2020 09:48 AM
Found In Egroup: Planning Analytics \ view thread
Aleksandre, In PAfE (PAx), you have the ability to SUM across the context selection for any dimension. However, this has to be enabled and is disabled by default. You will then see the following option on the context drop down menu. For PAW, I would take a look at Paul Glennon's ...

RE: Pax Exploration View - Insert Calculation Issue

Posted By Matt Hopkins Mon December 14, 2020 10:24 AM
Found In Egroup: Planning Analytics \ view thread
Aleksandre, I would suggest simply using an Excel formula which can be preserved and refreshed with the report by performing the following actions. 1. Using the PAfE context menu, insert a user row on the rows axis. 2. In the first data cell of the row, enter the desired Excel formula calculation. ...

RE: PAfE automatic logon to TM1 server (Integrated Windows Auth)

Posted By Matt Hopkins Fri December 04, 2020 10:07 AM
Found In Egroup: Planning Analytics \ view thread
Matthias, API based authentication is not available for IA (Mode3). I understand your frustration, seeing as a formula report refresh does not automatically prompt the user to authenticate. However, a refresh of other reporting modes, such as a Quick Reports, does indeed prompt the user. This prompt ...

RE: PAfE DBRWs overwritten on pasting of values

Posted By Matt Hopkins Tue December 01, 2020 09:27 AM
Found In Egroup: Planning Analytics \ view thread
Hi George, Appreciate the detail in your explanation. This seems like a defect that should be logged with IBM. I'm curious to know what happens in the following two cases. 1) Copy and paste from non formula static cell values 2) Paste Special Value on an individual cell Thanks, Matt ...

RE: PAW default sort A-Z

Posted By Matt Hopkins Tue November 03, 2020 09:44 AM
Found In Egroup: Planning Analytics \ view thread
Asgeir, It appears that IBM is aware of this functionality gap and is considering adding the ability to change the defaults. Definitely add your vote to the logged idea at the following location. https://ibm-data-and-ai.ideas.aha.io/ideas/PAOP-I-63 ------------------------------ MattHopkins ...

RE: Upgrading from CAFE to PAX - Missing Functionality?

Posted By Matt Hopkins Fri August 28, 2020 09:46 AM
Found In Egroup: Planning Analytics \ view thread
Hi Rich, The Reorder/Rename feature was removed from PAfE (PAx) in favor of managing order from the set editor. PA calculation order can be managed through the set editor and I would assume the intention is that CA calculations can be managed in the same way. https://www.ibm.com/support/knowle ...

RE: PAX "Dynamic Report" does not use dimension Caption Names

Posted By Matt Hopkins Thu July 16, 2020 10:44 AM
Found In Egroup: Planning Analytics \ view thread
Paul, For Dynamic Reports, you would need to use the Alias property of the TM1RPTROW formula to obtain an alternate caption. I do not believe localized captions are supported in the formula reports. However, Quick Reports and Explorations will retrieve the localized caption. Thanks -------- ...