Search found 2270 matches

by jim wood
Wed Jun 24, 2020 3:13 am
Forum: General
Topic: A little bit of help with world domination!!
Replies: 7
Views: 498

Re: A little bit of help with world domination!!

Still not sure how Hernan got almost 300 Fakebook votes in the closing hours :shock: Auto-hot key, Temp-mail.org, Join Facebook, Vote, repeat?? Yours was a great entry and a super specc'ed machine. My wife commented on how clean it looked. Enjoy the endless hours you will spend on it! Curious as to...
by jim wood
Sat Jun 20, 2020 6:25 pm
Forum: General
Topic: A little bit of help with world domination!!
Replies: 7
Views: 498

Re: A little bit of help with world domination!!

I assume that they'll just pool the votes at the end so I guess it's a question of which platform ultimately has the higher engagement level, with the third one being the wild card. Unfortunately based on the current vote count, Faceplant is ahead by a big margin. There are still 4 days to turn tha...
by jim wood
Fri Jun 19, 2020 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 214

Re: Millennium Bug

Guys,

I can confirm that adding the parameter fixes the problem. Thanks Andy,

Jim.
by jim wood
Fri Jun 19, 2020 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 214

Re: Millennium Bug

Thanks Andy. I'll give that a try and see how it goes. I'll report back what happens when I add the parameter. I did move to converting using 21916 and still got the same problem.
by jim wood
Thu Jun 18, 2020 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 214

Re: Millennium Bug

I just swapped over from adding 7095 to subtracting 21916 and I get the exact same result. Any date before 2000 does not convert properly. By the way I've checked this in both 10.2.2 and PA,

Jim.
by jim wood
Thu Jun 18, 2020 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 214

Re: Millennium Bug

Hi Jim That was just an example - the important thing is the conversion factor. Date serial numbers in Excel start at 1900, and in TM1 they start at 1960. That conversion factor of - 21916 is the number of days different between 1st Jan 1900 and 1st Jan 1960. I suspect that you might be hitting a p...
by jim wood
Thu Jun 18, 2020 8:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 214

Re: Millennium Bug

Paul the issue is that anything below the year 2000 is not being converted from a numeric to a string correctly so if you look at the image you can see highlighted it's converting 11/01/1991 in to 04/06/1971, yet for 06/30/2008 it converts it correctly. I've done this with both TimSt and TimVl. I ge...
by jim wood
Thu Jun 18, 2020 7:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 214

Millennium Bug

Could you believe it I think I've found a Millennium bug 20 years late. I have the following rule: [{'Forecast Live','Final Capital Plan','Workplan-Latest','Capital Plan Workspace','Capital Plan Snapshot'},{'Stage 1','Stage 2','Stage 3','Stage 4','Stage 5'},{'Start Date','End Date'},'String'] = S: I...
by jim wood
Thu Jun 18, 2020 3:30 am
Forum: General
Topic: A little bit of help with world domination!!
Replies: 7
Views: 498

A little bit of help with world domination!!

Guys, I'm not normally one to ask for favors but I was wondering if you could help me out? As some of you may or may not know I build PCs for fun. (Yes I know) One of my builds has made it through to the final of a national competition. The winners prize is a load of goodies including a brand spanki...
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: 251

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

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

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

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

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

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

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

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

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

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

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!!!