Search found 3545 matches

by Alan Kirk
Tue Apr 16, 2019 3:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Trial - Can someone provide me the installation?
Replies: 9
Views: 689

Re: Cognos Express Trial - Can someone provide me the installation?

If you're doing this as genuine evaluation to purchase the software, I'm sure some kind of temporary access can be granted to the cloud based software. You'd need to contact IBM and work on it with a sales executive. Keep in mind they won't do anything like this unless they feel this is genuine opp...
by Alan Kirk
Mon Apr 08, 2019 10:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Subset Disappears?
Replies: 3
Views: 118

Re: TM1 Subset Disappears?

The previous answers cover how to get around it. If you want all the ins and outs of why it happens, you'll find them here:

https://www.youtube.com/watch?v=xXXrw1sXbD0
by Alan Kirk
Wed Apr 03, 2019 11:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder with N: not working in feeder
Replies: 13
Views: 3841

Re: Feeder with N: not working in feeder

I want it down at the N level but when I try and put N: in front of DB('Unit Forecast.... and run the Check Syntax it gives me an error message "Syntax on or before: N:DB('Unit.... not on Driver List. Nigh on 10 years later, a search for the expression "Not On Driver List" in relation to TM1 Rules ...
by Alan Kirk
Wed Jan 30, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Views_* and }Subsets_* control dimensions
Replies: 5
Views: 206

Re: }Views_* and }Subsets_* control dimensions

Like Lotsa said, it's been there from 2.0. Remember the good old days when there were "What's New" .pdfs and you could just search for a feature? Aaaah, nostalgia, man... it ain't what it used to be. Nonetheless there are still such lists available though these days you have to poke and prod through...
by Alan Kirk
Sat Jan 12, 2019 3:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 14
Views: 964

Re: TM1 Certifications

It's an online test Jim and therefore available to anyone worldwide. Would you, good sir, be interested in testing your mettle? For free??? :) Only kidding. If it's full of PA questions I'd be done for. The client I'm on has been stuck on version 10 for a while, heck we only upgraded to 10.2.2 as s...
by Alan Kirk
Thu Jan 10, 2019 9:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 424

Re: Old TM1 version

There was a VBA based tool (once Excel support came along) which sat over that which you could use to schedule the imports. It was about as reliable as a first generation steam train (as in, Stephenson's Rocket, but less robust) and although I used to use the thing daily I cannot for the life of me...
by Alan Kirk
Thu Jan 10, 2019 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Certifications
Replies: 14
Views: 964

Re: TM1 Certifications

I should mention one other relatively recent development in this field too given my great admiration and esteem for the official IBM certifications. Cubewise has partnered with Deakin University in Australia to create a credential that might, well, actually mean something. It's not free but as I und...
by Alan Kirk
Thu Jan 10, 2019 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Tools not working in Excel 2016 (32 bit)
Replies: 6
Views: 1876

Re: TM1 Tools not working in Excel 2016 (32 bit)

Hi Alan, I am having the same issue, then I fixed by ticking "Trust Network". But I've got another problem when clicked on the magnifying glass, I only got half window. [img]Capture.PNG[img] Is there a way to fix this? Thank you That's the one bit of the thing that was written by Martin Ryan rather...
by Alan Kirk
Thu Jan 10, 2019 6:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 424

Re: Old TM1 version

Hello, I'm using tm1 since 2016 and I always wonder what older TM1 (Sinper TM/1, Applix TM1) looks like ? Did Sinper and Applix have always used architect ? Did anyone have screenshot of older version ? Thanks ! Architect only came with version 7. Before that it was very different. Everything was b...
by Alan Kirk
Tue Dec 25, 2018 7:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DEL Command is not working in TM1 Process
Replies: 5
Views: 511

Re: DEL Command is not working in TM1 Process

2 remarks. You can use the function AsciiDelete. Good point. If you want to use ExecuteCommand with creating a text file, create the file in the Prolog tab and execute it in the Epilog tab. Then delete the temporary text file again. I was originally going to mention that but then on further examina...
by Alan Kirk
Tue Dec 25, 2018 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DEL Command is not working in TM1 Process
Replies: 5
Views: 511

Re: DEL Command is not working in TM1 Process

Del is a command which is internal to the command line processor. The usual way around this is to create a generic batch file with a parameter, such as: del %1 which then allows you to use ExecuteCommand to call that batch file. The second argument that you pass (separated by a space) is the name of...
by Alan Kirk
Thu Dec 20, 2018 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 2.0.6 - Bogus Timeouts
Replies: 2
Views: 286

Re: TM1 Web 2.0.6 - Bogus Timeouts

Yeah this bug in TM1 Web really get's my goat . (It isn't confined to just 2.0.6 BTW but crops up in all builds since Websphere replaced Tomcat from what I can tell). A colleague gave me a tip just a few days ago that a workaround to the "instant TM1 Web timeout" is to reset the user's password. Th...
by Alan Kirk
Thu Dec 20, 2018 7:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 2.0.6 - Bogus Timeouts
Replies: 2
Views: 286

TM1 Web 2.0.6 - Bogus Timeouts

Is anyone else using TM1 Web in PA 2.0.6? A new parameter was introduced to the web config file in 2.0.6 to deal with the timeout. If I may quote : The default TM1® Web session timeout is 20 minutes. When TM1 websheets are deployed to IBM® Planning Analytics Workspace, you might encounter TM1 Web se...
by Alan Kirk
Thu Dec 06, 2018 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 10
Views: 4612

Re: Fix Pack Releases: PA2 / V11 Series

I missed posting another one (hat tip to Paul Segal); 2.0.6. Which is odd, since it is in fact my version. The What's New summary will be found here . The most significant of these (for certain values of significant) is: "IBM Planning Analytics Local 2.0.6 is the last release with support for Java T...
by Alan Kirk
Thu Dec 06, 2018 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1web on https
Replies: 4
Views: 382

Re: Tm1web on https

To be fair, though, IBM doesn't seem to have gone to great lengths to incorporate this (pretty fundamental) task into its mainstream documentation. This article on 10.2.2 seems decently detailed, but in my humble it should be a step-by-step in the main documentation. There may be an equivalent docum...
by Alan Kirk
Thu Oct 25, 2018 10:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security Override
Replies: 4
Views: 402

Re: Element Security Override

In my humble the easiest way of doing this is to use a clone of the dimension in the other cubes. There are processes in the Bedrock library which can handle the cloning (including attributes) and which can be scheduled as chores.
by Alan Kirk
Sat Oct 20, 2018 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 519

Re: PA 2.0 - TM1Web reboot

Everything back online! (paw was not harmed during the production of this drama) Primarily because of PA misconception #1. The "classic" TM1 interfaces (Perspectives, Architect... and Web) can be installed in PA2 without going through the ridiculous blood pressure-elevating train wreck of a mess th...
by Alan Kirk
Fri Oct 19, 2018 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 519

Re: PA 2.0 - TM1Web reboot

Hi, This is probably a dumb question but does anyone know (on PAL) how to restart TM1Web? I've been looking all over documentations and web searches and can't seem to find it anywhere. Thanks The same way that you do it in 10.2.2; the easiest way is through Cognos Configuration via the oh-so-intuit...
by Alan Kirk
Sun Oct 07, 2018 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Pax Reports shows #WERT!
Replies: 3
Views: 466

Re: Tm1 Pax Reports shows #WERT!

Hi @Alan Kirk, Thanks for your reply. Actually I have installed Tm1 2.0.5 version recently .The reports which was working in older version of TM1 Perspectives is giving #value? in Tm1 Pax for some reports. Not having had the questionable pleasure of using PAx hands on I cannot say for certain, but ...
by Alan Kirk
Sun Oct 07, 2018 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives or TM1 pax
Replies: 1
Views: 243

Re: TM1 Perspectives or TM1 pax

Hi, I want to use either Tm1 perspectives or Tm1 pax in my application. Its depends on the End user which Tm1 client they have chosen. But by default IBM palnning analytics menu is coming in Excel, so how to disable the menu When user has chosen TM1 perspectives . Should I write a code in vb.net to...