Search found 233 matches

by Paul Segal
Tue Feb 20, 2018 4:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting data from AD
Replies: 1
Views: 17

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: 133

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: 319

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: 403

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: 684

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: 662

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: 154

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: 268

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: 268

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: 634

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 ...
by Paul Segal
Thu Aug 24, 2017 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA Macro errors in Excel 2016
Replies: 17
Views: 1171

Re: VBA Macro errors in Excel 2016

So, what happens if you delete and recreate the button in 2016?
by Paul Segal
Thu Jul 20, 2017 7:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connecting with Integrated Login using VBA
Replies: 7
Views: 777

Re: Connecting with Integrated Login using VBA

Are you on IntegratedSecurityMode = 2? If so, this will work

Code: Select all

Application.Run("N_CONNECT", "YourServer", "","")
Otherwise look at this thread http://www.tm1forum.com/viewtopic.php?t=765
by Paul Segal
Tue Jul 18, 2017 9:26 am
Forum: General
Topic: Upcoming server migration
Replies: 15
Views: 2626

Re: Upcoming server migration

Hi Martin,

Advertising seems to be working, but I don't appear to be getting emails from the forum. Not that there's a rush...

While I'm here, thanks for the work and effort you put into this.

Best

Paul
by Paul Segal
Wed Jul 05, 2017 5:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX for Excel 2013 is Slow Slow Slow
Replies: 1
Views: 403

Re: PAX for Excel 2013 is Slow Slow Slow

I've been doing some testing on PAX, on 2013 and 2010, and I don't get this behaviour. You may want to get the latest Fix Central versions of PAx and PAW: https://www-01.ibm.com/support/docview. ... wg24043782
by Paul Segal
Tue Jun 27, 2017 11:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM
Replies: 1
Views: 313

Re: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

For anyone interested this is a bug, and a fix is in the pipeline - PI83093 DROPDOWN ARROW FOR A SUBNM CELL DISAPPEARS WHEN SHEET ISPROTECTED (EVEN IF CELL IS SET TO BE UNLOCKED) - although no date for it yet.
by Paul Segal
Thu Jun 22, 2017 9:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM
Replies: 1
Views: 313

Planning Analytics for Excel 2.0.1 - Excel sheet protection breaks SUBNM

Protecting a sheet in Excel and then unprotecting a cell in the sheet that has a (vanilla) SUBNM formula appears to break the SUBNM formula - I can pick a new element from the set editor, but the cell drop down doesn't appear and the SUBNM cell is not updated with the new element when it's selected ...
by Paul Segal
Thu Jun 15, 2017 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error accessing set editor from PAx
Replies: 5
Views: 595

Re: Error accessing set editor from PAx

Well, I've fixed it, but not cured it. I had the http port set to 8080 on the PAW start.bat rather than 80 as there was something else on 80. I've got rid of the something else and rebuilt PAW using port 80 and it now works. Thanks for the help though, Steve.
by Paul Segal
Wed Jun 14, 2017 4:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error accessing set editor from PAx
Replies: 5
Views: 595

Re: Error accessing set editor from PAx

I did (I'm pretty sure). I get the PAW-like logon screen, which works and lets me in.
by Paul Segal
Wed Jun 14, 2017 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error accessing set editor from PAx
Replies: 5
Views: 595

Re: Error accessing set editor from PAx

It doesn't look like that's it - IE11 is installed, and I've even made it default now. I still get the same result.

Thanks
by Paul Segal
Wed Jun 14, 2017 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error accessing set editor from PAx
Replies: 5
Views: 595

Error accessing set editor from PAx

Anyone else come across this? Everything else seems to be working OK. This is accessing GO_New_Stores, so should be fairly standard.
Capture2.PNG
Capture2.PNG (44.09 KiB) Viewed 595 times