Search found 69 matches

by bgregs
Sun Feb 28, 2021 8:10 pm
Forum: General
Topic: Free and Open Source Tools: Public Permissions?
Replies: 0
Views: 11

Free and Open Source Tools: Public Permissions?

Hey Mods, The new Free and Open Source Tools section is awesome - thank you for putting that together! I agree, it definitely helps keep things organized and helps to redirect traffic to the right places. The only thing I've noticed is that this new section does not appear to be publicly accessible....
by bgregs
Fri Feb 19, 2021 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 810

Re: Monaco TM1 Editor with Intellisense

Updates First off, thank you all for your support. I honestly never expected this to garner much interest, but I'm thrilled to have people looking at it - really, I appreciate all of your feedback! Now let's get into the updates. It was recently brought to my attention that there is a desire to por...
by bgregs
Thu Feb 18, 2021 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 810

Re: Monaco TM1 Editor with Intellisense

Thanks Bakkone! Not to turn this thread into an extension of GeekHack or Deskthority, but the MK world is a wonderful and painful place all at the same time. On one hand, there's a never ending supply of stuff to learn and things to try, but your wallet always takes a hit. ;) I've unfortunately fall...
by bgregs
Wed Feb 10, 2021 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 810

Re: Monaco TM1 Editor with Intellisense

Rolling Update Post (so I don't continue to necro this old thread): 2/10/21 - A bit more polish, a few quality of life tweaks, and the groundwork for a more robust notification system: CAM authentication now supported (see config file for new parameters) README updated to provided installation and ...
by bgregs
Mon Feb 01, 2021 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 810

Re: Monaco TM1 Editor with Intellisense

@Edward @Bakkone Thank you both for your kind words and for taking the time to look through the project! I apologize for the long delay - I need to make a habit of checking the forums more often. I'm finally wrapping up some completely unrelated projects that consumed a lot more of my time than I or...
by bgregs
Fri Dec 18, 2020 7:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monaco TM1 Editor with Intellisense
Replies: 12
Views: 810

Monaco TM1 Editor with Intellisense

UPDATE ***************************************************************************************************************************************** This project will remain in its current state, but is being replaced by the TM1Code - VS Code extension project: https://www.tm1forum.com/viewtopic.php?f=...
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: 327

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

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

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

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

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

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

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

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

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

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

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

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

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

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