Search found 718 matches

by gtonkin
Mon Jan 20, 2020 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error 400 in PAx
Replies: 3
Views: 71

Re: Error 400 in PAx

Got any protected sheets?
Possibly hidden sheets?
Wild guesses here.
by gtonkin
Sat Jan 18, 2020 2:43 pm
Forum: Useful code, tips and tricks
Topic: Cryptic TM1 Messages Decoded
Replies: 70
Views: 45531

Re: Cryptic TM1 Messages Decoded

A new one to me. Using TM1ELLIST in Planning Analytics for Excel to show Members in a dimension. When I refreshed the sheet I got the #SPILL! message as the element list would have over-written values further down in the column i.e. spilled over I guess. This is an Excel error, not TM1/Planning Anal...
by gtonkin
Fri Jan 17, 2020 6:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To know Active Users & Inactive Users of TM1
Replies: 9
Views: 256

Re: To know Active Users & Inactive Users of TM1

Hello Community, I have above 400 user for TM1, and I want to know which users are active, so that i want to delete the inactive users. My friend suggested that delete all users from TM1 architect, this will not impact the active users, and whenever active user login, their ID will visible in the T...
by gtonkin
Mon Dec 23, 2019 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

Still makes no sense that Private Subsets work as intended. For now it is what it is, workarounds already implemented and deployed. No actually it makes perfect sense! Private subsets and views aren't loaded when the server loads but when the user logs in. The implicit DimensionDestroy and rebuild ...
by gtonkin
Mon Dec 23, 2019 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

Agree with lotsaram, just the way it is and handled it the same way. Have a TI that reads the sub files at start up and recreates them. However, now I use copies of those dimensions instead. Still makes no sense that Private Subsets work as intended. For now it is what it is, workarounds already im...
by gtonkin
Sat Dec 21, 2019 8:31 am
Forum: Useful code, tips and tricks
Topic: Public Subsets on }Chores, }Cubes, }Dimensions and }Processes do not persist after a server restart
Replies: 2
Views: 734

Public Subsets on }Chores, }Cubes, }Dimensions and }Processes do not persist after a server restart

These dimensions are rebuilt on startup and once rebuilt do not seem to keep the linkage to public subsets. Even though the subsets can be found in the respective subs folders, they are not registered and are not accessible by users or TI processes. If you do need to have public subsets for use in T...
by gtonkin
Fri Dec 20, 2019 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

Hi George, I don't think this is new. This is just the way it is or always has been. Or as IBM woudl have it, it's a "feature" not a "bug". It's becasue the }Dimensions and }Cubes dimensions are recreated on every server restart and elements inserted from a sweep of the .dim and .cub objects in the...
by gtonkin
Fri Dec 20, 2019 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

Further testing revealed the following: Creating a public subset on }Clients works as expected when restarting - }Cubes, }Dimensions do not show the subset, not even the plus sign to expand the dimension to show subsets. Creating a new dimension called Test with a few elements and saving a public su...
by gtonkin
Fri Dec 20, 2019 3:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

Created an instance with only the control dims, cubes and related folders. Same issue - no subsets on }Cubes and }Dimensions even though the folder is in place with .sub files Checked permissions - user that starts the service has full control on the instance adn all the way down through folders to ...
by gtonkin
Fri Dec 20, 2019 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

... I have experienced the multiple dollar sign files as well. What happens is the system gets "lost" when saving and the temporary file (the one with the $) never gets renamed. This now becomes your live version of that object. If you make changes again then you'll get a version with $$ and then a...
by gtonkin
Fri Dec 20, 2019 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

After adding a logger for TM1.System.File I picked up the following on two of the dimensions with the subset issue: tm1server.log:10168 [] DEBUG 2019-12-20 12:07:38.012 TM1.System.File SetError: Error on file 'd:\cib mr\tm1data\}Cubes.dim$$$'. Error = error code:2 reason:"The system cannot find the ...
by gtonkin
Fri Dec 20, 2019 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Re: Subsets and Views not registering after Restart

Thanks Ken, unfortunately client is a large corporate and the upgrade is underway but the cycles are long.
Busy enabling some of the TM1 loggers in the tm1s-log.properties file to see if it sheds more light.
by gtonkin
Fri Dec 20, 2019 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 794

Subsets and Views not registering after Restart

I have this issue from time to time and have not been able to find a logical explanation or a resolution for it. Sometimes after a server restart, Dimensions that had subsets attached to them no longer have them. Similarly with cubes, views disappear. The .sub and .vue files *are* however on the dis...
by gtonkin
Wed Dec 18, 2019 4:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 14
Views: 17452

Re: Fix Pack Releases: PA2 / V11 Series

PAL 2.0.9 released yesterday, available on Fix Central. Fix list
by gtonkin
Thu Dec 12, 2019 5:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View not loading in TI Process
Replies: 8
Views: 491

Re: View not loading in TI Process

Have you tried increasing MaximumViewSize in your TM1s.CFG? Looks like it has been tweaked but may not be high enough. edit: had not seen Tom's post before I hit submit-my suggestion is a short-term attempt to see if it is something trivial but would recommend further investigation per Tom's post if...
by gtonkin
Fri Nov 29, 2019 8:00 am
Forum: Useful code, tips and tricks
Topic: Cryptic TM1 Messages Decoded
Replies: 70
Views: 45531

Re: Cryptic TM1 Messages Decoded

Process "xxx": Invalid parameter array size: Could not initialize process You also get a failure on opening the error log and the log$ file remains. The cause of this error is due to a drill process being created against cube A but the drill Assignment belongs to cube B i.e. the cubename in the para...
by gtonkin
Wed Nov 27, 2019 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of loading files in memory
Replies: 5
Views: 644

Re: Order of loading files in memory

... My real user case is a TM1 model of 115 GB where I needed to import a couple of TI processes but I forgot... until 80 GB was loaded and half an hour was gone... Would be useful to be able to use AutoHotKey to effectively retype the necessary details from your non-prod to prod environment then s...
by gtonkin
Thu Nov 21, 2019 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGOUTPUT to separate log file
Replies: 4
Views: 426

Re: LOGOUTPUT to separate log file

There is a logger called TM1.TILogOutput but tried a quick config and test and still ended up writing to the server log. I could be doing something silly from my side so may be worthwhile doing your own testing.

Just linking to the post to show available loggers for anyone needing them:
by gtonkin
Tue Nov 19, 2019 6:34 pm
Forum: Useful code, tips and tricks
Topic: Planning Analytics for Excel Deep Dive
Replies: 0
Views: 371

Planning Analytics for Excel Deep Dive

Came across this useful article (if you have access):

https://www.ibm.com/cloud/garage/dte/tu ... deep-dive/