Search found 801 matches
- Wed Aug 05, 2009 10:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Replication - worth it ? or not ?
- Replies: 27
- Views: 14203
Re: Replication - worth it ? or not ?
Ajay So far this thread has all been about replication, however, you originally asked about Citrix, as well. We had problems with slow and unpredictable response from users in Italy accessing a TM1 server in London via the TM1 Client. From memory, our network latency was only 100 - much faster than ...
- Sun Jul 26, 2009 11:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA to trigger drill through
- Replies: 8
- Views: 6042
Re: VBA to trigger drill through
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If bCellIsInsideRange(Target, Range("DrillThruPoss")) Then If [b]Not (Application.CommandBars("cell").Controls("Drill").Enabled)[/b] Then MsgBox ("Sorry, you cannot drill down on thi...
- Thu Jul 23, 2009 12:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: VBA to trigger drill through
- Replies: 8
- Views: 6042
Re: VBA to trigger drill through
Hello, Instead of right-click drill through process, is there a way to initiate this drill through process via VBA? Telula, The following does the trick: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If bCellIsInsideRange(Target, Range("DrillThruPoss"))...
- Wed Jul 22, 2009 10:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security and zero suppression on 2 dimensions
- Replies: 3
- Views: 2725
Re: Security and zero suppression on 2 dimensions
Wim - a cost center owner should have read access to only his cost center, but for all projects. None access to other cost centers. - a project owner should have read access to only his project, but for all cost centers. None access to other projects. - a TM1 client can be a CC owner and a Project o...
- Wed Jul 22, 2009 10:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI as a batch processing language with Cognos Datamanager.
- Replies: 6
- Views: 4811
Re: TI as a batch processing language with Cognos Datamanager.
John
To add an image
First add the image file as an attachment to the post. Click the Img button, and with your cursor between the tags, go to the posted attachments and click Place inline.
I tried with a JPG. You will need to try other formats to see if they work too.
Regards
Paul Simon
To add an image
First add the image file as an attachment to the post. Click the Img button, and with your cursor between the tags, go to the posted attachments and click Place inline.
I tried with a JPG. You will need to try other formats to see if they work too.
Regards
Paul Simon
- Wed Jul 22, 2009 8:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can't Figure Out The Feeders
- Replies: 7
- Views: 4374
Re: Can't Figure Out The Feeders
Assuming that ATTRS('Functions',!Functions,'Target') is gives you the Alias for Target, then you could change your Feeder to: ['Target COL'] =>DB('Requirement', !Cycles, !Versions, !Stages, 'Target', !Fiscal Years, !Functions, !Installations, 'Units'); Regards Paul Simon Hey again everyone, I seem t...
- Tue Jul 21, 2009 6:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can't Figure Out The Feeders
- Replies: 7
- Views: 4374
Re: Can't Figure Out The Feeders
Hi I haven't looked at this in detail, but assuming that you only want the Target to appear at the base level, you just need to change your rule to add an N: ['Target'] = N: DB('Requirement', !Cycles, !Versions, !Stages, ATTRS('Functions',!Functions,'Target'), !Fiscal Years, !Functions, !Installatio...
- Tue Jul 21, 2009 6:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI as a batch processing language with Cognos Datamanager.
- Replies: 6
- Views: 4811
Re: TI as a batch processing language with Cognos Datamanager.
John
Yes there is a way to do this. I have built a standard framework for this. However, as this took a lot of development it is proprietary code, so I've dropped you a private message with further details.
Regards
Paul Simon
Yes there is a way to do this. I have built a standard framework for this. However, as this took a lot of development it is proprietary code, so I've dropped you a private message with further details.
Regards
Paul Simon
- Wed Jul 15, 2009 9:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting 9.4 from 9.0
- Replies: 7
- Views: 4470
Re: Getting 9.4 from 9.0
Mauricio Try ftp://testcase.boulder.ibm.com. However, I am not sure if the files are still there. You should contact support to get the particular version that you need put up there. As a further update on this, I finally got a Site ID and an ICN (which I assume is an IBM Customer Number) although I...
- Tue Jul 14, 2009 10:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: .Net requirement for advanced rules editor
- Replies: 7
- Views: 4352
Re: .Net requirement for advanced rules editor
Martin I'm just about to install the lastest Fixed Pack on 9.4, so I may take a look at the 'Advanced' Rules Editor again. However, in 9.1 it: a) It actually made editing rules harder b) It crashed a lot You can disable the advanced rules editor with AdvancedRulesEditor = F in TM1P.INI I still use t...
- Sat Jul 11, 2009 11:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error after upgrading to FP1
- Replies: 16
- Views: 14181
Re: Error after upgrading to FP1
Belair When you open a TI, TM1 always runs the SQL to check that it can still connect, and then it runs it again when you execute the TI. So if your SQL takes a long time to run, the TI process can take a long time to run. There are a few cures for this. In the old days of version 7 we used to go on...
- Sat Jul 11, 2009 11:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Leftfield question re worksheet security
- Replies: 9
- Views: 5225
Re: Leftfield question re worksheet security
Hi Garry
I can't say that I ever use that keyboard shortcut. However, one possible work around might be to use OnKeys to intercept that key stroke and then write some VB to make it do what you want it to do.
Regards
Paul Simon
I can't say that I ever use that keyboard shortcut. However, one possible work around might be to use OnKeys to intercept that key stroke and then write some VB to make it do what you want it to do.
Regards
Paul Simon
- Fri Jul 10, 2009 4:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: String Comparison Error
- Replies: 9
- Views: 5196
Re: String Comparison Error
Hi To correct my own post, I had forgotten that you can only use curly brackets on the left hand side of a rule so [ 'Amount' ] => [ {'Required $', 'Required FTE'} ]; won't work So you need to go with my other suggestion [ 'Amount' ] => [ 'Required $' ] ; [ 'Amount' ] => [ 'Required FTE' ]; or Marti...
- Thu Jul 09, 2009 9:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: String Comparison Error
- Replies: 9
- Views: 5196
Re: String Comparison Error
Hi I am guessing that all the items that you are feeding from are in the same dimension, presumbably your measures dimension? Assuming that I am right (and if not, then please post the structure of your cube), then if you want to feed from more than one thing in the same dimension then you need { } ...
- Wed Jul 08, 2009 9:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Object locking model
- Replies: 24
- Views: 12726
Re: Object locking model
Steve Our experience with 9.1 is that with sizable queries and multiple users, performance does suffer, eg 3 users kick off the same query at the same time. First user gets a result in 10 seconds, second in 20, and third in 40 seconds. If caching were operating I would expect all to be about the sam...
- Wed Jul 08, 2009 8:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting 9.4 from 9.0
- Replies: 7
- Views: 4470
Re: Getting 9.4 from 9.0
Have you read Alan Kirk's post? I haven't been through it you but that might help. Alternatively I would suggest shortcutting the process as I did, and getting 9.4 MR1 from the FTP site and the MR1 FP1 upgrade from the IBM site. That is probably going to be quicker than waiting for a Site Id. Teleph...
- Tue Jul 07, 2009 10:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting 9.4 from 9.0
- Replies: 7
- Views: 4470
Re: Getting 9.4 from 9.0
Hi I hit the same problem. In order to download anything you need a customer number and site id. If you are not the primary contact for IBM at your site, you need to get approval from that person, and in order to ask that approval you need to logon to the IBM site with this site id. The chances are ...
- Thu Jul 02, 2009 11:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Poll on the object locking model in 9.4
- Replies: 11
- Views: 5902
Re: Poll on the object locking model in 9.4
Hi We are using 9.1 in production though we are upgrading to 9.4 soon. I have only worked with 9.4 in development so I cannot vouch for its stability, but it hasn't caused any problems so far. By comparison, we have had a lot of problems with 9.1 If 3 users query the same view I can guarantee that t...
- Thu Jun 25, 2009 10:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 over Terminal Services - Window loses focus
- Replies: 1
- Views: 1632
TM1 over Terminal Services - Window loses focus
Hi We have been getting an intermittent problem when using TM1 over Terminal Services v 6.0.6001.18000. Windows seem to lose focus. Eg users were saying that they needed to press Shift-F9 twice before TM1 would recalc. What was actually happening was that the Excel window was losing focus so the Shi...
- Thu Jun 25, 2009 10:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Assignment of Variable Names
- Replies: 2
- Views: 2407
Re: Dynamic Assignment of Variable Names
Steve A few things occur 1) If you want a tabular report from TM1, is there any reason why you can't use Excel and Print Report/VBA to produce it? 2) As I understand it, your data source is a view, which has a row with an element from each dimension, including the months dimension, with its 200 elem...