Search found 63 matches

by bgregs
Fri Sep 25, 2020 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web , Commit data entry and run a TI
Replies: 1
Views: 97

Re: TM1 Web , Commit data entry and run a TI

Hi Steve, Not quite the same scenario, but I had something somewhat similar where I needed to have an active form take into account a variable (drop down driven) MDX subset prior to returning data - all in the same sheet on a single button click event. What ended up working for me was to set recalc ...
by bgregs
Thu Sep 24, 2020 7:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets In Rules
Replies: 2
Views: 105

Subsets In Rules

I recently was playing around with some of the new (and by "new" I mean "new to me") TM1 rule functions, and stumbled across something that may be interesting to others. Thank you PavoGa for your help in testing and validating this thing! For a while, we've known about the ability to use subsets in ...
by bgregs
Mon Aug 03, 2020 1:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A Simple Architect Replacement for Linux
Replies: 3
Views: 263

Re: A Simple Architect Replacement for Linux

@asutcliffe Thank you for checking out the project! You hit on a couple points that I thought would be good to address in order to clarify the state of application. Compiling and Installing: The Makefile is admittedly very lightweight. I do plan on adding some dependency checking and better handling...
by bgregs
Tue Jul 28, 2020 8:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A Simple Architect Replacement for Linux
Replies: 3
Views: 263

A Simple Architect Replacement for Linux

A while back I started playing around with GUI design using the GTK library (completely unrelated), and used TM1's Architect as a simple model. Fast forward a few months of on/off (mostly off) development, and I ended up with a project that actually had a bit of potential. What I now have is a GUI f...
by bgregs
Fri Jul 10, 2020 1:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Stack Frame for Function Returns
Replies: 2
Views: 403

TM1 Stack Frame for Function Returns

* Mods feel free to move this if it is in the wrong place! In an attempt to simplify child -> parent return data, I decided to see if I could implement a reliable stack structure within TM1 to easily pass values between functions without having to write anything to a cube. My main requirements were:...
by bgregs
Fri Feb 21, 2020 3:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Rand(Random) Function
Replies: 16
Views: 7421

Re: Using Rand(Random) Function

I apologize in advance for necro-ing a very, very old thread, but I felt the need to clear the air on how TM1 implements random numbers. The article referenced in the previous post (everanalytics) misses the entire point of the RAND implementation, and quite frankly is establishing the obvious truth...
by bgregs
Thu Jan 16, 2020 2:29 pm
Forum: Commercial and Events
Topic: TM1 Syntax File for VIM
Replies: 2
Views: 909

TM1 Syntax File for VIM

Hi Everyone! I may be the only one on the planet that uses VIM as their go-to text editor, but in case there are others, hopefully this syntax highlighter helps! I threw this together a little over a year ago for basic "quality of life" improvements when looking at .pro files in VIM, and it seems to...
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: 559

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

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

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

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

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

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

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

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

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

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

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

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

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