Are you thinking of TabDim, perhaps?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.
Search found 3807 matches
- 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
- 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...
- 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....
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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...
- 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...