Search found 3582 matches

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

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

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

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

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

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

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

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

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

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

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

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: 13
Views: 6364

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 ...
by Alan Kirk
Fri Jul 19, 2019 11:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 417

Re: Why IBM should sell off TM1 by James Wakefield

I wonder if he remembers - I don't (but I'm entitled not to :shock: ) I hope that's not an ageist slur upon yourself there David! After all, {mumble} is the new 20. Just look at the new Top Gun movie. A guy in his late 50's is still supposedly flying front line fighter missions as if almost 4 decad...
by Alan Kirk
Fri Jul 19, 2019 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 417

Re: Why IBM should sell off TM1 by James Wakefield

Hi Gurus, I know I am opening a pandora's box out here, but being a passionate TM1 lovers, how much do you agree with James on the below: https://www.linkedin.com/pulse/why-ibm-should-sell-off-tm1-james-wakefield/ Thanks I think that it's a really interesting piece of writing. Thanks for bringing i...
by Alan Kirk
Mon Jul 15, 2019 5:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Communal activity - nominate your favourite FAQ
Replies: 0
Views: 1007

Communal activity - nominate your favourite FAQ

The once-mighty FAQ thread is in desperate need of a refurbishment. Dust, cobwebs, and references to sub-versions of version 8 can be found everywhere. At present it looks like a deceased estate. Rather than just rely on what I think should be in there, here's an opportunity for everyone to nominate...
by Alan Kirk
Mon Jul 15, 2019 4:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM Usage much larger than Cubes
Replies: 3
Views: 305

Re: RAM Usage much larger than Cubes

Hi Mark Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it. It can be found here , in fact. I've also added it to Miss Havisham's fav...
by Alan Kirk
Sun Jul 14, 2019 1:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 14
Views: 1218

Re: Bedrock 4 for IBM Planning Analytics is available

Personally, I don't think I'll be jumping into the Bedrock 4 pool all that soon. I have it on all of my servers, but this morning was my first encounter with using it. It was not auspicious. It was a call to }bedrock.cube.viewandsubsets.create, with pLogOutput set to 1. Yeah, all good, hunky dory, n...
by Alan Kirk
Tue Jul 09, 2019 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 17
Views: 3389

Re: Updating Element Attributes in TI Process

I know I'm very late to the party on this, but today is the first time I'd had cause to use this function. It appears that if you feed an MDX expression into the third argument to update the subset: SubsetMDXSet(dimension, subsetname, [MDX_expression]); Then the function just leaves it as a dynamic ...
by Alan Kirk
Wed Jul 03, 2019 10:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Guide
Replies: 5
Views: 364

Re: PAW Guide

Hi everyone! Does anybody have any kind of Guide or Manual for Planning Analytics Workspace? Basically to know what you can do or what can you show with it once you have the Views on Architect. I have watched the videos from the IBM YouTube channel and their Web Knowledge Center, but if you have an...
by Alan Kirk
Tue Jul 02, 2019 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 2.0.6 - Bogus Timeouts
Replies: 4
Views: 590

Re: TM1 Web 2.0.6 - Bogus Timeouts

We just upgraded our system to PA 2.0.6 over the weekend and a couple of users (well, me so far but I'm expecting more as they get to the office today) hit this one. Ops Console was fine by the way. The password change trick didn't work for me (either via Perspectives or Web). But what does seem to...