Search found 3509 matches

by Alan Kirk
Thu Jun 07, 2018 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum to exclude one element
Replies: 6
Views: 210

Re: Consolidation sum to exclude one element

You can create the total as a sum of 2 elements, the consolidation of 9 and the 10th leaf level element. Very easy. Thanks Wim. I do not want to specify the elements explicitly in the rule since there are chances of additional elements being added in the future. So how much ever elements gets added...
by Alan Kirk
Wed Jun 06, 2018 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GetProcessErrorFileName()
Replies: 9
Views: 223

Re: GetProcessErrorFileName()

Try this: sPath = CELLGETS('Global Variables', 'Value', 'Path to Hierarchy Files'); IF(FILEEXISTS(sPath | pFileName) = 0); DATASOURCETYPE= 'NULL'; ITEMREJECT('File is missing'); PROCESSBREAK; ELSE; DATASOURCENAMEFORSERVER= sPath | pFileName; ENDIF; That doesn't work, the process still tries to open...
by Alan Kirk
Wed May 16, 2018 7:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 278

Re: Security Access Flag not being Deployed

Whether a process runs with security access for non-admin users is stored in the TI process .pro file as property 1217 http://www.tm1forum.com/viewtopic.php?t=11770 It is, but interestingly it's not written to the .pro file until you do a data save. Until then the flag exists in memory only. This i...
by Alan Kirk
Thu May 03, 2018 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Entering Data in TM1 web on a C level Calc
Replies: 3
Views: 260

Re: Entering Data in TM1 web on a C level Calc

Has anyone had any issues where in TM1 web you enter a value in a C level calculated field and it goes back to its original number? It happens on a few lines but some take the value in TM1 web. its very odd. Any insight would be greatly appreciated. The default behaviour for entering into a consoli...
by Alan Kirk
Thu May 03, 2018 4:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1
Replies: 14
Views: 514

Re: tm1

we can create cubes and dimensios without scripting by using ti process though why we are using scripting to create plzzz help me out Why does anyone ever use scripting / programming? But hey, if you would prefer to get a stack of printouts from your ERP system, and type every element name into the...
by Alan Kirk
Tue May 01, 2018 10:24 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 20154

Re: Copying Data from 1 Element to Another via TI

Hello there, After doing this process, It raised an error in the Data Tab that "NVALUE" isn't defined. Anything I missed? Thanks a lot, Mohamed Al-Bana. I think we would need to see the code before we could answer that. However at a guess, you have tried to use NValue with a data source that is not...
by Alan Kirk
Mon Apr 16, 2018 6:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Logs - Access Rights Required
Replies: 6
Views: 410

Re: Transaction Logs - Access Rights Required

Your approach with TIs sounds interesting. Do you not have challenges with this approach, when for example, you want to back out all transactions for a specific date ranges, user, element etc. I guess one would need a TI that read through all log files that are date stamped between a specific range...
by Alan Kirk
Mon Apr 16, 2018 1:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Logs - Access Rights Required
Replies: 6
Views: 410

Re: Transaction Logs - Access Rights Required

From what I can see, only users in one of the 3 admin roles can view the transaction log Only admins, anyway. I'm not sure if it's all three types because I regard the two newer groups as being a waste of space which were the result of regulatory demands to be Seen! To! Be! Doing! Something! after ...
by Alan Kirk
Wed Apr 11, 2018 8:13 pm
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 4
Views: 582

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

The third and final part of the current TM1 Nybbles sub-series on Windows Hints and Tips wraps up with an episode on useful tools. Of course, chances are that none of these will be unfamiliar to many if not most experienced TM1 users; Notepad++, 7Zip and WinMerge, including the TM1 language definiti...
by Alan Kirk
Tue Apr 10, 2018 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Performance Tuning
Replies: 2
Views: 285

Re: TI Performance Tuning

Specifically "Completing Prolog"is the status which i see for the long time i.e for couple of minutes at least. You can't trust that. Remember that these actions are happening on the server, while the dialogs are on the client. Sending exact, precise, up to the minute information about what is happ...
by Alan Kirk
Mon Apr 09, 2018 8:37 am
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 4
Views: 582

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

You aren't going to reconsider having a separate channel for the TM1 content verusus your gaming reviews? Ever see Robin Hood: Prince of Thieves where Little John says to Robin "You've stirred up a bloody hornet's nest now!" Same principle. That's not an original thought. Indeed in the first episod...
by Alan Kirk
Sun Apr 08, 2018 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: 10.2 Series
Replies: 47
Views: 21262

Re: Fix Pack Releases: 10.2 Series

There are some security vulnerabilities in Java (I'll bet you've never heard those words before) which gave rise to a couple of new Interim Fix packs for 10.2.0 and 10.2.2 FP7. Links to the relevant pages are in the main post.
by Alan Kirk
Fri Apr 06, 2018 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cheking File Size
Replies: 3
Views: 327

Re: Cheking File Size

vishalpoddar90 wrote:
Fri Apr 06, 2018 7:00 am
Is there any function in TI process to check the size of a file. I tried google and tm1 reference guide but couldn't find anything.
If not, is there a way to get the returnvalue from Executecommand().
"Size" in what sense; rows, bytes, kilobytes...?
by Alan Kirk
Wed Apr 04, 2018 10:48 pm
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 4
Views: 582

TM1 Bytes And Nybbles Series on The TM1 Channel

The 5th episode of the TM1 Nybbles series went up an hour ago. TM1 Nybbles is the short form series; a maximum of 16 minutes of actual content plus intros, recaps and outros. (OK, one of them ran over by 33 seconds, but it'll average out.) You can spot them by the fetching shade of green on their th...
by Alan Kirk
Tue Apr 03, 2018 8:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Installing PAW on Window Server 2012 R1 on VM
Replies: 2
Views: 428

Re: Installing PAW on Window Server 2012 R1 on VM

Hello, Anyone running PAW on a Windows 2012 R2 Server in a VMWare environment? Does it work well? Any performance problems? Thanks in advance for sharing your experiences. I can't help you with that one, because I weighed up the options and decided that I wasn't going to bother even installing a te...
by Alan Kirk
Wed Mar 14, 2018 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help
Replies: 11
Views: 829

Re: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help

TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help The usual cause is that the values aren't really zero but really tiny way-down-in-the-decimal-places values, usually derived from rules. I'd slice the view in question and format Excel to show the maximum numbe...
by Alan Kirk
Wed Mar 07, 2018 7:05 am
Forum: General
Topic: Request for help in a Quixotic quest against a useless Microsoft dialog
Replies: 6
Views: 2216

Re: Request for help in a Quixotic quest against a useless Microsoft dialog

A small victory. No, we aren't rid of the Dialog From Hell, but at least MS has finally restored the Recent folders (complete with pinning ability) in the Office 365 incarnation of Excel 2016, version 1802 build 9029.2167. Oddly it's not in "What's New".
by Alan Kirk
Thu Mar 01, 2018 7:04 pm
Forum: Useful code, tips and tricks
Topic: Recovering when an N element has been made a consol
Replies: 5
Views: 671

Re: Recovering when an N element has been made a consol

Very useful Paul, thanks. For ones like that you may want to post them straight into Useful Tips. (As an MVP you have access.) I'll shift this one over.
by Alan Kirk
Wed Feb 21, 2018 2:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 8
Views: 2472

Re: Fix Pack Releases: PA2 / V11 Series

There has been a new release; 2.0.4 . This is the end of the line for the 32 bit server. It will cease to be in the 2.0.5 release. (Actually I'm surprised that it has lasted this long. I don't imagine that trying to run PAX or PAW from a 32 bit box would be a pleasant experience.) There will also be...
by Alan Kirk
Mon Feb 05, 2018 11:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore resubmitting itself when Locked out by another Process
Replies: 4
Views: 431

Re: Chore resubmitting itself when Locked out by another Process

First, welcome back. As far as I'm aware it's been a few years since you darkened the doorstep.

Second, could you please advise which version you're on now? Your profile still says 9.0, which seems unlikely.