Search found 14 matches

by Jan
Thu Oct 21, 2010 8:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Maintain consolidations
Replies: 2
Views: 2572

Maintain consolidations

Hello, Isn't there a possibility to let the users maintain their consolidations to certain dimensions? At the moment the only way is to give them admin access which means they can delete and messup everything, that is why until now, I am the only one who maintains the consolidations, I get mails eve...
by Jan
Fri Apr 16, 2010 1:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA Function p_ExecuteTM1process
Replies: 3
Views: 4108

VBA Function p_ExecuteTM1process

Hello, I've written a VB function that executes a TM1 process with a given name 'tm1process' , specified parameters 'parameters' (is an array), loginname 'login', password 'password'. The function also expects that the following constant variables to be defined: Public Const c_ServerName = "INS...
by Jan
Mon Apr 12, 2010 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to call relative proportional spread function by Macro!
Replies: 8
Views: 8384

Re: How to call relative proportional spread function by Macro!

I have the same question: is it possible to automate relative proportional spreading through API calls?
by Jan
Mon Mar 08, 2010 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 API Execute process
Replies: 1
Views: 3066

TM1 API Execute process

Hello, I've written a procedure in VB that uses the TM1 API calls to execute a process. This works perfectly, I can even detect if the process returns an error. I get a message from TM1, which I put in a message box, that TM1 executed the process but generated a logfile. Now my question is: Can I sh...
by Jan
Fri Feb 12, 2010 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 32bit
Replies: 2
Views: 2515

TM1 32bit

Hello,

A simple question: Is it possible to use more then 4GB RAM with TM1 on a Win 64bit server system running TM1 32bit?
Or do we also need to upgrade to TM1 64bit?

Thanx
by Jan
Thu Dec 10, 2009 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders between 2 cubes
Replies: 4
Views: 3504

Re: Feeders between 2 cubes

How are your 2 statements structured? I would think you could just do something like this for the feeder statement: [common dimension 1, common dimension 2] => DB(cube,!dim1, !dim2, ... !dim13); I don't understand your feeder. I don't need to specify my common dimension 1 and common dimension 2 in ...
by Jan
Wed Dec 09, 2009 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders between 2 cubes
Replies: 4
Views: 3504

Feeders between 2 cubes

Hello, I got 2 cubes, one cube (A) with 13 dimensions and 1 cube (B) with 5 dimensions. They both have 2 dimensions in common + the data dimension. Now what I want to do is show the data of cube B in cube A. I can see the data fine with the rules I have written in cube A but I've got a problem to fe...
by Jan
Thu Nov 19, 2009 11:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.5
Replies: 16
Views: 12528

Re: TM1 9.5

I can't read anything about the new feautures compared to 9.4 :(
by Jan
Thu Nov 19, 2009 10:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server locked, notify users?
Replies: 10
Views: 11287

Re: TM1 server locked, notify users?

1 question though, about this parameter.
What if a process executing time exceeds (in this case) the 20 seconds. Will the server also terminate the connection therefore killing the process?
by Jan
Thu Nov 19, 2009 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server locked, notify users?
Replies: 10
Views: 11287

Re: TM1 server locked, notify users?

I didn't know about the parameter. I will certainly try this. thanx!
by Jan
Thu Nov 19, 2009 8:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server locked, notify users?
Replies: 10
Views: 11287

Re: TM1 server locked, notify users?

Hello, The locks are mainly caused by TI processes (I will look into the functions you told me to reduce the locking time), we can estimate the time each process will take so that's no problem because they run few times a week. And the second cause is, the users (I don't what they do to cause this, ...
by Jan
Wed Nov 18, 2009 3:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server locked, notify users?
Replies: 10
Views: 11287

Re: TM1 server locked, notify users?

Hello, Every time someone locks the server, every connected tm1 user 'hangs' in excel until the lock is released. Only us administrators can see what's happening (by using tm1top). Can we notify all connected users how long the lock will take? How can we kill the thread to force the server to relea...
by Jan
Tue Nov 17, 2009 1:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server locked, notify users?
Replies: 10
Views: 11287

Re: TM1 server locked, notify users?

Maybe it's a good thing to say that I am using the 9.0 SP2 version.
Is this different in 9.4?
by Jan
Tue Nov 17, 2009 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server locked, notify users?
Replies: 10
Views: 11287

TM1 server locked, notify users?

Hello, Every time someone locks the server, every connected tm1 user 'hangs' in excel until the lock is released. Only us administrators can see what's happening (by using tm1top). Can we notify all connected users how long the lock will take? How can we kill the thread to force the server to releas...