Search found 2318 matches

by jim wood
Tue Nov 02, 2021 12:40 pm
Forum: General
Topic: Budget Demo
Replies: 1
Views: 3204

Re: Budget Demo

Have you checked the IBM web site? I think they have links there for youtube videos.
by jim wood
Wed Sep 29, 2021 1:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA & CA on the Same Box
Replies: 1
Views: 1372

PA & CA on the Same Box

Hey Guys,

Has anybody had any success with installing PA and CA on the same box? We currently have CA running on the web server using IIS. I'm worried about installing PA on the same box due to possible conflicts etc,

Jim.

PS. The server is Server 2016.
by jim wood
Mon Sep 20, 2021 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Starting a process from Azure Data Factory (Was TM1py 1.6)
Replies: 1
Views: 1807

Re:Starting a process from Azure Data Factory (Was TM1py 1.6)

mlorini wrote:
Thu Sep 16, 2021 3:24 pm
Does someone has an idea how to start a TM1 Process or Chore from Azure Data Factory?

Thanks
This isn't really the right place for a question like. I would ask it in the main forum.
by jim wood
Mon Jul 12, 2021 2:53 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

I agree about Jorginho. Everybody is complaining about Chiellini pulling back Saka, but he had no choice, he couldn't just let him go. But in all honesty, I think Italy deserved it purely because England didn't play well enough to deserve it. Italy weren't great either btw, in fact I thought it was ...
by jim wood
Tue Jul 06, 2021 6:59 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

You should watch the COPA America, they take this play acting to the next level. It is virtually unwatchable, except for the odd moment of genius. One way I would deal with time wasting and players feigning injury (which is endemic), bring in a rule that says if a player requires a trainer to come ...
by jim wood
Sun Jul 04, 2021 2:58 am
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

Well played by Italy, highest chances of becoming champions. The last 20 minutes were a disgrace though. So much commedia dell’arte… and this team does not need that. We were close a couple of times but interesting game and tough opponents. Wim, I place it squarely at the feet of the ref. He only a...
by jim wood
Fri Jul 02, 2021 3:21 am
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

I've been waiting for money to make the game go boom for a while. Keep in mind that the premier league has most out there. Yet the leagues seem to keep on going and doing well. The appetite for the premier league over here grows every year. It's watched by a lot of people now. It has the advantage o...
by jim wood
Thu Jul 01, 2021 4:41 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

Italy in the group games played with freedom and looked very good. Against Austria they reverted to type, trying not too lose. If they do that again I think they will go out. The game has moved on a lot over the past few years, high press etc has made sitting back and defending more difficult. It's ...
by jim wood
Thu Jul 01, 2021 4:05 am
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

Indeed we do. To be fair I don't think we were that good, but neither were Germany and they fluffed their chances, we didn't.
by jim wood
Tue Jun 29, 2021 2:37 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26031

Re: Belgium - Italy

Franz: "It's a game where 22 men run around for an hour kicking a white ball and then Germany wins." We are really hoping to buck that trend tonight! Roll on Italy or Belgium in the final! I think that depends on which Germany turns up. If the one that played Portugal arrives at Wembley we're done....
by jim wood
Sat May 29, 2021 12:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric to string
Replies: 2
Views: 1726

Re: Numeric to string

Agreed. TM1 stores numbers differently than in a DB (especially the number of decimal places etc) so doing the change on the query side is by far the safest option.
by jim wood
Tue May 18, 2021 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UseSSL
Replies: 5
Views: 2601

Re: UseSSL

We have recently enabled SSL and the rest api code we've been using for a while no longer works, so there's some weird stuff happening and we are still looking at it.
by jim wood
Mon May 10, 2021 9:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Read Error
Replies: 5
Views: 3901

Re: ODBC Read Error

We often turning on or off the Unicode option will get stubborn TI SQL working, though I don't think the preview would work either, worth a double check though. Thanks Steve. I gave it go, but no dice. I'm pretty sure this is something that's being blocked by Azure. The Azure support team are looki...
by jim wood
Mon May 10, 2021 9:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Read Error
Replies: 5
Views: 3901

Re: ODBC Read Error

I added

Code: Select all

UseSQLExtendedFetch=T
to the CFG file but the server log isn't telling me anything more than it was before.
by jim wood
Mon May 10, 2021 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Read Error
Replies: 5
Views: 3901

Re: ODBC Read Error

Many thanks and no I haven't, but I will now. We think it's a communication issue in in Azure rather a software issue that will help.
by jim wood
Fri May 07, 2021 7:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Read Error
Replies: 5
Views: 3901

ODBC Read Error

Guys, I'm testing 2.0.9.2 and I'm getting an ODBC error when I run a process. The process retrieves data from the DB in the preview pane but when I execute it the process runs successfully but when I check the log I see that the server is reporting tm1.sqlapi read error and no data is updated in the...
by jim wood
Mon Apr 05, 2021 3:17 am
Forum: OLAP Jobs
Topic: Planning Analytics Developer - University of Liverpool
Replies: 1
Views: 12549

Re: Planning Analytics Developer - University of Liverpool

If only this came up 10 years ago. :D
by jim wood
Sun Mar 07, 2021 5:46 am
Forum: General
Topic: About Forum Ranks And Voting
Replies: 31
Views: 82596

Re: About Forum Ranks And Voting

Congratulations guys!!
by jim wood
Thu Mar 04, 2021 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )
Replies: 19
Views: 6054

Re: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )

...that is until we found out that you don't need a Workspace license to install it if you're only using it for PAx. After all certain CA licenses come with PAx licenses built in, so how else would you be able leverage it? The other caveat is that Workspace license is only required for end users. A...
by jim wood
Tue Mar 02, 2021 3:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )
Replies: 19
Views: 6054

Re: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )

The client I'm working at recently upgraded from 10.2.2 to PA 2.0.7. (BTW avoid 2.0.7 there's a server side bug that caused random crashes for us so we had to move to 2.0.9) We did not install Workspace at all. We are continuing (for now) to use both TM1 Web and Perspectives. But you do need to keep...