Search found 3516 matches

by Alan Kirk
Tue Aug 21, 2018 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration Directoy
Replies: 3
Views: 63

Re: Configuration Directoy

Mind to share what you have because I did spend an hour to research here and Google and the results are not helpful. The closest I got was: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_locationofthetm1s.cfgfile_n15038e.html This is not somet...
by Alan Kirk
Mon Aug 20, 2018 4:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot connect to TM1 Admin server from perspectives
Replies: 3
Views: 69

Re: Cannot connect to TM1 Admin server from perspectives

I am unable to connect to TM1 server from perspectives as a non-admin user. It is showing error as cannot connect to Tm1 admin server. i was able to connect to TM1 server when i logged in as admin user. The admin server has nothing at all to do with whether a person is an admin user or not. The adm...
by Alan Kirk
Fri Aug 17, 2018 9:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text File TI reads is retained in memory...?
Replies: 3
Views: 67

Re: Text File TI reads is retained in memory...?

Your profile shows both 10.2.2.7 and PA2, but you haven't indicated which one this is in. Unless it's PA2 and the server team has done something funky relating to this in PA2 (which I doubt), I don't think that what you suspect is in fact happening. You need to disregard the preview window. It will ...
by Alan Kirk
Fri Aug 03, 2018 10:47 pm
Forum: Bugs
Topic: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash
Replies: 0
Views: 46

Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

I haven't submitted this at this point because I need to check whether this is just a "my machine" thing or something that applies to everyone. Environment: Windows 10 professional 64 bit. TM1 10.2.2 FP 7 Excel 2016 ( 64 bit ) from Office 365. Note particularly the "64 bit" part which is where I sus...
by Alan Kirk
Sun Jul 08, 2018 4:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem getting PAW to run properly
Replies: 3
Views: 270

Re: Problem getting PAW to run properly

dr.nybble wrote:
Wed Jul 04, 2018 12:44 pm
Try to run the scripts/launch.ps1 script to see if you can access PAW directly against the container IP address.
"Error: No such object: pa-gateway"

But you do get a nice instance of Chrome out of it.

I am so sick of banging my head against Docker that I cannot even speak of it.
by Alan Kirk
Thu Jun 28, 2018 7:18 pm
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 7
Views: 965

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

I plead ignorance, but what is "Farm Manager?" Empirically? A piece of software whose videos attract ratings 30 to 40 times better than videos on TM1 do. In practice? A clickfest where the numbers are so randomised that they make any sort of meaningful analysis / strategic planning pointless, which...
by Alan Kirk
Thu Jun 28, 2018 6:19 am
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 7
Views: 965

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

Does this scenario sound familiar? You open Server Explorer. You open Cube Viewer. You click on a dimension tile to change the selection. And nothing seems to happen. When you click on any other part of Cube Viewer all you get is an insistent "ping! ping! ping!" from Windows. No, TM1 isn't broken, i...
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: 366

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

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

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

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

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

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

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

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: 7
Views: 965

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

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: 7
Views: 965

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

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

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