Search found 2215 matches

by jim wood
Tue Mar 12, 2019 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO connection from 10.2.2 instance to PA instance
Replies: 1
Views: 475

Re: ODBO connection from 10.2.2 instance to PA instance

I'm not sure of the ins and outs of this (not sure if it's even possible) but my first inclination would be to overlay the ODBO drivers on the 10.2.2 machine with the ones from the PA machine, taking a backup first of course. I can only guess that the 10.2.2 drivers are not able resolve the connecti...
by jim wood
Mon Mar 11, 2019 11:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Forecasting & Budgeting
Replies: 3
Views: 663

Re: Forecasting & Budgeting

Moved to the correct forum. I'll get my tin hat ready for when Tomok sees this!!
by jim wood
Wed Feb 27, 2019 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Failure
Replies: 2
Views: 126

Re: ODBCOutput Failure

Thanks Tom, that's a nice suggestion. I have a system process for executing store procedures so that's something I could instead of building the code with the prolog,

Jim.
by jim wood
Wed Feb 27, 2019 7:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Failure
Replies: 2
Views: 126

ODBCOutput Failure

Guys, As far as I can tell (and experienced in the past) ODBCOutput does not return any kind of error code when executing a query. The IBM documentation only mentions the 255 character limit. I plan on writing a sub process to validate the DB after the query has executed but if there's a better way ...
by jim wood
Mon Feb 25, 2019 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 web report issue
Replies: 3
Views: 412

Re: Tm1 web report issue

Moved to the correct forum.
by jim wood
Wed Feb 20, 2019 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Edit TI Process without first Executing it?
Replies: 16
Views: 2440

Re: How to Edit TI Process without first Executing it?

Or even have the source as a flat file with correct number of fields in it. Then override. That way you can amend your file to match without executing a query at all. You can specify the query in the process.
by jim wood
Wed Feb 20, 2019 4:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Edit TI Process without first Executing it?
Replies: 16
Views: 2440

Re: How to Edit TI Process without first Executing it?

Why not just point to an ODBC that doesn't exist. That way when the process opens the query fails. The using parameters or a lookup simply overwrite the ODBC data source. That doesn't involve any code as you should be including a lookup for the ODBC anyway to make deployment easier. With the above, ...
by jim wood
Tue Feb 05, 2019 5:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 275

Re: Ascii Quote Fun and Games

Wim Gielis wrote:
Tue Feb 05, 2019 4:39 pm
I have seen strange cases in the past with extended Ascii characters and try to stay away from there.
Which includes French accents like é, è, ê too. Not sure if this is still an issue nowadays, I am talking about some 5 years ago.
We're still on 10.2.2 so it may have been fixed since.
by jim wood
Tue Feb 05, 2019 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 275

Re: Ascii Quote Fun and Games

It was 100% because I was using an extended Ascii character 0186. Once I lowered it to character 94 everything worked as expected. It's interesting that the process itself recognized the extended character but the data tab part of the process did not,

Jim.
by jim wood
Tue Feb 05, 2019 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 275

Re: Ascii Quote Fun and Games

Looks like it may have something to do with the extended Ascii character set. Looking at something else and will post back.
by jim wood
Tue Feb 05, 2019 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 275

Ascii Quote Fun and Games

Guys, I'm trying to move awkward data between cubes and this includes free comment fields. The fields contain all kinds of crap so I can't use the usual delimiters as I'm exporting it to file first. I have therefore gone for the Ascii quote character set as Char(186) which then looks like this: Quot...
by jim wood
Tue Jan 29, 2019 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 42
Views: 4739

Re: Planning Analytics using twice the memory of 10.1

I'm guessing the css change is only going to be available to on-premise installations? We're going PA on the cloud this year and I would love to be able to alter the stylings for TM1web after we migrate. I can't see IBM giving you that level of access. May be on the partner cloud but not commercial...
by jim wood
Wed Jan 23, 2019 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Loss Due To MTFeeders
Replies: 5
Views: 226

Re: Data Loss Due To MTFeeders

The page says 27th November 2018 so it's not that old, or that new either.
by jim wood
Wed Jan 23, 2019 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use PAW
Replies: 4
Views: 360

Re: How to use PAW

PlanningDev wrote:
Tue Jan 22, 2019 6:58 pm
IBM Business Analytics Youtube Page
https://www.youtube.com/channel/UCS3gkk ... shelf_id=6

Under Planning Analytics Workspace there are currently 33 videos
Thanks. YouTube is blocked when I'm in the office so I couldn't link anything,

Jim.
by jim wood
Tue Jan 22, 2019 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use PAW
Replies: 4
Views: 360

Re: How to use PAW

As a starting I would look on you tube. Some of the IBM partners have put together PAW introduction videos. They should at least give you a start. Also IBM / any partner should be able to line up training for you,

Jim.
by jim wood
Fri Jan 11, 2019 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 14
Views: 850

Re: TM1 Certifications

It's an online test Jim and therefore available to anyone worldwide. Would you, good sir, be interested in testing your mettle? For free??? :) Only kidding. If it's full of PA questions I'd be done for. The client I'm on has been stuck on version 10 for a while, heck we only upgraded to 10.2.2 as s...
by jim wood
Fri Jan 11, 2019 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 14
Views: 850

Re: TM1 Certifications

I should mention one other relatively recent development in this field too given my great admiration and esteem for the official IBM certifications. Cubewise has partnered with Deakin University in Australia to create a credential that might, well, actually mean something. It's not free but as I un...
by jim wood
Fri Jan 11, 2019 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 381

Re: Old TM1 version

Alan Kirk wrote:
Thu Jan 10, 2019 6:44 pm
Or built into Lotus 1-2-3. There was a time when Excel support was New! And! Exciting!
I forgot all about Lotus. I used to love Lotus. With the power keys you could do everything without touching a mouse it was awesome!!