Search found 3631 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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?...
by Alan Kirk
Tue Aug 20, 2019 3:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 15
Views: 8915

Re: Server Locked after save data process and save data is running for a long time .

I don't believe this; they STILL haven't fixed this as of 2.0.6. I kept getting: 12608 [648] ERROR 2019-08-20 12:15:01.891 TM1.Server sf_DeleteFile: Error on file "Path:\CubeName}vues\zRBXZeroOut.vue$". Error = error code:32 reason:"The process cannot access the file because it is being used by anot...
by Alan Kirk
Fri Aug 16, 2019 1:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Auto-Rebuild
Replies: 1
Views: 1927

Re: Active Form Auto-Rebuild

I know I should know the answer to this but is there a setting somewhere that will cause an Active Form to rebuild automatically whenever a new value is selected from a SUBNM formula in TM1web? Interestingly I can't find a way to make that NOT happen in PA2. I know that in older versions I did some...
by Alan Kirk
Sat Aug 03, 2019 6:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is difference between adding variables in prolog and data?
Replies: 2
Views: 1758

Re: What is difference between adding variables in prolog and data?

Hello Everyone, I want to know what is difference between adding respective variable in prolog and data tab ? variables are:- i=1; nCounter1 = 1; nCounter2 = 1; nCounter3 = 1; nCounter4 = 1; My condition is: my variables are in data but I am assigning it in prolog, cause if i keep it in prolog it r...
by Alan Kirk
Mon Jul 29, 2019 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 18
Views: 21338

Re: Fix Pack Releases: PA2 / V11 Series

PAL 2.0.8 has been made available last week: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/c_rel_notes_planning_analytics_2_0_8.html A moderator can remove this post in the thread, it is just a general notification to the community. When the links ...