Search found 2261 matches

by jim wood
Thu Jan 16, 2020 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using RunTI with Integrated Security
Replies: 1
Views: 94

Re: Using RunTI with Integrated Security

Move to 5. It's combined and takes away the issue. That or a network ID that doesn't have a password that expires and include the login string in the batch files, for example domain\user,

Jim.
by jim wood
Thu Jan 09, 2020 6:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to load data in cube
Replies: 3
Views: 435

Re: Unable to load data in cube

This could many things. You need to at least put some of your code up so we can eliminate some of the possibilities,

Jim.
by jim wood
Mon Jan 06, 2020 11:57 am
Forum: Other OLAP tools
Topic: Anaplan
Replies: 3
Views: 1137

Re: Anaplan

curiops wrote:
Mon Dec 30, 2019 1:49 pm
It really depends on what problem you are trying to solve. Anaplan does less but does it better.
Quite similar to Planning / Adaytum which isn't surprising considering it's the same developers. It has features that are nice but some issues, including (as you hinted) scalability.
by jim wood
Tue Nov 19, 2019 5:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW vs DBR in PAx
Replies: 2
Views: 209

Re: DBRW vs DBR in PAx

Not sure about PAX but I've always found the excel timing of both to be different. It'd be interesting to see if that has changed,

Jim.
by jim wood
Wed Nov 06, 2019 12:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 14
Views: 1931

Re: IBM License Metric Tool?

I am gearing up psychologically for this as I have a virtualization and migration project with 5 servers at a client coming up soon. Sounds like heaps of fun! Will probably keep notes as I go, for my own sanity, and share once successful. Keep in mind these things: 1) You're installing Big Fix, not...
by jim wood
Wed Nov 06, 2019 11:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 14
Views: 1931

Re: IBM License Metric Tool?

Happened on this link to the License Metric Tool 9.2.0 product page - may be useful. And from the Quick Start Guide , see ILMT on YouTube , the Wiki and the discussion forum . Some of it is useful, some not so much. The problem I found is the tool isn't very intuitive so you really have to try and ...
by jim wood
Wed Nov 06, 2019 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 14
Views: 1931

Re: IBM License Metric Tool?

Another question, is Planning Analytics Workspace PVU-based? I think it isn't. Therefore ILMT doesn't need to monitor that server. Am I right? Thanks. It detects all of your installs as long as the Big Fix client and masthead are installed on the PAW machine. Once you've mapped all the installs it'...
by jim wood
Thu Oct 31, 2019 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Question about DimensionElementInsertDirect
Replies: 7
Views: 2869

Re: Question about DimensionElementInsertDirect

It would not make much sense using DimensionElementInsertDirect in Metadata as DimensionElementInsert would do the same thing. I did however do this inadvertently because I copied code from Data to Metadata and it crashed my server (10.2.2 FP4) I have also found severe performance degradation using...
by jim wood
Fri Oct 25, 2019 10:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives and Office 2013
Replies: 14
Views: 9374

Re: Perspectives and Office 2013

lotsaram wrote:
Thu Oct 24, 2019 5:35 pm
Why given it’s nearly 2020 would you be upgrading Excel to Office 2013 when Office 2013 is itself already obsolete?
I've still got 2013 installed on one of my machines at home as I like the ribbon.
by jim wood
Fri Oct 25, 2019 10:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives and Office 2013
Replies: 14
Views: 9374

Re: Perspectives and Office 2013

We had an old 9.5 perspectives client that worked fine with Excel 2010 and gives this message now we have upgraded to 2013. Version 9.5? Isn't that about 10+ years old now? That's longer than a human lifetime in software years. I wish you luck. Just glad I am not being asked to fix this. May be the...
by jim wood
Mon Oct 21, 2019 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is used by whom? and for what purpose?
Replies: 2
Views: 6346

Re: What is used by whom? and for what purpose?

PavoGa wrote:
Mon Oct 21, 2019 12:31 pm
@tomok

I think this one is for you. :D
I'll get my tin hat and sand bags ready!!!
by jim wood
Wed Oct 16, 2019 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Could not log on to any of the available servers with available credentials over internet
Replies: 3
Views: 3583

Re: Could not log on to any of the available servers with available credentials over internet

tiagoblauth wrote:
Tue Oct 15, 2019 11:51 am
Hi Jim, many thanks for your answer.

I can access http://{ip_address}:9510/tm1web from external access.
Is it just pmpsvc that is not working from external access.
It may be a script that's being blocked? This may be one for IBM. Support will have a better idea of how to log such things.
by jim wood
Tue Oct 15, 2019 10:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Could not log on to any of the available servers with available credentials over internet
Replies: 3
Views: 3583

Re: Could not log on to any of the available servers with available credentials over internet

You need to check with your IT department. The security credentials (hand shakes etc) tend to be more aggressive for outside access. Is the server even available to the web? Most servers I work with have no net access,

Jim.
by jim wood
Tue Oct 15, 2019 10:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM Speeds
Replies: 4
Views: 3058

Re: RAM Speeds

Because as RAM clock speeds go up each operation takes more clock cycles, increasing the relative latency, therefore you cannot expect to double your performance. A more realistic outcome would be a 10-20% improvement, depending on many additional hardware and software factors. That depends on the ...
by jim wood
Fri Oct 11, 2019 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Lock" Actual Data in a forecast application
Replies: 6
Views: 4154

Re: "Lock" Actual Data in a forecast application

The way I've done it in the past and do at the current client is to have actual and forecast as seperate versions. Have an actual flag on the time dimension, then pull via rules actual data in to forecast when the flag is set. This way you lock the actual periods via rules (no security needed) and y...
by jim wood
Mon Oct 07, 2019 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 3161

Re: Different rules for same element in different hierarchies

Wim Gielis wrote:
Fri Oct 04, 2019 9:26 pm
Steve Rowe wrote:
Fri Oct 04, 2019 3:26 pm
:lol: My golden rule, never answer a forum post before two cups of coffee!
Well, goodbye then.
I hate coffee and will never drink it.
Even if it means leaving the forum :lol:
I can't stand it either. That may be the reason why my answers make no sense?
by jim wood
Fri Oct 04, 2019 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 3161

Re: Different rules for same element in different hierarchies

I don't think what you want to do is possible, the N level of a cube is common for all hierarchies. C levels are different, same named C level members in different hierarchies are distinct members. The moral of that story is don't try and answer questions at 6.30 in the morning. :oops: You are of c...
by jim wood
Fri Oct 04, 2019 10:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different rules for same element in different hierarchies
Replies: 6
Views: 3161

Re: Different rules for same element in different hierarchies

C level rule, if statements and elisanc. That's the way I'd go about it.
by jim wood
Mon Sep 23, 2019 10:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade to Planning Analytics from TM1 10.1.1 Version
Replies: 3
Views: 804

Re: Upgrade to Planning Analytics from TM1 10.1.1 Version

No we haven't increased RAM and also we haven't installed installed PAW or any of its resource sapping stuff. We have server & web installed on the same test box for now, so that may explain the performance up tick,

Jim.
by jim wood
Thu Sep 19, 2019 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade to Planning Analytics from TM1 10.1.1 Version
Replies: 3
Views: 804

Re: Upgrade to Planning Analytics from TM1 10.1.1 Version

I've just done an upgrade from 10.2.2 to PA 2.0.7 and had no issues. W were on 10.1.1 for a long time and the upgrade to 10.2.2 raised no issues. Keeping in mind not that much has changed on the server side you should be good. I would say that we've noticed huge increase in web sheet performance in ...