Search found 3807 matches

by Alan Kirk
Mon Nov 03, 2008 6:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Worksheet Function
Replies: 13
Views: 8505

Re: Dimension Worksheet Function

Eric wrote:I thought there was a function where I could reference an dimension index numbers and I would be able to retrieve the dimension name. Maybe because it is monday, but I can't seem to find it.
Are you thinking of TabDim, perhaps?
by Alan Kirk
Mon Nov 03, 2008 8:49 am
Forum: General
Topic: Memo to Microsoft: More info, less screen space
Replies: 6
Views: 5801

Re: Memo to Microsoft: More info, less screen space

It looks like windows 7 is another operating system that I will avoid like the plague. Long live windows XP I say. I'm not far removed from that sentiment. I'm sure we'll need to move on eventually, but I'm in no hurry. Windows 7 does have (what sound like at least) a couple of decent features: Mic...
by Alan Kirk
Sun Nov 02, 2008 9:59 pm
Forum: General
Topic: Memo to Microsoft: More info, less screen space
Replies: 6
Views: 5801

Memo to Microsoft: More info, less screen space

What is WRONG with those bozos in Seattle these days? http://www.smh.com.au/news/digital-life/laptops/articles/microsoft-unveils-windows-7-features/2008/10/29/1224956098192.html Check out the screenshot of Windows Explorer. Not only have the Fisher-Price icons survived... they seem to have EXPANDED....
by Alan Kirk
Thu Oct 30, 2008 3:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Moving an application to a new environment
Replies: 4
Views: 3676

Re: Moving an application to a new environment

So, it's a matter of having a new folder under Custom, with the appropriate change to the tm1s.cfg file to point to the correct directory, then pointing a TM1 Server install to that custom location? Yes, there's not much more to it than that. You may also have to change the path to your log file di...
by Alan Kirk
Wed Oct 29, 2008 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web - File does not exist
Replies: 5
Views: 5366

Re: TM1Web - File does not exist

Hi I have an Excel file as an application in my TM1 server. I access the file with no problem from the Architect and Perspectives. Then when I go to TM1 web and try to open it then get the error: "File does not exist: ...." Any comments?? This will commonly happen in the following circums...
by Alan Kirk
Tue Oct 28, 2008 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In-Spreadsheet Browser
Replies: 3
Views: 4100

Re: In-Spreadsheet Browser

I noticed in one of Alan's posts that Cognos are planning to kill of the ISB after release 9.4. Is that confirmed? I know that Applix/Cognos have been trying to kill off the ISB for years, but everytime they ask if anyone still uses it, they get lots of replies. I am surprised, since they exposed a...
by Alan Kirk
Wed Oct 22, 2008 2:58 am
Forum: Enhancements
Topic: No Server Abort on a Disk Failure?
Replies: 1
Views: 4103

No Server Abort on a Disk Failure?

This is an infrequent issue, but it bit me this morning. We have a number of "one off" (unscheduled) chores which populate a scenario for weekly reporting. These chores are not logged because there's far too much data. The intention is that they create a "snapshot" of the numbers...
by Alan Kirk
Wed Oct 22, 2008 12:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.1 on MS Terminal Server
Replies: 4
Views: 3941

Re: TM1 9.1 on MS Terminal Server

If the remote user and the host are not running the same windows version then shared resources like the clipboard can be a little dodgy Buh? Can you elaborate on that, Mike? I'd have thought that they'd ALWAYS be running different versions given that the TS server would typically be some flavour of...
by Alan Kirk
Tue Oct 21, 2008 11:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ditch the Save button?
Replies: 12
Views: 6712

Re: Ditch the Save button?

A couple of posters have said the the Save button is annoying. I've clicked it a couple of times myself and had to go digging for my post. I've also used it usefully for a long post to ensure I didn't lose it if I kicked the plug out of the wall, but it would've been no problem to use Notepad then ...
by Alan Kirk
Tue Oct 21, 2008 11:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Who remember the good old times...
Replies: 6
Views: 5181

Re: Who remember the good old times...

The picture is of the version 2 box, which was used for releases 2.0 through 2.5.F. Ah, but which YEAR(s)? That seems to be the big mystery. I notice that Bob didn't post the answer; maybe he's been kidnapped by Iboglix agents to keep him silent on that point. :D "To run TM/1 Perspectives, you...
by Alan Kirk
Tue Oct 21, 2008 10:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Possible Bug - TI Fails to Read Dynamic Subset
Replies: 5
Views: 3659

Re: Possible Bug - TI Fails to Read Dynamic Subset

I can't reproduce this in 9.4 (original release). Unfortunately Tuesday's my busy day and I wasn't able to test it on 9.1 SP3 (haven't installed SP4 yet) nor 8.2.12, though I doubt you'll be interested in the last one anyway. Will let you know what I encounter in 9.1, No problem in 8.2.12 or 9.1 SP...
by Alan Kirk
Tue Oct 21, 2008 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Possible Bug - TI Fails to Read Dynamic Subset
Replies: 5
Views: 3659

Re: Possible Bug - TI Fails to Read Dynamic Subset

Not sure if this is specific to my version or not. Would be interesting if someone could test on a later version before i submit another bug report to Cognos ;) TM1 9.0.3 182 U7 running on Win Server 2003 Standard I have a TI which is based on a dynamic subset of the employees dimension. The subset...
by Alan Kirk
Mon Oct 20, 2008 12:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publishing Data from TM1 to an ODBC source
Replies: 13
Views: 17739

Re: Publishing Data from TM1 to an ODBC source

If you are referencing variable the must be enclosed in % Exmaple ODBCOutPut( ‘TransData’, Expand( 'INSERT INTO SALES ( MONTH, PRODUCT, SALES ) VALUES ( "%V0%", "%V1%",%V2% )' ) ); Chris, Eric's syntax should work except for one little thing; Access likes square brackets aro...
by Alan Kirk
Sun Oct 19, 2008 9:13 pm
Forum: Bugs
Topic: 11-81357561 TM1 9.4 - Transaction log returns only 100 rows
Replies: 2
Views: 5448

Re: 11-81357561 TM1 9.4 - Transaction log returns only 100 rows

In previous versions the View Transaction Logs dialog appears to buffer 100 rows of entries at a time. When you page down or arrow down and hit the end of the current "frame" of entries, a further 100 entries will be loaded. This will apparently be fixed in 9.4MR1 (apparently MR is the ne...
by Alan Kirk
Sun Oct 19, 2008 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: While statements in TI process
Replies: 17
Views: 26439

Re: While statements in TI process

Nice use of the function. My guess as to why no one suugested it, is that NUMBERTOSTRINGEX is a fairly recent addition to the TI function set? Not sure, anyway I'll certainly be using it, it's a neat way around a problem I hit many times. It dates back to 8.2, but doesn't appear even in the 8.2.12 ...
by Alan Kirk
Fri Oct 17, 2008 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Publishing Data from TM1 to an ODBC source
Replies: 13
Views: 17739

Re: Publishing Data from TM1 to an ODBC source

If you talk to a data engine which has security then you need to put a password in the ODBCOpen - and it's not encrypted - yecchh. Yes, that was an issue with processes which had an ODBC data source as well up until somewhere around one of the late 8.3's or 8.4, from memory. It was stored in the .p...
by Alan Kirk
Fri Oct 17, 2008 2:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.1 on MS Terminal Server
Replies: 4
Views: 3941

Re: TM1 9.1 on MS Terminal Server

Hi, Instead of Citrix, we are looking at implementing TM1 client using MS Terminal services due to low number of remote users. Is there anything we should watch out for on the TS or TM1 setup? Thanks in advance for any suggestion or tips from those who has the same setup. We used to use Terminal Se...
by Alan Kirk
Thu Oct 16, 2008 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.4 Hotfix 3
Replies: 4
Views: 3569

9.4 Hotfix 3

I just posted that 9.4 Hotfix 3 fixed the "flickers through the worksheets on opening" problem, but just for reference the other fixed in HF3 are: - TM-6340: Unable to print reports after upgrading to 9.4 - TM-6262: Chores disappear after modifying activation time - TM-6052: Snapshot is no...
by Alan Kirk
Thu Oct 16, 2008 11:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button - Jump through sheets on WB open
Replies: 6
Views: 5236

Re: Re:Jump through sheets on WB open - without action buttons!

I have just upgraded to Ver 9.4 ( demo machine only!) and I get this behaviour in workbooks without actions buttons. In fact workbooks with nothing but empty sheets in! However, it doen't happen unless I am logged in to a TM1 server. I have reported it to Cognos and it has been recognised as a prob...
by Alan Kirk
Thu Oct 16, 2008 9:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Connections
Replies: 3
Views: 5073

Re: ODBC Connections

Thanks Alan for a very detailed response..apologies in the lateness of getting back to you. Basically...We are running TM1 9.0 SP3 U7 (64bit Windows). I wish to pull data from a Sage Financials from within a TI job to simply populate some financials into a TM1 cube. I've never used a product like S...