Search found 730 matches

by gtonkin
Mon Feb 24, 2020 6:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx switch model/package name in exploration view
Replies: 2
Views: 361

Re: PAx switch model/package name in exploration view

Apologies if I am missing something but looks like you can unhide the hidden rows for the exploration and point the value next to System: to a named range which references your Server:Instance e.g. Denil:Denil_Development
by gtonkin
Wed Feb 19, 2020 3:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query - ODBC or syntax issue?
Replies: 5
Views: 264

Re: SQL Query - ODBC or syntax issue?

Looking at the error I would check your spacing, for example you have sum([DMBTR]) as AmountFROM [SAP_Eksport].[dbo].[VE_Z_XTRACT_DOCUMENTS] ZapisySapLEFT There needs to be a space between Amount and From and ZapisySap and Left There are other spacing issues so I would sort that out first regards, ...
by gtonkin
Thu Feb 13, 2020 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 551

Re: RunProcess, parameters and NOW bug

Could be precision - have you tried multiplying by 1,000,000 then dividing on the other side?
by gtonkin
Wed Feb 12, 2020 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web White Blank Page
Replies: 10
Views: 1462

Re: TM1 Web White Blank Page

Does it do this for you or all users?
Have you tried holding shift and clicking the refresh icon in your browser? (sometimes Ctrl+Shift+Click Refresh)
by gtonkin
Thu Feb 06, 2020 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8218

Re: RunProcess explanation

You are creating sFile as follows: sFile = Expand('C:\TM1 Servers\Test\Exports\Test_%pEmp%.csv'); Where are you getting pEmp from? Parameters passed look like pEmpID and pDeleteView: RunProcess('CalledProcess', 'pEmpID', vEmp, 'pDeleteView', 'Yes'); Have you tried: sFile = Expand('C:\TM1 Servers\Tes...
by gtonkin
Tue Feb 04, 2020 6:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 29
Views: 8218

Re: RunProcess explanation

I would be curious to know what sFile is defined as - sounds like you may be using a date and time stamp and because the process is executing quickly, you end up over-writing the previously created file.
You say name of the employee but anything else being done to it? Share the code perhaps?
by gtonkin
Thu Jan 30, 2020 6:33 am
Forum: Enhancements
Topic: RFE : PAW should be part of IBMs DR strategy for their cloud offering.
Replies: 1
Views: 400

Re: RFE : PAW should be part of IBMs DR strategy for their cloud offering.

Always good having backups but not having done too many restores yet, do the backup and restore scripts run prior to upgrades not do this? I have not interrogated what is contained in the backup so asking if anyone else knows and has actually used the backup to restore everything. By everything I me...
by gtonkin
Fri Jan 24, 2020 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 317

Re: Process Error Log Not Available

This is what I found and ran some basics tests on: PROLOG NumericGlobalVariable('PrologMinorErrorCount'); NumericGlobalVariable('MetaDataMinorErrorCount'); NumericGlobalVariable('DataMinorErrorCount'); EPILOG 'Will not help if the error is triggered in Epilog unfortunately-GetProcessErrorFilename() ...
by gtonkin
Fri Jan 24, 2020 2:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 317

Re: Process Error Log Not Available

The main difference is that I using ExecuteCommand NOT ExecuteProcess i.e. forking out to the command prompt, waiting 5 seconds then executing the TI emailer from outside of TM1 and the process that should be complete. Admittedly this is 10.2.2 and on premise so may not work for your purposes but wi...
by gtonkin
Thu Jan 23, 2020 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 317

Re: Process Error Log Not Available

Until the process ends, the processerror log is still named .log$ As a test, change your FileExists to see if the .log$ version exists - if it does, it is a timing issue. What I have done on my email process is to call it with the necessary parameters from a RunTI - I do however prefix the RunTI com...
by gtonkin
Wed Jan 22, 2020 5:01 pm
Forum: Commercial and Events
Topic: TM1 Syntax File for VIM
Replies: 2
Views: 425

Re: TM1 Syntax File for VIM

There are two of us who use VIM :mrgreen: and possibly only two of us silly enough to directly edit .pro files.
Thanks for sharing - will have a look and feedback what I can.
by gtonkin
Wed Jan 22, 2020 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Transaction Log
Replies: 7
Views: 460

Re: PA Transaction Log

In my experience, TM1S is always locked and you cannot read it.
Viewing the transaction log from within TM1 will show transactions but only those written after serialization/save data.
Cannot see how this would be different unless you have a chore saving data periodically.
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: 165

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

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: 12
Views: 540

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

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

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

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

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