Search found 243 matches

by Paul Segal
Fri Jun 22, 2018 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA when running TI processes Kick out RDP
Replies: 6
Views: 408

Re: PA when running TI processes Kick out RDP

Have you checked both memory and disk space availability on the server?
by Paul Segal
Mon May 14, 2018 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pulse in Cloud
Replies: 1
Views: 209

Re: Pulse in Cloud

I believe the answer to this is not yet, as IBM won't let third-party software onto their cloud servers, and I don't think Cubewise have finished converting Pulse to the Rest API. The best people to talk to about this are Cubewise at cubewise.com , who I'm sure will be delighted at the idea of a sal...
by Paul Segal
Mon May 14, 2018 2:29 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 13
Views: 1962

Re: Using old clients with new planning analytics server

Hi Kamil, The only non-vanilla thing is that this is running on Citrix, and the way this is set up I don't have access to the \ssl directory for the Citrix image to add the imbtm1.arm file. It is only Architect/Perspectives for the moment. I tried it on a local copy of TM1 and I had the same issue. ...
by Paul Segal
Tue May 08, 2018 1:29 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 13
Views: 1962

Re: Using old clients with new planning analytics server

Just in case anyone else goes down the same rabbit hole: Step 3 on Kamil's post implies (or at least it did to me) that you don't need to add the ibmtm1.arm file to the local install \ssl directory. Using 10.2 and 10.2.2 it wouldn't work for me unless that file is in the \ssl directory, no matter wh...
by Paul Segal
Thu Mar 29, 2018 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: We haven't had a good hardware discussion in some time...
Replies: 0
Views: 422

We haven't had a good hardware discussion in some time...

So, it's been getting on for 10 years, and I'm looking at replacing my (local) TM1 servers. I get that (mostly) more memory is better and (mostly) more cores are better and (probably) SSD hard drives with lots of headroom are good. Ignoring licensing issues for the purposes of argument, and the deba...
by Paul Segal
Wed Mar 21, 2018 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Server Name reference in workbook
Replies: 11
Views: 2507

Re: Dynamic Server Name reference in workbook

Yup, what Wim says: must be PAX not Perspectives.
Capture.PNG
Capture.PNG (10.09 KiB) Viewed 676 times
by Paul Segal
Wed Mar 14, 2018 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View Size issue
Replies: 11
Views: 848

Re: View Size issue

You don't say what version you're on - I've just had this on a PAX report that normally runs OK on 10.2.2 and threw this error in the log in 11.030. FWIW, I increased the maximumviewsize and it went away - you can increase this dynamically, so it should be easy to test higher maximumviewsize setting...
by Paul Segal
Tue Mar 06, 2018 11:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW connection to two same named instances, on different servers
Replies: 4
Views: 609

Re: DBRW connection to two same named instances, on different servers

Although under some (carefully controlled) circumstances it can be a useful fail-over device. If server1:fred isn't available, and if server1;server2 are the admin hosts, then server2:fred will become available. Obviously it depends on how data is loaded, replicated, etc, as to how up-to-date server...
by Paul Segal
Tue Feb 27, 2018 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW connection to two same named instances, on different servers
Replies: 4
Views: 609

Re: DBRW connection to two same named instances, on different servers

This won't work in Perspectives. It will use the server instance with the first named admin host in options (so, if admin hosts is set to server1;server2 both with instances called Fred, then the server1 Fred will take precedence). For access from Excel, you won't be able to do what you want. It mig...
by Paul Segal
Tue Feb 20, 2018 4:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting data from AD
Replies: 2
Views: 282

Re: Getting data from AD

Not natively, but you can do it through e.g. VBA, VB or Powershell. Here's a sample VBA function: Function Get_LDAP_User_Properties(strObjectType, strSearchField, strObjectToGet, strCommaDelimProps) ' This is a custom function that connects to the Active Directory, and returns the specific ' Active ...
by Paul Segal
Wed Feb 07, 2018 5:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx for MSExcel (formerly CAFE) errors explained
Replies: 3
Views: 373

Re: PAx for MSExcel (formerly CAFE) errors explained

It's a PITA is what it is. That and creating hidden worksheets for drop-down lists. *grump*
by Paul Segal
Wed Jan 31, 2018 11:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pick Dimension Worksheet
Replies: 5
Views: 527

Re: Pick Dimension Worksheet

I've seen something like this before - it might not be the number, but the full stop that's the issue. FWIW... :D
by Paul Segal
Tue Jan 09, 2018 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 929

Re: Poll : Which version of Excel is used in your business

It's not a single answer question for us - Citrix is running 2010 and local installs are running 2013 (I know..) I'm aiming to roll out PA this year and make it all local, but we're still testing, so March might be a little tight. I would ideally expect a longer notice period from IBM.
by Paul Segal
Wed Jan 03, 2018 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 1085

Re: PAW questions

Wim,
I think data source has now been added to PAW in
2.0.29
, but I haven't tested it yet.
by Paul Segal
Tue Oct 03, 2017 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1170

Re: Performance of Architect Vs Perspectives

The difference is only material because your model is taking so long to calc. Without knowing your model in detail it's difficult to be specific, but the speed issue will be down to the way the model is designed - as Win and Tomok have pointed out. I don't think your speed will improve by moving to ...
by Paul Segal
Thu Sep 21, 2017 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: reports using active form
Replies: 1
Views: 257

Re: reports using active form

Yes, firstly you should read the documentation that comes with TM1, such as this. This is really too general a question for this forum and you should also read the guidelines on requests for assistance.
by Paul Segal
Wed Sep 13, 2017 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatic mail triggering
Replies: 3
Views: 421

Re: Automatic mail triggering

This isn't really a TM1 specific question: what you're basically trying to do is be notified if a service stops. I did an internet search and seconds later came up with this this . To do it yourself and for free you'll need to be comfortable with VBS/Powershell or somesuch and put it together someth...
by Paul Segal
Tue Sep 12, 2017 7:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatic mail triggering
Replies: 3
Views: 421

Re: Automatic mail triggering

Many many options, and google is your friend on this. We use a combination of Pulse for TM1 which runs on the TM1 server (and does many other things), and Pulseway to monitor the servers and the services on it (including Pulse for TM1). There are ways to do it for free, but Pulseway in particular is...
by Paul Segal
Wed Aug 30, 2017 4:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving Data using Alternate Hierarchy
Replies: 4
Views: 972

Re: Retrieving Data using Alternate Hierarchy

A slight hijack, but my concern is that DBR/DBRW/Custom Reports won't ever support alternate hierarchies. I appreciate the need to keep these functions backward compatible, but if we ever want to use alternate hierarchies in PAX in Custom Reports then we would need a new function (DBRH anyone?) for ...