Search found 2306 matches

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

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

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

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

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

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

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

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

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...
by jim wood
Thu Feb 11, 2021 3:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 922

Re: PA Cloud Optimization

Many thanks. We're looking to move the TM1 services to the cloud over the next couple of weeks. I'll also ask our CA guys to have a look at the data sources. I think we're on PA but I'm not 100% certain,

Jim.
by jim wood
Wed Feb 10, 2021 11:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 922

Re: PA Cloud Optimization

Try switching to native logon. If that works better you know its a CAM issue. I will on a non prod server and see if it makes a difference. Is it a windows server or linux? It's windows for all of them. Are you using IIS? Yes IIS is being used for both CA and CAM Are you using SSL? If so for which ...
by jim wood
Fri Feb 05, 2021 4:54 pm
Forum: Useful code, tips and tricks
Topic: CEILING and FLOOR functions
Replies: 2
Views: 1145

Re: CEILING and FLOOR functions

You should put this in the useful code section of the site. It's very useful and in the main forum it will get moved down quickly. Let me know if you'd like it moved over there?

Jim.
by jim wood
Mon Feb 01, 2021 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 922

Re: PA Cloud Optimization

Hey Paul, We are using CAM and it is located on the same server as both CA and TM1 Web. We have noticed some slow down with templates but that has been less consistent than the subset, so we've put that down to the pipe width which we have just increased. I will look to do the test with STET. The pr...
by jim wood
Mon Feb 01, 2021 9:04 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.6
Replies: 6
Views: 1711

Re: TM1py 1.6

Slightly harsh, Jim. If we were talking about arc or pulse then fair enough, but tm1py seems to me to be the epitome of open source and non-commercial. Regards I hear you, but we try to keep product releases (open source or otherwise) out of the main forum as things start to get very shaky very qui...
by jim wood
Mon Feb 01, 2021 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 922

Re: PA Cloud Optimization

Hey Paul, Thanks for getting back to me so quickly. All is well at our end just a little bit snowy today. We've about 1 1/2 foot of the stuff today so far and it ain't going to stop snowing until tomorrow. So I may be living in a igloo by this time tomorrow :) I hope all is well at your end? As for ...
by jim wood
Mon Feb 01, 2021 8:33 pm
Forum: Free And Open Source Tools
Topic: TM1py 1.6
Replies: 6
Views: 1711

Re: TM1py 1.6

Post moved. Please read the forum guidelines for commercial related posts like this going forward.
by jim wood
Mon Feb 01, 2021 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cloud Optimization
Replies: 8
Views: 922

PA Cloud Optimization

Guys, We are running PA 2.0.7 and CA 11.1.4. We're seeing really slow performance when running a report / view containing one of our larger dimensions. The dimension has roughly 4000 members. In the cube viewer when opening the subset in TM1 Web it takes a couple of minutes to come back. When openin...
by jim wood
Mon Feb 01, 2021 4:22 am
Forum: General
Topic: Hey US, hey UK, do you even(ever?) hire overseas?
Replies: 2
Views: 1481

Re: Hey US, hey UK, do you even(ever?) hire overseas?

I took a job in the US (10 years ago) and had to got through the process. Unless you are transferring within a company you have to go through the H1B process. Over the last few years this has become harder as there is such demand for them from IT workers in India. There are only 64k issued per year ...
by jim wood
Mon Jan 04, 2021 10:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel =SUBNM Limitations
Replies: 2
Views: 613

Re: Excel =SUBNM Limitations

If you're combining the SubNM with other large amounts of formulas you may hit some performance issues down to just volume. I've only ever tried doing this kind of thing with old web forms rather than the newer stuff though.
by jim wood
Thu Dec 31, 2020 4:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about the dependency between Metadata and Data
Replies: 3
Views: 704

Re: Question about the dependency between Metadata and Data

I think this should be pinned for a short while. The way tabs work is something fundamental to TI and there are plenty of people out that may not understand it fully, Especially how dimension inserts work on a ghost copy etc.
by jim wood
Sun Dec 27, 2020 5:25 am
Forum: General
Topic: For anyone who has been depressed by the train wreck that was 2020...
Replies: 4
Views: 1874

Re: For anyone who has been depressed by the train wreck that was 2020...

Merry Christmas everybody and fingers crossed for a better new year....