Search found 264 matches

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: 710

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: 1098

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: 549

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: 11016

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: 5876

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: 4835

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: 2656

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: 1395

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: 1395

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: 2153

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: 2888

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: 1524

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...
by John Hammond
Mon Feb 05, 2018 9:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore resubmitting itself when Locked out by another Process
Replies: 4
Views: 1524

Chore resubmitting itself when Locked out by another Process

Folks I have an unusual situation in that I have a chore that runs hourly. The chore runs a single process and the setting is such that it treats the chore as a single transaction. The single process has about 8 sub processes and takes about 2 mins to run. There is no start batch updates / end batch...
by John Hammond
Fri Dec 15, 2017 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 4025

Re: Change in Element Name of a frequently used Dimension

Can confirm what the guys are saying on here. I have a Dirty Cube Process somewhere which I can upload. Forewarning for users of PM - you don't see the SwapAlias results unlike in good ol' Perspectives. One thing where I think IBM missed a trick was the Caption which could have been used as the unal...
by John Hammond
Thu Nov 23, 2017 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: App-V install of TM1 Cafe requires multiple reboot of machine to start
Replies: 0
Views: 1085

App-V install of TM1 Cafe requires multiple reboot of machine to start

Just wondered if anyone had seen this problem before We have the Café add in installed under APP-V (Microsoft Virtualisation software that allows an application to run without conflicts as if it is the only application on the machine). The Café add-in works fine and then suddenly we are in a situati...
by John Hammond
Thu Jan 05, 2017 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 array of subset error
Replies: 16
Views: 7274

Re: TM1 array of subset error

The problem is when view or subset refers to aliased element in list and the alias gets removed.

Still in latest 10.2.2 prod version of TM1
by John Hammond
Sat Nov 07, 2015 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to prevent a commit / force a rollback
Replies: 16
Views: 6012

Re: How to prevent a commit / force a rollback

Wouldn't having a top process with called process steps in the prolog with conditional process quits between the steps. Commit only occurs at the end of the top processes' epilog
by John Hammond
Tue Mar 26, 2013 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input view immune from changes made in TI?
Replies: 2
Views: 1321

Re: Input view immune from changes made in TI?

Thanks David. That answer fits with my experience.
by John Hammond
Mon Mar 25, 2013 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input view immune from changes made in TI?
Replies: 2
Views: 1321

Input view immune from changes made in TI?

Does Tm1 construct the entire view prior to loading it to a TI or does it construct it from the cube bit by bit.? In the second case you would expect changes made in the TI to show in the data in the view and you would lose keys that you had zeroed out. Did some tests which suggest that case 1 pre-b...