Search found 801 matches

by paulsimon
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 ...
by paulsimon
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...
by paulsimon
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"))...
by paulsimon
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...
by paulsimon
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
by paulsimon
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...
by paulsimon
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...
by paulsimon
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
by paulsimon
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...
by paulsimon
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...
by paulsimon
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...
by paulsimon
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
by paulsimon
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...
by paulsimon
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 { } ...
by paulsimon
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...
by paulsimon
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...
by paulsimon
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 ...
by paulsimon
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...
by paulsimon
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...
by paulsimon
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...