Search found 2322 matches

by jim wood
Mon Feb 28, 2022 1:58 pm
Forum: Commercial and Events
Topic: Server Build for Home
Replies: 0
Views: 1261

Server Build for Home

Guys, If you've ever wanted to build a decent server for working on projects at home (I know you could do it on the cloud but where the fun in that?) I've put together a video on how I did it. With a total cost of 800 USD it wasn't very expensive at all for 16 cores and 32 threads and 64GB of RAM wi...
by jim wood
Mon Feb 21, 2022 4:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler
Replies: 3
Views: 637

Re: Performance Modeler

Are you on an older version of the software? I was asking as I didn't think anybody still used Performance Modeler?
by jim wood
Mon Jan 24, 2022 4:26 pm
Forum: Useful code, tips and tricks
Topic: Picklist overview in a TM1 model
Replies: 3
Views: 12710

Re: Picklist overview in a TM1 model

Excellent thanks Wim.
by jim wood
Tue Nov 02, 2021 12:40 pm
Forum: General
Topic: Budget Demo
Replies: 1
Views: 36536

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

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

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

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

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

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

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

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

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

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 w...
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: 2725

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: 6
Views: 19019

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

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

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

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

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...