Search found 56 matches

by bgregs
Thu Feb 28, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rebuilding Websheets Twice in One Event
Replies: 1
Views: 166

Rebuilding Websheets Twice in One Event

Hi Everyone, I recently came across an interesting situation where I had an Active Form with 2 tm1rptrow columns, one of which was based off of the results of the first tm1rptrow function. I saw a few posts discussing how this either wasn't possible, or there were some workarounds dealing with tempo...
by bgregs
Tue Jan 15, 2019 1:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 4075

Re: TM1 REST API

Hi Wim, I had a chance to play with the REST API a little more and narrowed down your question number 4 to the "ActiveConfiguration" metadata parent. Basically, everything is summed up under 4 categories: Active Configuration: Access Administration (this is what you are looking for) Modelling Perfor...
by bgregs
Mon Jan 14, 2019 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 4075

Re: TM1 REST API

@Wim - sorry! This is my last post, I promise :) @Lotsa Thank you for taking the time to respond! I realize maybe my posts were too blunt, and I apologize, I hope there are no hard feelings. I must say I did not expect tm1py to have such a strong support network. If the community here thinks that I'...
by bgregs
Thu Jan 10, 2019 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 601

Re: Old TM1 version

@Alan Kirk,

My god that explains the random macros that I stumbled across!! These are still hanging around as of PA 2.0 under the name "IMPEXP_WORKS" and can still be mapped into the Quick Access Ribbon by looking under the "Macros" drop-down. ;)
by bgregs
Tue Jan 08, 2019 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FileExists function returns 1 even when file is not present
Replies: 2
Views: 467

Re: FileExists function returns 1 even when file is not present

Hi!

Would you be able to post the code that is encountering the error? If you have a variable that is holding the file path, could you also post the declaration of that as well? The more the better! :D
by bgregs
Tue Jan 08, 2019 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 4075

Re: TM1 REST API

@David, I'll start by saying I full agree, and that by no means did I intend to downplay the significant improvement to the REST API that tm1py has managed to implement. I respect Marius' commitment to the community and can only imagine how difficult it must be to maintain opensource projects (espec...
by bgregs
Tue Jan 08, 2019 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Indenting dimension elements in Excel
Replies: 5
Views: 535

Re: Indenting dimension elements in Excel

Hi Wim, Another good exercise! I don't have time to test this out right now, but I will definitely take a stab at it when I get some time! I found the following function in the VBA API that looks like it _could_ be the function that returns the right information to build out the hierarchy. Again, th...
by bgregs
Mon Jan 07, 2019 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 4075

Re: TM1 REST API

Just my 2 cents, tm1py is a great library, but its biggest downfall is that it is not heavily supported. I've experimented with it throughout the years, but even now it looks like it's last update was almost a month ago. Depending on what your use case is, it could be a perfect fit. As a general rul...
by bgregs
Thu Jan 03, 2019 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives interacts with other VBA code in Personal.xlsb
Replies: 17
Views: 1380

Re: TM1 Perspectives interacts with other VBA code in Personal.xlsb

WOW!!! Great job on digging that one up! I'm honestly surprised that this is the first time it's come up (with the variety of keyboards/layouts that exist in the wild), but either way, I guess we can look forward to an update in the next fix pack ;) Nicely done!
by bgregs
Wed Jan 02, 2019 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives interacts with other VBA code in Personal.xlsb
Replies: 17
Views: 1380

Re: TM1 Perspectives interacts with other VBA code in Personal.xlsb

Not a problem! Feel free to send any verification requests over my way! :D
by bgregs
Wed Jan 02, 2019 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives interacts with other VBA code in Personal.xlsb
Replies: 17
Views: 1380

Re: TM1 Perspectives interacts with other VBA code in Personal.xlsb

Hi Wim, This sounded like a pretty interesting problem to kick off the new year with, so I figured I'd give it a go. Unfortunately, I was unable to reproduce the issue you are encountering. The following are the things I've tried (please let me know if I didn't recreate a step correctly): Opened Exc...
by bgregs
Fri Dec 21, 2018 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 17
Views: 1350

Re: Notepad++ 7.6 for TM1 process and Rules

Great summary! For the sake of sharing, my personal preference is to edit rules and TIs using VIM :o You'd be surprised how powerful it can be. Delete everything inside the parenthesis (or brackets, quotes, etc.) using 3 characters "d+i+*char*". But yes, notepad++ does have better syntax highlightin...
by bgregs
Mon Dec 17, 2018 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives - Prompt when closing Excel?
Replies: 6
Views: 454

Re: TM1 Perspectives - Prompt when closing Excel?

Hi Everyone, Maybe I'm misunderstanding, but this is extremely easy to do with a custom add-in (however I agree that I don't quite understand why this would be needed). Create a new module in a blank workbook and put the following code in there: Private Sub Auto_Open() Dim wb As Workbook Set wb = Wo...
by bgregs
Fri Dec 14, 2018 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives - Prompt when closing Excel?
Replies: 6
Views: 454

Re: TM1 Perspectives - Prompt when closing Excel?

A few ideas come to mind, but nothing pretty. Excel will prompt you to save an open workbook if you have made a change to it, which means we could potentially use that in our favor through one of two options: A) Put a space or some random character into a cell of the blank workbook that opens on sta...
by bgregs
Mon Dec 10, 2018 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 5
Views: 705

Re: TM1 server crash

Do you have a backup that was taken before the server migration you could test? This line: The TM1 service may not have been shut down completely prior to copying the model really sounds like it could be the cause. If you don't have a backup to test with, then calling IBM may be your best bet (unles...
by bgregs
Mon Dec 10, 2018 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 5
Views: 705

Re: TM1 server crash

Not entirely sure, but sounds like this *could be* related:

https://www-01.ibm.com/support/docview. ... wg21654717
by bgregs
Fri Dec 07, 2018 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 11
Views: 1014

Re: issues with moving TI processes

What if you create a new process while the server is running? Right click the "Processes" node and create a new one with a random name. Is that process visible? I'm out of ideas at this point, so just trying to isolate what works and what doesn't.
by bgregs
Thu Dec 06, 2018 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 11
Views: 1014

Re: issues with moving TI processes

Are you admin on the dev server? If not, login with an admin account and update your }ProcessSecurity cube to provide READ access to the new processes.
by bgregs
Wed Dec 05, 2018 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to Kill Thread in TM1 TOP
Replies: 2
Views: 559

Re: Unable to Kill Thread in TM1 TOP

You will probably need to kill the process on the SAP side. In my experience, 9 times out of 10 this is a hang up on the SAP side (especially with HANA... :roll: ).
by bgregs
Tue Nov 20, 2018 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on Network vs Stand-Alone
Replies: 9
Views: 1036

Re: TM1 Perspectives on Network vs Stand-Alone

I really think you may want to involve an "IT person" in this particular case. Can you clarify what exactly you are trying to accomplish? You mentioned hosting Perspectives on a shared drive, which you definitely should not do. Perspectives creates configuration files per user... If you want to acco...