Search found 2325 matches
- Thu Jun 18, 2020 9:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Millennium Bug
- Replies: 8
- Views: 3768
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...
- Thu Jun 18, 2020 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Millennium Bug
- Replies: 8
- Views: 3768
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...
- Thu Jun 18, 2020 7:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Millennium Bug
- Replies: 8
- Views: 3768
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...
- Thu Jun 18, 2020 3:30 am
- Forum: General
- Topic: A little bit of help with world domination!!
- Replies: 9
- Views: 67789
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...
- Thu Jan 16, 2020 4:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using RunTI with Integrated Security
- Replies: 1
- Views: 1305
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.
Jim.
- 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: 2261
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.
Jim.
- Mon Jan 06, 2020 11:57 am
- Forum: Other OLAP tools
- Topic: Anaplan
- Replies: 3
- Views: 39019
Re: Anaplan
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.
- Tue Nov 19, 2019 5:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW vs DBR in PAx
- Replies: 2
- Views: 2879
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.
Jim.
- Wed Nov 06, 2019 12:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM License Metric Tool?
- Replies: 17
- Views: 9358
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...
- Wed Nov 06, 2019 11:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM License Metric Tool?
- Replies: 17
- Views: 9358
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 ...
- Wed Nov 06, 2019 11:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM License Metric Tool?
- Replies: 17
- Views: 9358
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'...
- Thu Oct 31, 2019 5:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Question about DimensionElementInsertDirect
- Replies: 7
- Views: 6904
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...
- Fri Oct 25, 2019 10:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives and Office 2013
- Replies: 14
- Views: 15243
- Fri Oct 25, 2019 10:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives and Office 2013
- Replies: 14
- Views: 15243
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...
- 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: 8740
- 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: 5940
Re: Could not log on to any of the available servers with available credentials over internet
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.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.
- 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: 5940
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.
Jim.
- Tue Oct 15, 2019 10:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM Speeds
- Replies: 4
- Views: 5991
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 ...
- 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: 7869
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...
- 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: 6393
Re: Different rules for same element in different hierarchies
I can't stand it either. That may be the reason why my answers make no sense?Wim Gielis wrote: ↑Fri Oct 04, 2019 9:26 pmWell, goodbye then.Steve Rowe wrote: ↑Fri Oct 04, 2019 3:26 pm My golden rule, never answer a forum post before two cups of coffee!
I hate coffee and will never drink it.
Even if it means leaving the forum