Search found 3594 matches

by Alan Kirk
Sat Mar 28, 2020 2:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 6
Views: 717

Re: @= in active sheet formula

In both PAfe and perspectives version 2.0.43 / TM1 Build 11.5 I can see that =@DBRW causes the type over write back to fail, instead just ending up with the value you entered in the cell? Any ideas what release this was fixed in or does the defect still exist in the 2.0.9 series? I can't speak for ...
by Alan Kirk
Fri Mar 27, 2020 7:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 15
Views: 19021

Re: Fix Pack Releases: PA2 / V11 Series 2.0.9 IF2.1

This has now been released: PAL 2.0.9 IF2.1 (28 Mar 2020) Release Page . Fixes: PLANNING ANALYTICS MICROSOFT FOR EXCEL: GENERATING SOME VIEWS FOR A SECOND TIME ARE TAKING AN EXTREME AMOUNT OF TIME SERVER CRASH IN STARGATE CREATION PROCESS::'FINALIZEINCATCHBLOCK()' TM1SERVER CRASH: DUE TO AN MDX POST...
by Alan Kirk
Wed Feb 26, 2020 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess in a scheduled chore causes server crash
Replies: 3
Views: 333

Re: RunProcess in a scheduled chore causes server crash

This may have been brought up before, so forgive me if that is the case. Looks like using RunProcess in a process executed by a scheduled or startup chore will crash the server. For which version? You have two specified in your profile. I have a bunch of scheduled chores which use RunProcess and I'...
by Alan Kirk
Tue Feb 25, 2020 2:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation sum error - negative weighting
Replies: 8
Views: 420

Re: Consolidation sum error - negative weighting

Your clue is right here: PC Amount is 122,663.31 ( and when exported to Excel has 20 "0's) after PO Amount is same Net Commitment shows as 0.00000000014551915223 rather than 0.00 You get this effect if you have tiny decimal amounts way out on the horizon. If you're importing values, then round them ...
by Alan Kirk
Fri Feb 14, 2020 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Writing a Single Dynamic TI process to load data from multiple files
Replies: 4
Views: 299

Re: Writing a Single Dynamic TI process to load data from multiple files

Hello TM1 Gurus, I am a newbie in to world of TI & simple google search couldn't answer my query hence seeking your suggestions. Suppose I have files for each month named "YYYYMM_ABCD" having exactly same columns(eg. AA, BB, CC, DD). I need to write a single dynamic TI process which can read these ...
by Alan Kirk
Wed Jan 22, 2020 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Value is not computing after adding existing element to a dimension?
Replies: 4
Views: 277

Re: Value is not computing after adding existing element to a dimension?

What is the exact structure of the dimension ? Its a hierarchical dimension with alternate hierarchy, its just made for ease of user. I think what Wim meant was this : 5) For Rules and TurboIntegrator processes, posting the actual code and the real names of and structures of your cubes, dimensions ...
by Alan Kirk
Mon Dec 30, 2019 8:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advanced Rules Editor on PA
Replies: 7
Views: 398

Re: Advanced Rules Editor on PA

Hi guys, I am facing difficult to launch advacend rules editor on Planning Analytics version 2.0.8. ... The Architect client version it is 64 bits. There is some on internet saying that it works on 32 bits version, but this is for version 10.2 I think. If you're referring to this article , it may b...
by Alan Kirk
Tue Nov 26, 2019 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New monitor
Replies: 7
Views: 618

Re: New monitor

Guilty ! But it’s part of a much bigger AHK script which saves a lot of time. A tip for those who use the same approach as me: use the Insert key on the clipboard to start custom tools in AHK. Insert is a key that is located centrally on my keyboard and which I don’t care about giving up. I never u...
by Alan Kirk
Mon Nov 25, 2019 11:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New monitor
Replies: 7
Views: 618

Re: New monitor

Thanks Garry and Alan. As long as you know the three ways to get around it ( https://www.youtube.com/watch?v=xXXrw1sXbD0 ) it's not really a problem. Or a 4th option that I use: write a small AutoHotKey script that changes the tm1p.ini file after pressing a shortcut key. Yyyyessss, though... Sledge...
by Alan Kirk
Mon Nov 25, 2019 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New monitor
Replies: 7
Views: 618

Re: New monitor

Hello all, I am going through the process of selecting a new monitor to connect to my laptop. This should be a rather pleasant activity :-) I would go for a 27" screen with resolution of either 2560x1440 or 4K (3840x2160). However, the problem is Architect / Perspecties. Can you use it on higher re...
by Alan Kirk
Thu Nov 07, 2019 7:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 installation
Replies: 1
Views: 216

Re: TM1 installation

I need to install TM1 in my personal laptop, can any one suggest me where I can get software free version. If possible pls provide me URL will be more helpful. I'm going to give you the benefit of the doubt here and treat this post as asking whether a free version of TM1 exists. (To which the answe...
by Alan Kirk
Tue Nov 05, 2019 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock codes
Replies: 5
Views: 1450

Re: Bedrock codes

See this post.

Note that whatever you've taken a screenshot of is showing Bedrock 3 processes. Bedrock 4 ones are preceded by a brace.
by Alan Kirk
Thu Aug 29, 2019 8:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] Writeback in Cube with VBA
Replies: 9
Views: 9401

Re: [Excel] Writeback in Cube with VBA

Its a bigger calculation with % Keys, its my Forecasting Tool, now i wanna try to impement an Autoupload to TM1. @Alan, i thought DB S stands for "String" and DB SS "Send String". Which is why it's kind of important to consult the reference guide . (This is an older version's copy but IBM keep shif...
by Alan Kirk
Thu Aug 29, 2019 7:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] Writeback in Cube with VBA
Replies: 9
Views: 9401

Re: [Excel] Writeback in Cube with VBA

Hello friends, i was woundering about if it is possible to writeback a Value to a cube using VBA? If i use Application.Run with the DBRW Formula it just gets the value and i can't change. Any hint for me? Thanks and BR Only that maybe DB =>RRRR <===ead isn't the best formula to use when you want to...
by Alan Kirk
Tue Aug 27, 2019 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Excel] TM1 Get Value from Cube VBA
Replies: 2
Views: 6413

Re: [Excel] TM1 Get Value from Cube VBA

You don't put the arguments to DBR in brackets like that when you are using Application.Run. DBR is the first argument (in quotes), and the other arguments are separated by commas.
by Alan Kirk
Mon Aug 26, 2019 7:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 12062

Re: What's coming up in the TM1 Server?

Sounds interesting. Personally I think they should find something that actually CAN replace the TI part. Otherwise we will have three different "languages". I'm not sure that would be possible or even desirable. Hubert said that his intention was to provide an alternative to what people are current...
by Alan Kirk
Mon Aug 26, 2019 9:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 12062

Re: What's coming up in the TM1 Server?

Thx for sharing! I'm very curious to hear more about that "scripting language" in the coming years. In a way I hope that its not a new language but just regular javascript or python or something. There isn't that much more to hear yet; as Hubert said, options are still being explored. At a previous...
by Alan Kirk
Mon Aug 26, 2019 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 12062

Re: What's coming up in the TM1 Server?

tomok wrote:
Fri Aug 23, 2019 12:32 pm
Alan Kirk wrote:
Fri Aug 23, 2019 7:47 am
Pro tip: Keep your eyes on the right hand side of the screen.
So, apparently you're not Mark Harmon's twin. Surprise, surprise.
Add a few cm, take off more than a few kg, close enough.
tomok wrote:
Fri Aug 23, 2019 12:32 pm
You are a pretty good interviewer though.
Kind of you to say!
by Alan Kirk
Fri Aug 23, 2019 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 12062

Re: What's coming up in the TM1 Server?

gtonkin wrote:
Fri Aug 23, 2019 7:57 am
Thanks Alan, will wear my left eye patch to be sure.
I look slightly better in this unlisted one, which is about the split topics of the Forum and about the future of AI. I need to wear black more: https://www.youtube.com/watch?v=-SqF78PjofA
by Alan Kirk
Fri Aug 23, 2019 7:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 12062

What's coming up in the TM1 Server?

An interview with Hubert Heijkers, chief architect for the TM1 server, at the TM1 conference in Sydney: https://www.youtube.com/watch?v=tL3puB0AK74 Pro tip: Keep your eyes on the right hand side of the screen. Also, an interview with Manny on the subject of innovation: https://www.youtube.com/watch?...