Search found 3807 matches

by Alan Kirk
Wed Nov 12, 2008 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connection options to SAP
Replies: 10
Views: 6721

Re: Connection options to SAP

I have connected driectly in the past with other tools. Regardless of what SAP think, the main issue is that all the table names are in German. And when you generate an Excel report, the module names come out in German as well. It was somewhat disorienting to see the ThisWorkbook object come out as...
by Alan Kirk
Wed Nov 12, 2008 9:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enforced Password Changes
Replies: 10
Views: 7972

Re: Enforced Password Changes

John Hobson wrote:
You'll be complaining about undo spread next.
Oi! :x
I wouldn't worry about me getting in on your act. There are only 144 days until Daylight Savings ends.

I'm marking the calendar and sharpening my scythe even as we speak.... :twisted:
by Alan Kirk
Wed Nov 12, 2008 4:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA Code to double click
Replies: 6
Views: 5554

Re: VBA Code to double click

Hi Alan I think that in this case the reluctance is more to do with the move to Unicode; go forward, and there's no going back since the database files are no longer backward-compatible. Also my understanding is that the Unicode format will be more demanding on system resources, so it's best not to...
by Alan Kirk
Tue Nov 11, 2008 11:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enforced Password Changes
Replies: 10
Views: 7972

Enforced Password Changes

I just got a request from the higher ups. I notice in TM1 there is no requirement for Password change after a required period ? Is that possible to set up in TM1. It is normal practice in the Network systems Hmmm. How do I diplomatically respond "Hey, yeah, we've been asking for that for years ...
by Alan Kirk
Tue Nov 11, 2008 5:39 am
Forum: General
Topic: Junk mail
Replies: 12
Views: 9403

Re: Junk mail

Now if I could get my hands on a Bird of Prey, on the other hand... hmm, where to first? Rome? Vancouver? One of those legendary Southern En-gur-land TM1 User Group booze-ups? :? If your going to the TM1 User Booze up pick me up. I promise the speedo stays in Chicago! :lol: Speaking of which, tell ...
by Alan Kirk
Tue Nov 11, 2008 12:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA Code to double click
Replies: 6
Views: 5554

Re: VBA Code to double click

If you really need this functionality (and I can see why you would) then I would recommend upgrading to 9.4 for Active Forms. I haven't used 9.4 in anger but so far I haven't noticed that it is any less stable than 9.1. Unfortunately many people prefer to wait until at least the first Service Pack ...
by Alan Kirk
Mon Nov 10, 2008 8:01 pm
Forum: General
Topic: Cognos Communities
Replies: 7
Views: 6699

Re: Cognos Communities

Not that anyone cares, but is the Cognos site down? I tried logging in today and over the weekend and got nothing. I suppose it is another win for OLAP Forums, at least the site is never down. Oh gods, don't jinx us by saying that... However CC seems to be up now, for certain values of up. Which is...
by Alan Kirk
Sat Nov 08, 2008 11:06 am
Forum: Commercial and Events
Topic: TM1 User Group - Sydney
Replies: 6
Views: 9535

Re: TM1 User Group - Sydney

rossi wrote:All the information is on the website Alan.
The times are now... they weren't at the time that I posted. There are still none of the details that Martin suggested, though.
by Alan Kirk
Fri Nov 07, 2008 11:39 pm
Forum: General
Topic: Junk mail
Replies: 12
Views: 9403

Re: Junk mail

Mr Kirk stole a Klingon bord of pray, flew round the sun, landed in Illinois and created some TM1 junk filters before flying round the sun again back to OZ. A "bord of pray"? I thought that was Sarah Palin's education policy. Oh wait, wrong thread. :lol: Now if I could get my hands on a B...
by Alan Kirk
Thu Nov 06, 2008 2:07 am
Forum: General
Topic: Junk mail
Replies: 12
Views: 9403

Re: Junk mail

I've just had some junk mail from BS Partners (that’s Bright Star not any other amusing BS acronyms, I can think of two that could be appropriate) an Illinois based cognos consultancy. Anyone else had a mail from them? Just wondering where they got my address from and if Im just lucky! Illinois, ...
by Alan Kirk
Thu Nov 06, 2008 12:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Worksheet Function
Replies: 13
Views: 8534

Re: Dimension Worksheet Function

Maybe I should ask a different question. What is the best way to audit your DIM so you can clean out the garbage DIMs you are no longer using? I was going to exract a list and then bounce each one off every cube. I don't know if this is the BEST way (indeed it probably isn't), but this is a little ...
by Alan Kirk
Thu Nov 06, 2008 12:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Worksheet Function
Replies: 13
Views: 8534

Re: Dimension Worksheet Function

Hi Eric, In the old TM1 recommended practices look up "Documenting_Dimension_Usage_by_Cube" - both TI and rules approaches are explained. To improve on things a little I would recommend rather than using the control dims in the audit cube creating a replica of }Cubes and }Dimensions with ...
by Alan Kirk
Wed Nov 05, 2008 6:40 pm
Forum: Commercial and Events
Topic: TM1 User Group - Sydney
Replies: 6
Views: 9535

Re: TM1 User Group - Sydney

Hence the reason for saying to go to the website for further information. {Snip} From 3pm Hence the reason for me saying "you haven't got the information THERE" in reference to your web site, which didn't and still doesn't (at the time of posting) contain the time. However I see that it's...
by Alan Kirk
Wed Nov 05, 2008 4:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Trigger for Control Objects to Update
Replies: 4
Views: 3438

Re: Trigger for Control Objects to Update

Here is the situation. I placed holds on a cube that did not have any holds before. As you all know this creates a new cube }Hold_User_Cube. I wanted to see how much memory the holds were requiring. So I went into }StatsbyCube to take a look, but the element }Hold_User_Cube did not exist. I disconn...
by Alan Kirk
Wed Nov 05, 2008 12:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Trigger for Control Objects to Update
Replies: 4
Views: 3438

Re: Trigger for Control Objects to Update

Here is the situation. I placed holds on a cube that did not have any holds before. As you all know this creates a new cube }Hold_User_Cube. I wanted to see how much memory the holds were requiring. So I went into }StatsbyCube to take a look, but the element }Hold_User_Cube did not exist. I disconn...
by Alan Kirk
Tue Nov 04, 2008 10:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Re-Customising (Customizing) Web after an Upgrade
Replies: 5
Views: 6456

Re: Re-Customising (Customizing) Web after an Upgrade

Yesterday afternoon I installed 9.1 SP4 (replacing 9.1 SP3) as our web server. (Interestingly, for reasons best known to itself, Iboglix still hasn't put SP4 on the downloads page; you can still only get it from the FTP server.) I take it back; it wasn't there yesterday (I had to pull it from the F...
by Alan Kirk
Tue Nov 04, 2008 9:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Re-Customising (Customizing) Web after an Upgrade
Replies: 5
Views: 6456

Re-Customising (Customizing) Web after an Upgrade

Yesterday afternoon I installed 9.1 SP4 (replacing 9.1 SP3) as our web server. (Interestingly, for reasons best known to itself, Iboglix still hasn't put SP4 on the downloads page; you can still only get it from the FTP server.) The upgrade package itself ran flawlessly and easily (after I manually ...
by Alan Kirk
Tue Nov 04, 2008 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube Maitrix
Replies: 2
Views: 2852

Re: TM1 Cube Maitrix

I am new for TM1 and I am struggling to do the following. Project Date Cube Dimensions: Project Measure: Launch Date Project Lease Rate Spread Dimensions: Project Period (Month1, Month2, Month3....) Measure: Percentage Project Lease Spread Dimensions: Project Year Month Measure Percentage The end u...
by Alan Kirk
Mon Nov 03, 2008 9:48 pm
Forum: Commercial and Events
Topic: TM1 User Group - Sydney
Replies: 6
Views: 9535

Re: TM1 User Group - Sydney

Olivier wrote: Just to inform you that iCOMP will be hosting the November TM1 User Group Forum on November 26 here in Sydney.

More details and registration information is on our website
You've got the location there, but not the time or agenda...
by Alan Kirk
Mon Nov 03, 2008 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Worksheet Function
Replies: 13
Views: 8534

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.
Paul Segal wrote:=DIMNM(Dimension, Index, Alias) will return the company name.
Paul, I think you're thinking of an element name rather than a dimension name.