Search found 88 matches

by ykud
Thu Jun 04, 2020 11:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Self Triggering
Replies: 9
Views: 205

Re: TM1 Process Self Triggering

As you and declanr said, the reason for rollback is that one of the sub processes was having a cubesavedata over a particular cube . That was the reason for roll back , i removed it but facing another issue which was the reason for above lock you had mentioned Try adding log4j.logger.TM1.Lock.Excep...
by ykud
Thu Jun 04, 2020 5:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements without any data
Replies: 28
Views: 1747

Re: Deleting elements without any data

Basically, what we want accomplished is the dimension should contain only active elements and delete any inactive elements whenever the TI is run. How do we accomplish this without causing the server to crash? I'd do the following: in your dimension update process # in prolog remove the isActive at...
by ykud
Mon Jun 01, 2020 2:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Self Triggering
Replies: 9
Views: 205

Re: TM1 Process Self Triggering

I'd also look into this: Event.Thread Thread[28960] is blocking 72 other threads Something is taking a lock and holding it forcing your main process to roll back and restart. SaveCubeData is server side lock, as is SecurityRefresh, ViewConstruct and a few dimension change functions, so I'd scan your...
by ykud
Mon Jun 01, 2020 1:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 19
Views: 706

Re: Local Backup

Indeed. But on IBM SaaS, you have to raise a ticket to get utilities like 7Zip installed. AFAIK, you don't have to 'install' 7-zip, it's available as standalone executable, so you just need to upload it to the tm1 server (any of the shared folders you have access to) and it should work. And 7z is a...
by ykud
Wed May 27, 2020 11:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1 log file delete
Replies: 6
Views: 461

Re: tm1 log file delete

I see this file since i use the "IBM Cognos TM1 Operations Console" - but can also be coincidence, because at that time we also went on a new TM1 version. This is a PA 2.0.3 feature https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_op_logger.html y...
by ykud
Wed May 20, 2020 3:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 624

Re: User driven security

EvgenyT wrote:
Wed May 20, 2020 2:14 am
Thanks Yuriy, great feedback! I really wanted to be clever :roll: :roll: :roll: :roll:
No worries, happy to help.
I have a 'don't be clever' print out just behind my monitor so that I don't forget :)
by ykud
Wed May 20, 2020 1:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 422

Re: Memory Usage Issues - StatsByCube

It is a real pity that you cannot clear the garbage memory as this would allow you to then allocate maximum resources for quick statups of the model. Assume this is not possible? Maybe through a secret number with the DebugUtility command that only ykud seems to know ;-) Don't know any such command...
by ykud
Wed May 20, 2020 1:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 624

Re: User driven security

I try to avoid being clever around security :) I'd create an individual group for each user and use the lookup cube to populate element security for cost centres via a TI (it will be very fast and doesn't require a Security Refresh). Doing anything with a rule as you describe would require some real...
by ykud
Wed May 20, 2020 12:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 422

Re: Memory Usage Issues - StatsByCube

For example if the view needs 4 gb of memory and there is only 3 gb of garbage memory available the server gets another 4 gb of the unused memory and after the view is no longer needed adds it to the existing 3 gb of garbage for a total of 7 gb. Right or wrong? I'd bet it'll be more the case of the...
by ykud
Mon May 18, 2020 12:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory Usage Issues - StatsByCube
Replies: 17
Views: 422

Re: Memory Usage Issues - StatsByCube

Unfortunately the }Stats measures don't include any counters for memory used by dimensions and indicies, only cubes, so there will always be a bit of a gap between "Memory used for cubes" and Total Memory less Garbage Memory. I'm pretty sure you know this trick, but, just in case, this will give yo...
by ykud
Thu May 14, 2020 4:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Linux shell
Replies: 5
Views: 497

Re: TM1 Linux shell

blandmtm1 wrote:
Wed May 13, 2020 1:20 pm
We tried both of these. Job ran without errors but nothing was created in either of the commands. No idea what is going on.
Must be something with user running the tm1 server, try su under it and run the same?
by ykud
Wed May 13, 2020 12:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Managing TM1 database assets with Git
Replies: 4
Views: 275

Re: Managing TM1 database assets with Git

With those documents from IBM, you will find yourself struggling with the syntax of tm1project file eventually. Yes, it can do a few things with Git but very hard to use. :? Do you mind sharing what in tm1project file was confusing? I agree it's very far from intuitive, it's more of an API to build...
by ykud
Wed May 13, 2020 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Linux shell
Replies: 5
Views: 497

Re: TM1 Linux shell

The script runs good from terminal / bash but will not run when called from tm1. We gave it 777 just to be safe. We even put a simple echo hello world >> log.txt in the script to see if it ran. Are you trying from the user that runs tm1s? Try running ExecuteCommand ( 'touch /data/disk1/xxx/can_i_cr...
by ykud
Fri May 08, 2020 1:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Admin Right Restriction
Replies: 6
Views: 1441

Re: TM1 Admin Right Restriction

I did this once with a separate tm1 model that ran on a separate / isolated server that had file system level encryption and a different set of OS user accounts. Data was transferred to the main model using file transfer, but files were PGP encrypted. HR server would export the encrypted files to th...
by ykud
Mon May 04, 2020 3:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server registering with Admin server
Replies: 13
Views: 1100

Re: TM1 server registering with Admin server

Anything interesting in Admin server log? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_usingtheadminserverlog_n1600ba.html I'd put in debug for next weekend to see whether there was a comm error. Anything interesting in the Windows Event log ar...
by ykud
Mon Apr 27, 2020 12:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model restarting for no apparent reason
Replies: 3
Views: 951

Re: Tm1 Model restarting for no apparent reason

Hi Guys Our Tm1 model is re-starting for no apparent reason. The Ram usage on the server is very high - around 97% Could this cause it to restart? The physical server itself did not go down, so I'm surprised that it has restarted itself. Any ideas why? Try looking in Windows Event Log -- it might h...
by ykud
Sun Apr 26, 2020 11:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1+CAM Security: see what any user would see
Replies: 17
Views: 1353

Re: TM1+CAM Security: see what any user would see

Then I prefer a real client like Architect or PAW, rather than reinventing the wheel - however interesting and challenging that can be 😉 Sure, I'd prefer it as well, but there's none :) I'm not sure PAW will support it anytime soon (they haven't done this in 3 years the capability was there, so it'...
by ykud
Fri Apr 24, 2020 1:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1+CAM Security: see what any user would see
Replies: 17
Views: 1353

Re: TM1+CAM Security: see what any user would see

foogy wrote:
Thu Apr 23, 2020 11:17 am

Until then, I will give the SecurityMode=1 option and login with CAM cryptical ID a chance.
Just FYI, IntegratedSecurityMode became a dynamic parameter in PA, so you can flip between 1 and 5 without restarting the service, a little known fact that I really like.
by ykud
Fri Apr 24, 2020 1:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1+CAM Security: see what any user would see
Replies: 17
Views: 1353

Re: TM1+CAM Security: see what any user would see

Sorry I just couldn't pass this by without saying that on PA you'd be able to use 'impersonate user' param in REST API and see exactly what that use would see :) https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0.doc/dg_tm1_odata_auth.html IntegratedSe...
by ykud
Thu Apr 23, 2020 5:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1+CAM Security: see what any user would see
Replies: 17
Views: 1353

Re: TM1+CAM Security: see what any user would see

let me first explain the situation: running TM1 10.2.2 with CAM Security (please no comments on outdated version, this is not the topic here) Sorry I just couldn't pass this by without saying that on PA you'd be able to use 'impersonate user' param in REST API and see exactly what that use would se...