TM1 Forum

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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.

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

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

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!

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

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