Search found 271 matches

by John Hammond
Fri Jan 29, 2021 4:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - TI process timed out
Replies: 3
Views: 390

Re: PAW - TI process timed out

Switch to action buttons that are synchronous and dont use the API call of a normal excel button which is async.

Why this crazy modern obsession with doing stuff Async?
by John Hammond
Fri Jan 29, 2021 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX (400) Bad Request
Replies: 3
Views: 365

Re: PAX (400) Bad Request

You get 400 message when you click on an action button

The TM1 .xll add-in is not installed or inactive.
by John Hammond
Thu Jan 28, 2021 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX (400) Bad Request
Replies: 3
Views: 365

Re: PAX (400) Bad Request

Exception of type 'Cognos.Office.Tm1.Connections.RedirectException' was thrown

Didnt login before clicking on action button. Not all objects in PAX redirect you to log in!
by John Hammond
Thu Jan 28, 2021 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX (400) Bad Request
Replies: 3
Views: 365

Re: PAX (400) Bad Request

Will get the ball rolling - this can be a mal formed Quick Report. Go to the task pane -> Workbooks -> Quickreports right click and Show Report This shows you the Context, Rows and Columns. The problem will usually be the context, as you have likely deleted the row that contain the details. [Base] (...
by John Hammond
Thu Jan 28, 2021 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX (400) Bad Request
Replies: 3
Views: 365

PAX (400) Bad Request

PAX is very poor in that if it generates a Bad Request you get (400) Bad Request HTTP error, the java stack and nothing else, although it would be easy enough for IBM to generate a meaningful message. So here is my attempt to create a topic where investigations behind the dreaded 400 can be posted t...
by John Hammond
Thu Dec 10, 2020 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Will IBM ever convert Perspectives to use the Rest API?
Replies: 6
Views: 569

Re: Will IBM ever convert Perspectives to use the Rest API?

Alan you have to get a like button or something like that. Enjoyed your post.
by John Hammond
Wed Dec 09, 2020 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Will IBM ever convert Perspectives to use the Rest API?
Replies: 6
Views: 569

Will IBM ever convert Perspectives to use the Rest API?

Perspectives assumes a LAN where a small request can be immediately acted upon. The feedback from the response to your chat can be used to better direct your query. Citrix allows this behaviour to occur over a WAN by transmitting the display only, like the terminals in the 1980s. That said, it is a ...
by John Hammond
Tue Apr 21, 2020 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Never ending GET cellset thread
Replies: 1
Views: 972

Re: Never ending GET cellset thread

PA now gives you tm1event.log which lists long running threads and locking contentions. The only problem is that it lists only the thread number which doesnt let you trace any further when the thread has gone.
by John Hammond
Thu Apr 16, 2020 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to Connect to HTTPS PAW with IE v11
Replies: 0
Views: 1380

Unable to Connect to HTTPS PAW with IE v11

Hi Just wondering if anyone has encountered this problem with browsing to HTTPS PAW with IE v11. Here are the steps we took. 1. Using HTTP PAW worked 2. We switched to HTTPS PAW and we can browse PAW using Google Chrome, but the Company default is IE v11 (specifically 11.0.180). 3. HTTPS PAW can be ...
by John Hammond
Tue Nov 12, 2019 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX: TM1IOData Source still uses PMHUB for CognosOfficeAutomationObject.ExecuteFunction to run a TI
Replies: 2
Views: 899

PAX: TM1IOData Source still uses PMHUB for CognosOfficeAutomationObject.ExecuteFunction to run a TI

One of the attractions of PAX is that the new TM1IOData source mainly bypasses the Application Server and talks to TM1 directly bar high level functions that are handled by WorkSpace. We found the previous incarnation of the application server, PMHUB, to not match the stability of good old fashioned...
by John Hammond
Thu Oct 24, 2019 11:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives and Office 2013
Replies: 14
Views: 11903

Re: Perspectives and Office 2013

Hi Sandar Did you get any luck with resolving the Tm1camclient Passport starting error? We had an old 9.5 perspectives client that worked fine with Excel 2010 and gives this message now we have upgraded to 2013. Have tried pretty much everthing suggested by IBM and have just got IT to drop DEP (data...
by John Hammond
Mon Oct 21, 2019 4:58 pm
Forum: Enhancements
Topic: Choose to "Refresh Client Interface on Running Process"
Replies: 1
Views: 6226

Choose to "Refresh Client Interface on Running Process"

The assumption seems to be when you run a process ( in Perspectives or Performance Modeller) then you need to refresh the entire client cache as the client does n't know what the process has changed on the server. This takes ages in Perf Modeller and non citrix Perspectives. Mostly the cached info i...
by John Hammond
Fri Jul 12, 2019 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct edit dimension collection has not been cleared before commit
Replies: 9
Views: 5663

Re: Direct edit dimension collection has not been cleared before commit

Agreed, both elements and attributes can go missing.

Ignore this error message at you peril!
by John Hammond
Fri Feb 09, 2018 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 3276

Re: String Feeder

Never put any feeder info into Security Cubes as they get evaluated top down anyway. So macsir's suggestion would work. How you feed a constant has always been a bit of a gripe for me, since constants are not derived, and I believe there should be syntax in TM1 feeders along the lines of FeedByDefau...
by John Hammond
Wed Feb 07, 2018 6:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx for MSExcel (formerly CAFE) errors explained
Replies: 3
Views: 1800

Re: PAx for MSExcel (formerly CAFE) errors explained

Renaming Pax from Cafe

Exploration View = Café Crosstab
Quick Report = Café FlexView
by John Hammond
Wed Feb 07, 2018 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx for MSExcel (formerly CAFE) errors explained
Replies: 3
Views: 1800

PAx for MSExcel (formerly CAFE) errors explained

COI-ERR-2016 Worksheet protected IBM Cognos Styles cannot be populated

The current worksheet in the workbook just opened is protected.

WA: Save the workbook with a different worksheet or use a cover sheet. This message is informational but may put a user off.
by John Hammond
Tue Feb 06, 2018 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tools to copy and rename TM1 object
Replies: 6
Views: 2666

Re: Tools to copy and rename TM1 object

Text Substitution works fine on TM1 objects provided the original and replacement texts are the same length. Don't attempt otherwise or you will just bust your instance and even with the above proviso always have a backup of your original instance.
by John Hammond
Tue Feb 06, 2018 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel: Element of Subset?
Replies: 8
Views: 3536

Re: Excel: Element of Subset?

IIRC

ELISANC(dimname, subname, elementname)

works in Excel but nowhere else as does ELISPAR.

Otherwise use SUBNM with index 1,2 to iterate the subset on a hidden page and do VLOOKUP.
by John Hammond
Mon Feb 05, 2018 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore resubmitting itself when Locked out by another Process
Replies: 4
Views: 1943

Re: Chore resubmitting itself when Locked out by another Process

Hi Alan Thanks for the update. Yes, it has been a long time - think you had the Mr T icon back then! :D I've updated my profile as requested. Absence down to overzealous internet filters. Many times I tried to point out that this was an aid to TM1'ers only to be met with a sea of indifference and be...